Блог

Это моя форма в asp.net:

 <div>
    <fieldset>
        <legend>Sign Up NOW!!</legend>
        <table>
            <tr>
                <td>
                    <asp:Label ID="lblUserName" runat="server" Text="User Name">
                    </asp:Label>
                </td>
                <td>
                    <asp:TextBox ID="txtUserName" runat="server"></asp:TextBox>
                    <asp:RequiredFieldValidator ID="rqrdUserName" runat="server" 
                        Text="Required" ForeColor="red" 
                        ErrorMessage="Please enter UserName" 
                        ControlToValidate="txtUserName" ValidationGroup="SignUp">
                    </asp:RequiredFieldValidator>
                </td>
            </tr>
            <tr>
                <td>
                    <asp:Label ID="lblFirstName" runat="server" Text="First Name">
                    </asp:Label>
                </td>
                <td>
                    <asp:TextBox ID="txtFirstName" runat="server"></asp:TextBox>
                    <asp:RequiredFieldValidator ID="rqrdFirstName" runat="server" 
                        Text="Required" ForeColor="red" 
                        ErrorMessage="Please provide first name" 
                        ControlToValidate="txtFirstName" ValidationGroup="SignUp">
                    </asp:RequiredFieldValidator>
                </td>
            </tr>
            <tr>
                <td>
                    <asp:Label ID="lblLastName" runat="server" Text="Last Name">
                    </asp:Label>
                </td>
                <td>
                    <asp:TextBox ID="txtLastName" runat="server"></asp:TextBox>
                    <asp:RequiredFieldValidator ID="rqrdLastName" runat="server" 
                        Text="Required" ForeColor="red" 
                        ErrorMessage="Please provide last name" 
                        ControlToValidate="txtLastName" ValidationGroup="SignUp">
                    </asp:RequiredFieldValidator>
                </td>
            </tr>
            <tr>
                <td>
                    <asp:Label ID="lblGender" runat="server" Text="Gender">
                    </asp:Label>
                </td>
                <td>
                    <asp:RadioButtonList ID="rdbtnlst" runat="server">
                        <asp:ListItem>Male</asp:ListItem>
                        <asp:ListItem>Female</asp:ListItem>
                    </asp:RadioButtonList>
                </td>
            </tr>
            <tr>
                <td>
                    <asp:Label ID="lblDob" runat="server" Text="Date of Birth">
                    </asp:Label>
                </td>
                <td>
                    <asp:TextBox ID="txtDob" runat="server"></asp:TextBox></td>
            </tr>
            <tr>
                <td>
                    <asp:Label ID="lblEmail" runat="server" Text="Email">
                    </asp:Label>
                </td>
                <td>
                    <asp:TextBox ID="txtEmail" runat="server" TextMode="Email">
                    </asp:TextBox>
                    <asp:RequiredFieldValidator ID="rqrdEmail" runat="server" 
                        ForeColor="red" ErrorMessage="Please provide Email address" 
                        ControlToValidate="txtEmail" ValidationGroup="SignUp">
                    </asp:RequiredFieldValidator>
                </td>
            </tr>
            <tr>
                <td>
                    <asp:Label ID="lblPassword" runat="server" Text="Password">
                    </asp:Label>
                </td>
                <td>
                    <asp:TextBox ID="txtPassword" runat="server" 
                        TextMode="Password">
                    </asp:TextBox>
                    <asp:RequiredFieldValidator ID="rqrdPassword" runat="server" 
                        ForeColor="red" ErrorMessage="You must provide a password" 
                        ControlToValidate="txtPassword" 
                        ValidationGroup="SignUp">
                    </asp:RequiredFieldValidator>
                </td>
            </tr>
            <tr>
               <td>
                   <asp:Label ID="lblConfirmPassword" runat="server" 
                       Text="Confirm Password">
                   </asp:Label>
               </td>
               <td>
                   <asp:TextBox ID="txtConfirmPassword" runat="server" 
                       TextMode="Password">
                   </asp:TextBox>
                   <asp:CompareValidator ID="matchPassword" runat="server" 
                       ForeColor="red" ErrorMessage="Passwords don't match" 
                       ControlToValidate="txtConfirmPassword" 
                       ControlToCompare="txtPassword" ValidationGroup="SignUp">
                   </asp:CompareValidator>
               </td>
           </tr>
           <tr>
               <td></td>
               <td>
                   <asp:Button ID="btnSubmit" runat="server" Text="Submit" 
                       OnClick="btnSubmit_Click" />
               </td>
               <asp:ValidationSummary ID="ValidationSummary1" runat="server" 
                   ValidationGroup="SignUp" />
           </tr>
       </table>
    </fieldset>
</div>
 

Это мой bll:

  public void addNewDepartment(string name)
        {
            SqlParameter[] param = new SqlParameter[1];
            param[0] = new SqlParameter("@dept_Name", SqlDbType.VarChar);
            param[0].Value = name;

            objdbConnection = new dbConnection();
            objdbConnection.executeInsertprocedure("addNewDepartment", param);
        }
        public DataTable getDepartments()
        {
            objdbConnection = new dbConnection();
            string query = "getDepartments";
            try
            {
                return objdbConnection.executeSelectProcedure(query);
            }
            catch
            {
                return null;
            }
        }
        public DataTable getPosition()
        {
            objdbConnection = new dbConnection();
            string query1 = "getPosition";
            try
            {
                return objdbConnection.executeSelectProcedure(query1);
            }
            catch
            {
                return null;
            }
        }
 

Это мой класс c #:

 public partial class SignUp : System.Web.UI.Page
    {
        private BLL BLL;
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                getDepartments();
                getPosition();
            }
        }
        protected void btnInsert_Click(object sender, EventArgs e)
        {
            BLL = new BLL();
            BLL.insertEmployee(txtName.Text, ddlDepartment.Text, Convert.ToInt32(txtSalary.Text), txtEmail.Text, ddlPosition.Text, txtPassword.Text, Convert.ToInt32(txtContactNo.Text), txtAddress.Text);
        }
        private void getDepartments()
        {
            BLL = new BLL();
            DataTable dtDepartments = BLL.getDepartments();
            ddlDepartment.DataSource = dtDepartments;
            ddlDepartment.DataTextField = dtDepartments.Columns[1].ToString();
            ddlDepartment.DataValueField = dtDepartments.Columns[0].ToString();

            ddlDepartment.DataBind();
        }
        private void getPosition()
        {
            BLL = new BLL();
            DataTable dtPosition = BLL.getPosition();
            ddlPosition.DataSource = dtPosition;
            ddlPosition.DataTextField = dtPosition.Columns[1].ToString();
            ddlPosition.DataValueField = dtPosition.Columns[0].ToString();
            ddlPosition.DataBind();
        }

        protected void btnAdd_Click(object sender, EventArgs e)
        {
            BLL = new BLL();
            BLL.addNewDepartment(txtNewDept.Text);
            ddlDepartment.Items.Add(txtNewDept.Text);
        }
    }
}
 

У меня есть выпадающий список в моей форме входа в систему для отдела. Его источник данных привязан к базе данных. Я хочу добавить элемент в базу данных через пользовательский интерфейс. Он не вставляет элемент в базу данных. Как мне это сделать?