Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- string connstring = "Data Source=localhost\SQLEXPRESS;database=Inventory;User id=raunak;Password=altran123!;" +
- "Integrated Security=true;" +
- "User Instance=true;" +
- //"AttachDBFilename=|DataDirectory|Inventory.mdf;" +
- "Initial Catalog=Inventory";
- try
- {
- using (SqlConnection connection = new SqlConnection(connstring))
- {
- SqlCommand cmd = new SqlCommand("INSERT INTO Creation (Name,Product,Quantity,Category)" +
- "VALUES (@Name,@Product,@Quantity,@Category)", connection);
- cmd.Parameters.AddWithValue("@Name", textBox1.Text);
- cmd.Parameters.AddWithValue("@Product", textBox2.Text);
- cmd.Parameters.AddWithValue("@Quantity", textBox3.Text.ToString());
- cmd.Parameters.AddWithValue("@Category", textBox4.Text);
- thisConnection.Open();
- cmd.ExecuteNonQuery();
- }
- }
- catch
- {
- thisConnection.Close();
- }
- string connstring = "Data Source=localhostSQLEXPRESS;Initial Catalog=Inventory;User id=raunak;Password=altran123!;";
- string connstring = "Data Source=localhostSQLEXPRESS;database=Inventory;User id=raunak;Password=altran123!;" + "Integrated Security=true;" + "User Instance=true;" + //"AttachDBFilename=|DataDirectory|Inventory.mdf;" + "Initial Catalog=Inventory";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement