How to send textbox value and save it to sql database?

Question

Hi everyone I have textbox = numberic value(eNTER numberic) submit = button After enter values in the text box.. submit the value and its should update in the sql table. [table already created in sql) I having problem with submitting value and saving part into sql. Any sample please.. Thanks everyone

Jignesh Trivedi · Answer

hi Try.. Client Side Server side. var k = Convert.ToInt32(Request.Params[txt1]); OR var k = Convert.ToInt32(txt1.Text); SqlConnection con = new SqlConnection(strConnString); con.Open(); com = new SqlCommand(insert into employee (columnName) values(' + txt1.Text + ') con); com.ExecuteNonQuery(); com.Dispose(); con.Close(); hope this help.

Satyapriya Nayak · Answer

Hi Suji com = new SqlCommand(Update into Sparepartslist values(@Current Quantity) dbCon); Your update command is not correct See the below code and do it accordingly. com=new SqlCommand(update Sparepartslist set Current Quantity=@Current Quantity where Category=@Category dbCon); com.Parameters.AddWithValue(@Category txtCategory.Text); com.Parameters.AddWithValue(@Current Quantity txtQuantity.Text); com.ExecuteNonQuery(); Thanks

shshva · Answer

Error :Incorrect syntax near 'nvarchar'. Whenever update the values in the text box.. its not submitted and update in database. Thanks and regards Here is my code : namespace sys.System { public partial class spareedit : System.Web.UI.Page { SqlConnection dbCon = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings[sqlServer2].ConnectionString); protected void Page_Load(object sender EventArgs e) { if (!IsPostBack) { dbCon.Open(); SqlCommand cmd = new SqlCommand(SELECT [Category][Part Number][Description][Contract][Current Quantity][Site] FROM [demo].[dbo].[Sparepartslist] where [Part Number] = ' + Request.QueryString[id] + ' and [site] = ' + Session[site] + ' dbCon); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { lblDescription.Text = dr[Description].ToString(); lblpartnumber.Text = dr[Part Number].ToString(); lblContract.Text = dr[Contract].ToString(); txtQuantity.Text = dr[Current Quantity].ToString(); } dr.Close(); dbCon.Close(); } } protected void txtQuantity_TextChanged(object sender EventArgs e) { } protected void Button1_Click(object sender EventArgs e) { string str = txtQuantity.Text; SqlCommand com; dbCon.Open(); com = new SqlCommand(Update into Sparepartslist values(@Current Quantity) dbCon); com.Parameters.AddWithValue(@Current Quantity txtQuantity.Text); com.ExecuteNonQuery(); com.Dispose(); dbCon.Close(); Response.Write(Records successfully updated); clear(); } void clear() { txtQuantity.Text = ; } } }

Satyapriya Nayak · Answer

Hi Suji Try this... Untitled Page function IsNumber(sourcearguments) { var ValidChars = 0123456789.; var Char; var sText=document.getElementById(txtsal).value; for (i = 0; i { Char = sText.charAt(i); if (ValidChars.indexOf(Char) == -1) { arguments.IsValid = false; return; } } return; } Text=Insert/> using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; namespace only numeric values { public partial class WebForm1 : System.Web.UI.Page { string strConnString = ConfigurationManager.ConnectionStrings[ConnectionString].ConnectionString; string str; SqlCommand com; protected void btn_insert_Click(object sender EventArgs e) { SqlConnection con = new SqlConnection(strConnString); con.Open(); com = new SqlCommand(insert into employee1 values(@sal) con); com.Parameters.AddWithValue(@sal txtsal.Text); com.ExecuteNonQuery(); com.Dispose(); con.Close(); Response.Write(Records successfully inserted); clear(); } void clear() { txtsal.Text = ; } } } Thanks If this post helps you mark it as answer