App.config:
<connectionStrings>
<add name="MySchoolConstr" connectionString="data source=PC_THINK-THINK;initial Catalog=MySchool;User id=sa;password=111111;"/>
</connectionStrings>
Login后台:
string Constr = ConfigurationManager.ConnectionStrings["MySchoolConstr"].ConnectionString;
private void btnInsert_Click(object sender, EventArgs e)
{
using(SqlConnection con=new SqlConnection(Constr))
{
con.Open();
using (SqlCommand cmd =con.CreateCommand())
{
cmd.CommandText = "insert into Student output inserted.sId values(@classid,@name,@age,@number,@gender,@email,@birthday)";
cmd.Parameters.Add(new SqlParameter("classid", txtClassId.Text));
cmd.Parameters.Add(new SqlParameter("name", txtName.Text));
cmd.Parameters.Add(new SqlParameter("age", txtAge.Text));
cmd.Parameters.Add(new SqlParameter("number", txtNumber.Text));
cmd.Parameters.Add(new SqlParameter("gender", txtGender.Text));
cmd.Parameters.Add(new SqlParameter("email", txtEmail.Text));
cmd.Parameters.Add(new SqlParameter("birthday",txtBithday.Text));
int number = (int)cmd.ExecuteScalar();
txtStudentId.Text = number.ToString();
}
}
}
<connectionStrings>
<add name="MySchoolConstr" connectionString="data source=PC_THINK-THINK;initial Catalog=MySchool;User id=sa;password=111111;"/>
</connectionStrings>
Login后台:
string Constr = ConfigurationManager.ConnectionStrings["MySchoolConstr"].ConnectionString;
private void btnInsert_Click(object sender, EventArgs e)
{
using(SqlConnection con=new SqlConnection(Constr))
{
con.Open();
using (SqlCommand cmd =con.CreateCommand())
{
cmd.CommandText = "insert into Student output inserted.sId values(@classid,@name,@age,@number,@gender,@email,@birthday)";
cmd.Parameters.Add(new SqlParameter("classid", txtClassId.Text));
cmd.Parameters.Add(new SqlParameter("name", txtName.Text));
cmd.Parameters.Add(new SqlParameter("age", txtAge.Text));
cmd.Parameters.Add(new SqlParameter("number", txtNumber.Text));
cmd.Parameters.Add(new SqlParameter("gender", txtGender.Text));
cmd.Parameters.Add(new SqlParameter("email", txtEmail.Text));
cmd.Parameters.Add(new SqlParameter("birthday",txtBithday.Text));
int number = (int)cmd.ExecuteScalar();
txtStudentId.Text = number.ToString();
}
}
}