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

shshva

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

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Trivedi14y ago
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.
0
Satyapriya Nayak14y ago
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
0
shshva14y ago
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 = ""; } } }
0
Satyapriya Nayak14y ago
Hi Suji,

Try this...

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="Insert_data_confirmation.WebForm1" %>

    Untitled Page













            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
0