添加学生的网页webform(就是向student表中插入记录:stirng sql=insert into student values(,,))。
返回最新添加的学生的自动编号Id
private void button1_Click(object sender, EventArgs e)
{
string connstr = "data source=WIN-10AFVI27V7T;initial catalog=School;user id=sa;password=admin;";
using (SqlConnection conn = new SqlConnection(connstr))
{
string sql = string.Format("insert into T_Student output inserted.FstuId values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}')", txtName.Text.Trim(), txtGender.Text.Trim(), txtAddress.Text.Trim(), txtPhone.Text.Trim(), txtAge.Text.Trim(), txtBirthday.Text.Trim(), txtCard.Text.Trim(), txtClass.Text.Trim());
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
conn.Open();
int Number = (int)cmd.ExecuteScalar();
MessageBox.Show("插入的是第" + Number.ToString() + "行");
}
}
}
如下图样子: