新手提问

lchy110 2008-03-02 06:44:36

问题: 我在写一个注册页面时,要把所有的注册信息保存起来迁徙到两个表的存储.我都是用存储过程的.用什么方法可以在一个提交按扭按下后在提交时间中写两个SQL语句插入两个表了比如说我注册的信息有编号,姓名,电话,入职时间,工龄..等
我要把注册的信息存到一个员工信息表和一个系统登陆用户表(这两个表我是分开来的系统登陆表里有权限控制字段) 两个表共用注册信息里编号.姓名.密码等字段。我把代码复制过来了插入第二个表的我把他注释了因为放在一起就出错.麻烦高手们指点指点! 谢谢
using System;
using System.Data;
using System.Configuration;
using System.Collections;
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 person_regist : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

}
protected void bbtnReset_Click(object sender, EventArgs e)
{
this.tbBrith.Text = "";
this.tbIntime.Text = "";
this.tbName.Text= "";
this.tbPartment.Text= "";
this.tbPhon.Text = "";
this.tbPostion.Text = "";
this.tbPwd.Text = "";
this.tbUID.Text = "";
this.tbWorkYear.Text = "";
this.tbUID.Focus();
}
protected void bbtnSumit_Click(object sender, EventArgs e)
{
//string UserID = this.tbUID.Text.ToString();
//string UserPwd = this.tbPwd.Text.ToString();
//string UserName = this.tbName.Text.ToString();
//string
SqlConnection cn = new SqlConnection(ConfigurationSettings.AppSettings["dsn"]);
cn.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = cn;
cmd.CommandText = "insert_personnel_information";
cmd.Parameters.Add("@number", SqlDbType.VarChar);
cmd.Parameters.Add("@name", SqlDbType.VarChar);
cmd.Parameters.Add("@birth", SqlDbType.DateTime);
cmd.Parameters.Add("@marriage", SqlDbType.Char);
cmd.Parameters.Add("@worktime", SqlDbType.Char);
cmd.Parameters.Add("@intime", SqlDbType.DateTime);
cmd.Parameters.Add("@department", SqlDbType.VarChar);
cmd.Parameters.Add("@position", SqlDbType.VarChar);
cmd.Parameters.Add("@phone", SqlDbType.Char);

//给参数赋值
cmd.Parameters["@number"].Value = this.tbUID.Text.ToString();
cmd.Parameters["@name"].Value = this.tbName.Text.ToString();
cmd.Parameters["@birth"].Value = DateTime.Parse(this.tbBrith.Text.ToString());
cmd.Parameters["@marriage"].Value = rblMarry.SelectedValue.ToString();
cmd.Parameters["@worktime"].Value = this.tbWorkYear.Text.ToString();
cmd.Parameters["@intime"].Value =DateTime.Parse( this.tbIntime.Text.ToString());
cmd.Parameters["@department"].Value = this.tbPartment.Text.ToString();
cmd.Parameters["@position"].Value = this.tbPostion.Text.ToString();
cmd.Parameters["@phone"].Value = this.tbPhon.Text.ToString();
try
{
cmd.ExecuteNonQuery();

Response.Write("<script> alert('注册成功，请返回登录界面登录！') </script>");
Response.Redirect("Login.aspx");
}
catch (SqlException)
{
Response.Write("<script>alert('注册失败，请重新注册！')</script>");
this.tbUID.Focus();
}

//插入第二个表的存储过程
//SqlCommand sqlcmd = new SqlCommand();
//sqlcmd.CommandType = CommandType.StoredProcedure;
//sqlcmd.CommandText = "insert_User";
//sqlcmd.Connection = cn;
//sqlcmd.Parameters.Add("@userid", SqlDbType.VarChar);
//sqlcmd.Parameters.Add("@userpwd", SqlDbType.VarChar);
//sqlcmd.Parameters.Add("@userpower", SqlDbType.BigInt);
//sqlcmd.Parameters["@userid"].Value = this.tbUID.Text.ToString();
//sqlcmd.Parameters["@userpwd"].Value = this.tbPwd.Text.ToString();
//sqlcmd.Parameters["@userpower"].Value = "3";
//sqlcmd.ExecuteNonQuery();

cn.Close();
}
}

麻烦各位帮我看看我刚接触这个很多不懂的谢谢!

...全文