往数据库里面增加新用户

protected void btnRegister_Click(object sender,EventArgs e)
{
//往数据库里面增加新用户
if(!SameName())//注册时如果没有重名则允许去注册
{

SqlConnection con=DB.createDB()//创建数据库连接
    DateTime dt=Convert.ToDateTime(ddlYear.SelectedValue+"-"+ddlMonth.Selectedvalue+"-"+
        ddlDay.SelectedValue);
//用符号组合年月日转换为日期类型
/字符串插入
    string insertSql =string.Format("inser into tb_Users(userId,userPwd,userName,userSex,userBirth,userphone，userMobilePhone,userCode,userAdderss,userEmail,userQQ)values
("{0}"),txtUserId.Text);


try
{
    con.Open();
    SqlCommand cmd =new SqlCommand(insertSql,Con);
    int i =cmd.EndExecuteNonQuery();//返回成功
    if (i>0)
    {
        Response.Write("<script language=javascrip>alert);
    }
    else
    {
        Response.Write

    }
    catch(Exception ex)//保错
{
        Response.Write(ex.Message);
    }
finally{
    con.Close();
}