how to pass multiple parameters into insert sql query

Question

i have been doing insert query but each time it fails INSERT INTO Mytable (Id, name) VALUES (txtbox1.value, txtbox2.value), how to use this query using sql connection and pass two paramerters.

Ashutosh Gupta · Answer

not what is actual error are you facing here/. can you eloborate more. but normally for sql connection you need to have datasoruce and then you can use below code to execute any query. using (SqlConnection conn = new SqlConnection()) { conn.ConnectionString = "your data source string" conn.Open(); SqlCommand insertCommand = new SqlCommand( "INSERT INTO Mytable (Id, name) VALUES (@0, @1)" , conn); insertCommand.Parameters.Add( new SqlParameter( "0" , txtbox1.value)); insertCommand.Parameters.Add( new SqlParameter( "1" , txtbox2.value)); insertCommand.ExecuteNonQuery(); }

Vincent Maverick Durano · Answer

You have to use sql parameters to hold the values from your TextBox or any other controls. For example: private void InsertRecord( int ID , string name){ string dbConnectionString = ConfigurationManager.ConnectionStrings[ "MyDBConnectionString" ].ConnectionString; using (SqlConnection connection = new SqlConnection(dbConnectionString)) { string sql = "INSERT INTO MyTable(ID, Name) VALUES (@ID, @Name" ; using (SqlCommand cmd = new SqlCommand(sql, connection)) { connection.Open(); cmd.Parameters.AddWithValue( "@ID" , ID); cmd.Parameters.AddWithValue( "@Name" , name); cmd.ExecuteNonQuery(); } } } protected void addB_Click( object sender, EventArgs e){ InsertRecord(Convert.ToInt32(TextBox1.Text), TextBox2.Text); } If you are new to ADO.NET, you should read this article: https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/ado-net-code-examples

Vinitha T · Answer

private void Insert (int ID , string name){ using (SqlConnection con = new SqlConnection(Your data source ConnectionString)) { string query = "Insert into table values (@ID, @Name)"; SqlCommand cmd = new SqlCommand(query, con); cmd.CommandType = CommandType.Text; con.Open(); cmd.Parameters.AddWithValue(@ID, ID); cmd.Parameters.AddWithValue(@Name,Name); cmd.ExecuteNonQuery(); } }

how to pass multiple parameters into insert sql query

Answers (3)