d\
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
/// <summary>
/// Dal 的摘要说明
/// </summary>
public class Dal
{
public Dal()
{
//
// TODO: 在此处添加构造函数逻辑
//
}
public void InserUser(User user) {
string sql = "insert into Userregistered(UserName,UserPassWord,UserPwd,Email,Code)values(@UserName,@UserPassWord,@UserPwd,@Email,@Code)";
SqlConnection con = new SqlConnection("Data Source=WWW-7622246D70B;Initial Catalog=Users;Integrated Security=True");
con.Open();
SqlCommand cmd = new SqlCommand(sql,con);
cmd.Parameters["UserName"].Value = user.UserName1;
cmd.Parameters["@UserPassWord"].Value=user.UserPassWord1;
cmd.Parameters["@UserPwd"].Value=user.UserPwd1;
cmd.Parameters["@Email"].Value=user.Email1;
cmd.Parameters["@Code"].Value = user.Code1;
cmd.ExecuteNonQuery();
}
}
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{ User user = new User();
Dal da = new Dal();
da.InserUser(user);
}
}
User是个封装类!!
运行就说 cmd.Parameters["UserName"].Value = user.UserName1;这个错!!!