public SqlConnection GetConnection()
{
//获取Web.Config 文件中的连接字符串
String myStr = System.Configuration.ConfigurationManager.
ConnectionStrings["sqlconn"].ToString();
SqlConnection myConn = new SqlConnection(myStr);
return myConn;
}
protected void btnAdd_Click(object sender, EventArgs e)
{
SqlConnection myConn = GetConnection();
string ssex;
if (radMan.Checked)
{
ssex = "男";
}
else
{
ssex = "女";
}
try
{
string sqlStr = "insert into Test_tb3(sno,snamo,ssex,sclass,sdept,spwd)values('" + txtSno.Text.ToString().Trim()
+ "','" + txtSname.Text.ToString().Trim()
+ "','" + ssex + "','"
+ txtClass.Text.ToString().Trim()
+ "','"
+ txtSdept.Text.ToString().Trim()
+ "','"
+ txtSdept.Text.ToString().Trim()
+ "','"
+ "')"; //SQL插入语句
SqlCommand myCmd = new SqlCommand(sqlStr, myConn);
myConn.Open();
myCmd.ExecuteNonQuery(); //使用Sqlcommand对象插入
this.gvStudent.DataBind();
}
catch
{
Response.Write("添加失败");
}
finally
{
myConn.Close();
}
|
使用Command对象 添加 数据
最新推荐文章于 2022-10-24 14:16:25 发布