how can i format figures like 1200000 to something like money figures with comers like 1,200,000
protected void ddlcuomerphone_SelectedIndexChanged(object sender, EventArgs e)
{
DataTable dt = GetDataTable("SELECT SUM (Debt) Debt FROM CustomerDetail WHERE CustomerPhone = '" + ddlcuomerphone.SelectedItem.Text.Trim() + "'");
lbldebt.Text = dt.Rows[0]["Debt"].ToString();
}
<h5>
<asp:Label ID="Label2" runat="server" Text=" Total Debt /" Font-Size="Large" ForeColor="#CC3300"></asp:Label>
<asp:Label ID="lbldebt" runat="server" Font-Size="Large" ForeColor="#006600" />
</h5>
<p class="">
<asp:DropDownList ID="ddlcuomerphone" runat="server" OnSelectedIndexChanged="ddlcuomerphone_SelectedIndexChanged"
AutoPostBack="True" AppendDataBoundItems="true" CssClass="btn btn-default dropdown-toggle">
<asp:ListItem Text="Select Customer Unique Phone Number" Value=""></asp:ListItem>
</asp:DropDownList>
</p>