.net注册页面数据写入数据库

作者: 许泽博　发布: 2016/8/25　分类: 网站　阅读: 次　查看评论

using System.Data.SqlClient;

//上头的表示对数据库操作

 protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
    {
        string connString = "Data Source=.;Initial Catalog=Personal;Persist Security Info=True;User ID=accp;pwd=accp";
        SqlConnection conn = new SqlConnection(connString);

        string sql = string.Format("insert into Users (uName,uPass,uEmail,uGender,uAdddress,uSname) values('{0}','{1}','{2}','{3}','{4}','{5}')"
            , UserTxt.Text,PswTxt.Text,EmailTxt.Text,"男",TextBox2.Text,TextBox3.Text);

        SqlCommand com = new SqlCommand(sql, conn);
        conn.Open();
        com.ExecuteNonQuery();
        conn.Close();

        Response.Redirect("sdf?Username="+UserTxt.Text);

        Request.QueryString["Username"].ToString();

        //下面的这些事表示对数据库内容的提取

        //DataSet ds = new DataSet();
        //conn.Open();
        //SqlDataAdapter dadb = new SqlDataAdapter(sql);
        //dadb.Fill(ds);
        //conn.Close();
    }

« 上一篇下一篇 » 原创文章，转载请注明出处！标签: 网站  SQLserver