private void button1_Click(object sender, EventArgs e)
{
SqlConnection sqlcnn = new SqlConnection();
sqlcnn.ConnectionString = "server=.\\sqlexpress;database=student;uid=sa;pwd=yy199455";
sqlcnn.Open();
SqlCommand sqlcmd = new SqlCommand();
sqlcmd.CommandText = "mypro1"; //存储过程的名称为mypro1
sqlcmd.Parameters.Add("@mc", SqlDbType.NVarChar, 10).Value = textBox1.Text; //添加参数,参数名@mc,类型,长度必须与数据库中的参数一致,否则出错
if (sqlcmd.ExecuteNonQuery() > 0)
{
MessageBox.Show("添加成功");
}
}
{
SqlConnection sqlcnn = new SqlConnection();
sqlcnn.ConnectionString = "server=.\\sqlexpress;database=student;uid=sa;pwd=yy199455";
sqlcnn.Open();
SqlCommand sqlcmd = new SqlCommand();
sqlcmd.Connection = sqlcnn;
sqlcmd.CommandText = "mypro1"; //存储过程的名称为mypro1
sqlcmd.Parameters.Add("@mc", SqlDbType.NVarChar, 10).Value = textBox1.Text; //添加参数,参数名@mc,类型,长度必须与数据库中的参数一致,否则出错
if (sqlcmd.ExecuteNonQuery() > 0)
{
MessageBox.Show("添加成功");
}
}