ASP注册页面连接到数据库

ASP网页代码:

  <div align="center">
    <table>

   <tr><td> 昵称:</td>  <td><asp:TextBox ID="username" runat="server"></asp:TextBox></td> <td>(发表评论时显示)</td></tr>
        <br />
 
     <tr>  <td>性别:</td>   <td>
         <asp:RadioButton ID="RadioButton1" runat="server" GroupName="sex" Text="男"/>
         <asp:RadioButton ID="RadioButton2" runat="server" GroupName="sex" Text="女"/>
    </td></tr>
   
    <tr><td>所在部门:</td><td><asp:DropDownList ID="DropDownList1" runat="server"
            style="margin-left: 0px" Width="150px"></asp:DropDownList></td> </tr>
       
    <tr><td>爱好:</td><td>
        <asp:CheckBox ID="CheckBox1" runat="server" Text="读书" />
         <asp:CheckBox ID="CheckBox2" runat="server" Text="上网" />
          <asp:CheckBox ID="CheckBox3" runat="server" Text="运动" />
           <asp:CheckBox ID="CheckBox4" runat="server" Text="逛街" />
      </td>
     </tr>

     <tr><td>E-mail:</td><td><asp:TextBox ID="email" runat="server"></asp:TextBox></td></tr>
     <tr><td>生日:</td><td>&nbsp;<asp:TextBox ID="birthday" runat="server"></asp:TextBox>(yyyy-mm-dd)</td></tr>
     <tr><td>个人头像:</td><td>  <asp:FileUpload ID="FileUpload1" runat="server" /></td></tr>
     <tr><td>个人简介:</td><td><asp:TextBox ID="personintro" runat="server" Height="100px"
             TextMode="MultiLine" Width="200px"></asp:TextBox></td></tr>
       <tr><td></td><td>
           <asp:Button ID="Button1" runat="server" Text="确定"
               onclick="Button1_Click" /> </td></tr>

   </table>
       

    </div>

方法中的代码:

    string sqlserverstr = "Data Source=GFWMJ3FJ7JLJJBR;Initial Catalog=web login page;Persist Security Info=True;User ID=sa;Password=111111";
    protected void Page_Load(object sender, EventArgs e)
    {

        if (!IsPostBack)
        {
            ListItem li = new ListItem("财经部", "1");
            DropDownList1.Items.Add(li);
        }

    }

    protected void Button1_Click(object sender, EventArgs e)
    {
        SqlConnection conn = new SqlConnection(sqlserverstr);
        conn.Open();
        SqlCommand sqlcmd = new SqlCommand();
        sqlcmd.Connection = conn;
        sqlcmd.CommandText = "insert into T_user values(@txt_name,@tex_sex,@txt_department,@txt_hobby,@txt_Email,@txt_birthday,@file_address,@textarea_intro)";
        sqlcmd.Parameters.AddWithValue("@txt_name", username.Text);
        if (RadioButton1.Checked)
        {
            sqlcmd.Parameters.AddWithValue("@tex_sex", "男");
        }
        else
        {
            sqlcmd.Parameters.AddWithValue("@tex_sex", "女");
        }

        sqlcmd.Parameters.AddWithValue("@txt_department", DropDownList1.SelectedItem.Text);
        #region 爱好
        string str = "";
        if (CheckBox1.Checked)
        {
            str = str + "1";
        }
        else
        {
            str = str + "0";
        }

        if (CheckBox2.Checked)
        {
            str = str + "1";
        }
        else
        {
            str = str + "0";
        }

        if (CheckBox3.Checked)
        {
            str = str + "1";
        }
        else
        {
            str = str + "0";
        }

        if (CheckBox4.Checked)
        {
            str = str + "1";
        }
        else
        {
            str = str + "0";
        }

        sqlcmd.Parameters.AddWithValue("@txt_hobby", str);
        #endregion
        sqlcmd.Parameters.AddWithValue("@txt_Email", email.Text);
        sqlcmd.Parameters.AddWithValue("@txt_birthday", birthday.Text);

        StringBuilder sb = new StringBuilder();
        string filename = this.FileUpload1.PostedFile.FileName;
        filename = DateTime.Now.Ticks.ToString() + filename.Substring(filename.LastIndexOf("."));
        this.FileUpload1.PostedFile.SaveAs(Server.MapPath("upload") + "\\" + filename);
        sb.Append("<img src=\"upload/" + filename + "\" />");

        sqlcmd.Parameters.AddWithValue("@file_address", sb.ToString());

        sqlcmd.Parameters.AddWithValue("@textarea_intro", personintro.Text);
        sqlcmd.ExecuteNonQuery();
        conn.Close();
        conn.Dispose();
    }