private void button1_Click(object sender, EventArgs e)
{
int rowAffected = 0;
String connString = "Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirecto ry|\\bank.mdf;Integrated Security=True;User Instance=True";
SqlConnection conn = new SqlConnection(connString);
SqlCommand cmd = new SqlCommand();
String cmdText = "insert into mytable (mycol) values(@n)";
cmd.CommandText = cmdText;
cmd.Parameters.AddWithValue("@n", textBox4.Text);
cmd.Connection = conn;
conn.Open();
rowAffected = cmd.ExecuteNonQuery();
conn.Close();
if (rowAffected > 0)
{
dataGridView1.DataSource = XXXBindingSource;
textBox4.Text = " ";
}
else
{
MessageBox.Show("خطا");
}
}