How do i enter a single value from textbox in sqlserver?

Question

I have a textbox and a submit button . when i enter anything in the textbox i want it to be stored in the sqlserver
I have multiple columns in database of sqlserver.
how can i enter only one value from textbox and pass other column values as null.

I am new to .net so please help.

Antony

Pankaj Pandey · Answer

replace Mytable with your real table name protected void Button1_Click(object sender, EventArgs e) { SqlConnection con= new SqlConnection(@" Data Source = .\azmath1\SQLEXPRESS; Initial catalog =Category; Integrated Security= True"); SqlCommand cmd = new SqlCommand("insert into Mytable (PCategory) values('"+TextBox1.Text+"')",con); con.Open(); cmd.ExecuteNonQuery(); con.Close(); } and give responce...

Pankaj Pandey · Answer

hello try this.. SqlConnection conn=new SqlConnection("Your Connection String"); SqlCommand cmd = new SqlCommand("insert into tablename (abc) values(@x)", conn); cmd.CommandTimeout = 0; cmd.Parameters.AddWithValue("@x", Textbox.text); conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); Mark as answered if helpful

antony victor · Answer

thankyou all.. there was a sqlserver error... tried in my lappy ..got the output..

Pankaj Pandey · Answer

so now what the result is given? if error shows, then list here followings.. database name server name (copy and paste server name when you start the sql server) table name table script....after that i will create code..you need to just copy and paste

antony victor · Answer

Dear Sir, I have put the connection string SqlConnection con = new SqlConnection(@" Data Source = .\AZMATH1; Initial catalog =Category; Integrated Security= True");

Sunny Sharma · Answer

Dear Antony, you must change the connection string pointing to your own database.

Pankaj Pandey · Answer

then put your connection string and Mytable to table name protected void Button1_Click(object sender, EventArgs e) { SqlConnection con= new SqlConnection("Put your connection String Here"); SqlCommand cmd = new SqlCommand("insert into Mytable (PCategory) values('"+TextBox1.Text+"')",con); con.Open(); cmd.ExecuteNonQuery(); con.Close(); }

antony victor · Answer

I am getting this error code. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) Line 26: Line 27: SqlConnection con = new SqlConnection(@" Data Source = .\azmath1\SQLEXPRESS; Initial catalog =Category; Integrated Security= True"); Line 28: con.Open(); Line 29: String str = "insert into Mytable1 (PCategory) values('" + TextBox1.Text + " ')"; Line 30: SqlCommand cmd = new SqlCommand(str, con);

antony victor · Answer

I have 4 columns namely "id" which i set to autoincrement so it cannot be null... The rest 3 columns PCategory,CCategory and PId are checked to allow null values....

Riddhi Valecha · Answer

Hi... Re-check the database design. Check the "Allow Nulls" column if the database can accept null values... If that column is not checked, then also the values will not be inserted...

Shankar M · Answer

Hi Antony, Does the other columns in the Table Allow Null values ? If so you can write the Insert Statement with the specified column to be Inserted with an Input value.

Pankaj Pandey · Answer

its not so, anyway./..you do not need to replace "@x" with any thing..just copy and pase below code.. replace Mytable with your real table name protected void Button1_Click(object sender, EventArgs e) { SqlConnection con= new SqlConnection(@" Data Source = .\azmath1\SQLEXPRESS; Initial catalog =Category; Integrated Security= True"); SqlCommand cmd = new SqlCommand("insert into Mytable (PCategory) values('"+TextBox1.Text+"')",con); con.Open(); cmd.ExecuteNonQuery(); con.Close(); }

Sunny Sharma · Answer

Nothing, "@x" is just fine. It's only a parameter in your insert string which will be updated with the value in your textbox.

antony victor · Answer

sorry for being so dumb... what should i enter in place of "@x"

Pankaj Pandey · Answer

hiii, You do not need to pass null for others, it by default accept null just try this..it will work, if not then write here. SqlConnection conn=new SqlConnection("Your Connection String"); SqlCommand cmd = new SqlCommand("insert into tablename (PCategory) values(@x)", conn); cmd.CommandTimeout = 0; cmd.Parameters.AddWithValue("@x", Textbox.text); conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); Mark as answered if helpful

antony victor · Answer

I have a textbox and button . upon inserting a data from textbox ,i want to store in database precisely in column Pcategory . The problem is , i have 4 columns namely id , PCategory, CCategory ,ParentId. in database.so how can i pass other columns as null and send only a single data from textbox to column(PCategory) my code is protected void Button1_Click(object sender, EventArgs e) { SqlConnection con= new SqlConnection(@" Data Source = .\azmath1\SQLEXPRESS; Initial catalog =Category; Integrated Security= True"); con.Open(); SqlCommand cmd = new SqlCommand("insert into Mytable (PCategory) values(@PCategory)",con); cmd.CommandTimeout = 0; cmd.Parameters.AddWithValue("@PCategory", TextBox1.Text); cmd.ExecuteNonQuery(); con.Close(); } but textbox value is not inserting into database

Sunny Sharma · Answer

Hi Antony, If all the rest columns are null by default then use this statement INSERT INTO myTable(myColumn) Values(textBox.text); Hope it helps :)

How do i enter a single value from textbox in sqlserver?

Answers (17)