注册页面后台代码-当需跨表插入数据

protected void Btnregister_Click(object sender, EventArgs e)
    {
        if(TextBox3.Text ==""||TextBox4.Text ==""||TextBox5.Text ==""||TextBox6.Text =="")
        {
            Response.Write("<script>alert('所有项必须填写！');</script>");
            return;
        }
        
        string str = "Data Source = localhost; Initial Catalog = message;Integrated Security =TRUE;";
        SqlConnection con = new SqlConnection(str);
        con.Open();
        string cate = "管理员";
        int i =1;
     
        string sqlstr = "insert into UserTable(username,userpassword,categroy)values('" + TextBox3.Text + "','" + TextBox4.Text + "','" + cate + "')";
        string sqlstr1 =sqlstr +"insert into ComManTable(comname,isAdmin,loginname,loginpwd)values('" + TextBox6.Text + "','" + i + "','"
            + TextBox3.Text + "','" + TextBox4.Text + "')";
        string sqlstr2 = sqlstr1 + "insert into AdminTable (adminname,adminpwd)values('" + TextBox3.Text + "','" + TextBox4.Text + "')";
        SqlCommand cmd = new SqlCommand(sqlstr2, con);
     
        cmd.ExecuteNonQuery();
        int count = cmd.ExecuteNonQuery();
        if(count >0)
            Response.Write("<script language=javascript>alert('恭喜您，注册成功！');location='login.aspx'</script>");
        else
            Response.Write("<script>alert('注册失败！');</script>");
        con.Close();
    }