嗨,伙计们,任何人都可以帮助我进行以下操作。我使用 C#、asp.net 和 SQL Server。我有两个表 [MANAGER] 和 [USER]。我想将一个用户添加到 [USER] 表中,同时将该用户添加到 [MANAGER] 表中。这是我的代码:
protected void btnManagerRegister_Click(object sender, EventArgs e)
{
using (SqlConnection con = new SqlConnection(CS))
{
SqlCommand cmd = new SqlCommand("INSERT INTO [USER] (userFirstName, userSurname, userEmailAddress, userName, password, userType) VALUES(@userFirstName, @userSurname, @userEmailAddress, @userName, @password, @userType),INSERT INTO MANAGER (@IDENTITY,teamName) VALUES(@IDENTITY,@teamName);", con);
cmd.Parameters.Add(new SqlParameter("@userFirstName", txtManagerName.Text)); cmd.Parameters.Add(new SqlParameter("@userSurname", txtManagerSurname.Text)); cmd.Parameters.Add(new SqlParameter("@userEmailAddress",txtManagerEmailAdd.Text)); cmd.Parameters.Add(new SqlParameter("@userName", txtManagerUserName.Text)); cmd.Parameters.Add(new SqlParameter("@password", txtManagerPassword.Text));
cmd.Parameters.Add(new SqlParameter("@teamName", txtTeamName.Text));
cmd.Parameters.Add(new SqlParameter("@userType", "M" ));
con.Open();
if (txtManagerPassword.Text != txtConfirmManagerPassword.Text)
{
}
else cmd.ExecuteNonQuery(); Response.Redirect("~/Login.aspx");
}
}
我不确定你在用什么@IDENTITY
?如果您的 Manager 表有一IDENTITY
列,那么您可以像这样指定它:
INSERT INTO MANAGER (IdentityColumn, teamName) VALUES(NEWID(), @teamName)
或者排除它,SQL Server 会自动生成一个新的 ID。
如果您尝试插入最后一个用户 ID(我认为这很清楚)(感谢 marc_s)。您可以使用SCOPE_IDENTITY()
INSERT INTO MANAGER (useridColumnName, teamName) VALUES(SCOPE_IDENTITY(), @teamName)
这是代码:
if (txtManagerPassword.Text != txtConfirmManagerPassword.Text)
{
//[TODO] Password doesn't match
}
else
{
using(SqlConnection con = new SqlConnection(CS))
using(SqlCommand cmd = new SqlCommand("INSERT INTO [USER] (userFirstName, userSurname, userEmailAddress, userName, password, userType) VALUES(@userFirstName, @userSurname, @userEmailAddress, @userName, @password, @userType); INSERT INTO MANAGER (teamName) VALUES(@teamName)", con))
{
cmd.Parameters.Add(new SqlParameter("@userFirstName", txtManagerName.Text));
cmd.Parameters.Add(new SqlParameter("@userSurname", txtManagerSurname.Text));
cmd.Parameters.Add(new SqlParameter("@userEmailAddress",txtManagerEmailAdd.Text));
cmd.Parameters.Add(new SqlParameter("@userName", txtManagerUserName.Text));
cmd.Parameters.Add(new SqlParameter("@password", txtManagerPassword.Text));
cmd.Parameters.Add(new SqlParameter("@teamName", txtTeamName.Text));
cmd.Parameters.Add(new SqlParameter("@userType", "M" ));
con.Open();
cmd.ExecuteNonQuery();
}
Response.Redirect("~/Login.aspx");
}
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句