62,025
社区成员
发帖
与我相关
我的任务
分享
create table clientinformation
(
cid int foreign key references clientloadinformation(clid),--用户ID
ctruename varchar(10) not null,--用户真实姓名
csex varchar(2) not null,--性别
cbirthdate smalldatetime not null,--出生日期
cwork varchar(50),--工作单位
chomeaddr varchar(50),--家庭住址
ctel varchar(15),--联系电话
crecord varchar(20),--教育程度
cheadimage varchar(50),--用户头像
chobbies varchar(20)--兴趣爱好
)
go
public static bool insertpeople(people p)
{
try
{
SqlConnection con=DBCON.ClientCreateCon();
con.Open();
SqlCommand cmd=new SqlCommand("insert into clientinformation values(@pID,@ptruename,@psex,@pbirth,@pwork,@phome,@ptel,@precord,@pheadimage,@phobby)",con);
SqlParameter para=new SqlParameter("@pID",SqlDbType.VarChar,4);
para.Value=p.cid;
cmd.Parameters.Add(para);
para=new SqlParameter("@pname",SqlDbType.VarChar,10);
para.Value=p.truename;
cmd.Parameters.Add(para);
para=new SqlParameter("@psex",SqlDbType.VarChar,2);
para.Value=p.sex;
cmd.Parameters.Add(para);
para=new SqlParameter("@pbirth",SqlDbType.SmallDateTime,4);
para.Value=Convert.ToDateTime(p.birth).ToShortDateString();
cmd.Parameters.Add(para);
para=new SqlParameter("@pwork",SqlDbType.VarChar,50);
para.Value=p.work;
cmd.Parameters.Add(para);
para=new SqlParameter("@phome",SqlDbType.VarChar,50);
para.Value=p.home;
cmd.Parameters.Add(para);
para=new SqlParameter("@ptel",SqlDbType.VarChar,15);
para.Value=p.tel;
cmd.Parameters.Add(para);
para=new SqlParameter("@precord",SqlDbType.VarChar,20);
para.Value=p.record;
cmd.Parameters.Add(para);
para=new SqlParameter("@pheadimage",SqlDbType.VarChar,50);
para.Value=p.headimage;
cmd.Parameters.Add(para);
para=new SqlParameter("@phobby",SqlDbType.VarChar,20);
para.Value=p.hobby;
cmd.Parameters.Add(para);
cmd.ExecuteNonQuery();
return true;
}
catch(Exception e)
{
return false;
}
}
//前台代码:
SqlConnection con=DBCON.ClientCreateCon();
SqlCommand cmd=new SqlCommand("select clid from clientloadinformation",con);
con.Open();
cmd.CommandText="select cid from clientinformation";
int b=Convert.ToInt32(cmd.ExecuteScalar());
people p=new people();
p.cid=b+1;
p.truename=this.trueName.Text;
p.sex=this.RadioButtonList2.SelectedItem.Text;
p.birth=this.txtbirth.Text;
p.work=this.workAddr.Text;
p.home=this.homeAddr.Text;
p.tel=this.Tel.Text;
p.record=this.ddlrecord.SelectedItem.Text;
p.headimage=this.Image1.ImageUrl;
p.hobby=this.CheckBoxList1.SelectedItem.Text;
if(option.insertpeople(p))
{
Response.Write("插入成功");
}
else
{
Response.Write("插入失败");
}
cmd.ExecuteNonQuery();
con.Close();