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

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

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

Dear Antony,

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

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);

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...

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();
        }

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");
      conn.Open();
cmd.ExecuteNonQuery();
conn.Close();




Mark as answered if helpful 

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

hello


try this..


SqlConnection conn=new SqlConnection("Your Connection String");
      conn.Open();
cmd.ExecuteNonQuery();
conn.Close();


Mark as answered if helpful 

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 :)