using System.Data.SqlClient;
private void btn_ok_Click(object sender, EventArgs e)
{
//write to db
string connectionString = @"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Documents and Settings\Thisal Lekamge\Desktop\Shohan\new\ChainMan.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True";
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand("INSERT INTO Item (itemName, itemDescription) VALUES (@itemName, @itemDescription);");
cmd.CommandType = CommandType.Text;
cmd.Connection = connection;
cmd.Parameters.AddWithValue("@itemName", textBox3.Text);
cmd.Parameters.AddWithValue("@itemDescription", textBox5.Text);
connection.Open();
cmd.ExecuteNonQuery();
connection.Close();
}
}
No comments:
Post a Comment