private void button1_Click(object sender, EventArgs e) { try { SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=I:\C3 soft\WindowsFormsApplication2\WindowsFormsApplication2\MTechSqlDatabase.mdf;Integrated Security=True;Connect Timeout=30"); con.Open(); string cb = string.Format("Insert into UnitType(UnitType) Values ('{0}')",textBox1.Text ); SqlCommand cmd = new SqlCommand(cb,con ); cmd.ExecuteReader(); con.Close(); MessageBox.Show("Successfully saved"); } catch(Exception ex) { MessageBox.Show(ex.Message); } }
MM Online Express | Best product Review and Online Marketing site
private void button1_Click(object sender, EventArgs e)
ReplyDelete{
try
{
SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=I:\C3 soft\WindowsFormsApplication2\WindowsFormsApplication2\MTechSqlDatabase.mdf;Integrated Security=True;Connect Timeout=30");
con.Open();
string cb = string.Format("Insert into UnitType(UnitType) Values ('{0}')",textBox1.Text );
SqlCommand cmd = new SqlCommand(cb,con );
cmd.ExecuteReader();
con.Close();
MessageBox.Show("Successfully saved");
}
catch(Exception ex)
{
MessageBox.Show(ex.Message);
}
}