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