Saturday, November 27, 2010

Convert number into text in asp.net

Function of convert number into text


public static string NumberToText(int n)
    {
        if (n < 0)
            return "Minus " + NumberToText(-n);
        else if (n == 0)
            return "";
        else if (n <= 19)
            return new string[] {"ONE", "TWO", "THREE", "FOUR", "FIVE", "SIX", "SEVEN", "EIGHT",
         "NINE", "TEN", "ELEVEN", "TWELVE", "THIRTEEN", "FOURTEEN", "FIFTEEN", "SIXTEEN",
         "SEVENTEEN", "EIGHTEEN", "NINETEEN"}[n - 1] + " ";
        else if (n <= 99)
            return new string[] {"TWENTY", "THIRTY", "FORTY", "FIFTY", "SIXTY", "SEVENTY",
         "EIGHTY", "NINETY"}[n / 10 - 2] + " " + NumberToText(n % 10);
        else if (n <= 199)
            return "ONE HUNDRED " + NumberToText(n % 100);
        else if (n <= 999)
            return NumberToText(n / 100) + "HUNDRED " + NumberToText(n % 100);
        else if (n <= 1999)
            return "ONE THOUSAND " + NumberToText(n % 1000);
        else if (n <= 99999)
            return NumberToText(n / 1000) + "THOUSAND " + NumberToText(n % 1000);

        else if (n <= 199999)
            return "ONE LAC " + NumberToText(n % 100000);
        else if (n <= 9999999)
            return NumberToText(n / 100000) + "LAC " + NumberToText(n % 100000);
        else if (n <= 19999999)
            return "ONE CRORE" + NumberToText(n % 10000000);
        else if (n <= 999999999)
            return NumberToText(n / 10000000) + "CRORE " + NumberToText(n % 10000000);
        else if (n <= 1999999999)
            return "ONE BILLION " + NumberToText(n % 1000000000);
        else
            return NumberToText(n / 1000000000) + "BILLION " + NumberToText(n % 1000000000);
    }

Wednesday, November 24, 2010

Refresh grid on button click without loading whole page by using updatepanel

in designing part:


<form id="form1" runat="server">
    <asp:ScriptManager ID="ScriptManager1" runat="server">
    </asp:ScriptManager>
    <div>
        <asp:UpdatePanel ID="UpdatePanel1" runat="server" UpdateMode="Conditional">
            <ContentTemplate>
                <asp:GridView ID="abc" runat="server" DataSourceID="SqlDataSource1" AutoGenerateColumns="False">
                    <Columns>
                        <asp:BoundField HeaderText="ID" DataField="id" />
                        <asp:BoundField HeaderText="Name" DataField="name1" />
                        <asp:BoundField HeaderText="STS" DataField="sts" />
                    </Columns>
                </asp:GridView>
                <asp:Button ID="Button1" runat="server" Text="Button" OnClick="Button1_Click" />
            </ContentTemplate>
        </asp:UpdatePanel>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="data source=c174; initial catalog=newtry; integrated security=true;"
            SelectCommand="select * from table_1"></asp:SqlDataSource>
    </div>
    <div>
        <asp:UpdatePanel ID="UpdatePanel2" runat="server" UpdateMode="Conditional">
            <ContentTemplate>
                <asp:GridView ID="GridView1" runat="server" DataSourceID="SqlDataSource2" AutoGenerateColumns="False">
                    <Columns>
                        <asp:BoundField HeaderText="ID" DataField="id" />
                        <asp:BoundField HeaderText="Name" DataField="name1" />
                        <asp:BoundField HeaderText="STS" DataField="sts" />
                    </Columns>
                </asp:GridView>
                <asp:Button ID="Button2" runat="server" Text="Button" OnClick="Button2_Click" Style="height: 26px" />
                <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="data source=c174; initial catalog=newtry; integrated security=true;"
                    SelectCommand="select * from table_1"></asp:SqlDataSource>
            </ContentTemplate>
        </asp:UpdatePanel>
    </div>
    </form>


in coding part on button click


protected void Button1_Click(object sender, EventArgs e)
    {
      
        UpdatePanel1.DataBind();
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
    
        UpdatePanel2.DataBind();
    }

Save data in Xml

protected void btnSubmit_Click(object sender, EventArgs e)
    {  
        DataSet ds = new DataSet();
        ds.ReadXml(Server.MapPath("XMLFile.xml"));
        DataRow dr = ds.Tables[0].NewRow();
        dr[0] = "By &nbsp; "+txtUserName.Text + "&nbsp; At " + DateTime.Now.ToString("F")+"<br><br>"+txtPassword.Text;
      
        ds.Tables[0].Rows.Add(dr);
      
        ds.AcceptChanges();

        ds.WriteXml(Server.MapPath("XMLFile.xml"));  
    }