注册连接数据

最新推荐文章于 2024-03-23 16:19:07 发布

wl0215

最新推荐文章于 2024-03-23 16:19:07 发布

阅读量760

点赞数

分类专栏： ASP/ASP.NET 文章标签： textbox radiobutton string database insert bbs

本文链接：https://blog.csdn.net/wl0215/article/details/521733

版权

ASP/ASP.NET 专栏收录该内容

8 篇文章 0 订阅

订阅专栏

try
   {
    string xingbie;
    if(RadioButton1.Checked ==true)
    {xingbie="男";}
    else{xingbie="女";}
    SqlConnection cn = new SqlConnection();
    cn.ConnectionString ="Data Source = 405-22;database = bbs_data;uid = sa;pwd=";
    SqlCommand com = new SqlCommand();
    string a = "insert user_info (userID,userPWD,xingbie,shengri,email,qq) values ('"+TextBox1.Text+"','"+TextBox2.Text+"','"+xingbie+"','"+TextBox6.Text+"','"+TextBox4.Text+"','"+TextBox5.Text+"')";
    com.CommandText = a;
    com.Connection = cn;
    cn.Open();
    int i=com.ExecuteNonQuery();
    cn.Close();
   }
   catch(SqlException ex)
   {
    Response.Write(ex.Message);
   }
   Response.Redirect("lt_back.aspx");
  }