how to pass multiple parameters into insert sql query

Anand

6y4.2kSQL

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.

3 Replies

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

Ashutosh Gupta6y ago
Accepted 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();
            }
+2
Vinitha T4y ago
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();
}
}
+1
Vincent Maverick Durano6y ago
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
+3