How to get Textbox value in XML format and pass as a parameter using Asp.Net C#

       XmlDocument xmldoc=new XmlDocument();
        XmlElement emp_name = xmldoc.CreateElement(TextBox1.Text);
        string name= emp_name.Name;
        XmlElement emp_salary = xmldoc.CreateElement(TextBox2.Text);
        decimal salary = Convert.ToDecimal(emp_salary.Name);
        string str = "insert into emp values('"+name+"',"+salary+")";
        SqlCommand cmd = new SqlCommand(str,con);
        con.Open();
        cmd.ExecuteNonQuery();
        con.Close();
        BindGrid();
        Response.Write("<script>alert('Successfully saved !')</script>");
        TextBox1.Text = string.Empty;
        TextBox2.Text = string.Empty;
Share:

No comments:

Post a Comment

Tuesday, 28 July 2015

How to get Textbox value in XML format and pass as a parameter using Asp.Net C#

       XmlDocument xmldoc=new XmlDocument();
        XmlElement emp_name = xmldoc.CreateElement(TextBox1.Text);
        string name= emp_name.Name;
        XmlElement emp_salary = xmldoc.CreateElement(TextBox2.Text);
        decimal salary = Convert.ToDecimal(emp_salary.Name);
        string str = "insert into emp values('"+name+"',"+salary+")";
        SqlCommand cmd = new SqlCommand(str,con);
        con.Open();
        cmd.ExecuteNonQuery();
        con.Close();
        BindGrid();
        Response.Write("<script>alert('Successfully saved !')</script>");
        TextBox1.Text = string.Empty;
        TextBox2.Text = string.Empty;

No comments:

Post a Comment

Popular

Total Pageviews

Archive