insert data in sqlserver

In ASPX page

Using Syste.Data.SqlClient;

            <table cellpadding="10px" cellspacing="10px" style="width: 700px; border: 2px solid #E6F2FA;
                margin-top: 5px;">
                <tr>
                    <td colspan="2" class="heading-back">
                        Agent Registeration Form
                    </td>
                </tr>
                <tr>
                    <th align="right" colspan="2">
                        <span class="star">*</span> <span style="font-size: 12px; font-weight: normal;">Mendatory
                            Fields</span>
                    </th>
                </tr>
                <tr>
                    <td colspan="2" class="heading">
                        Account Information
                    </td>
                </tr>
                <tr>
                    <td colspan="2">
                        <asp:UpdatePanel ID="UpdatePanel3" runat="server">
                            <ContentTemplate>
                                <table cellpadding="6px" cellspacing="6px">
                                    <tr>
                                        <th style="width: 150px;">
                                            <span class="star">*</span> Username
                                        </th>
                                        <td valign="bottom">
                                            <asp:TextBox ID="txtUserName" runat="server" Width="200px" MaxLength="100"></asp:TextBox>
                                            <asp:ImageButton ImageUrl="~/images/check_availability.gif" ID="cmdCheckAvailability"
                                                runat="server" OnClick="cmdCheckAvailability_Click" />
                                            <br />
                                            <asp:Label ID="lblUserName" runat="server"></asp:Label>
                                        </td>
                                    </tr>
                                </table>
                            </ContentTemplate>
                        </asp:UpdatePanel>
                    </td>
                </tr>
                <tr>
                    <th>
                        <span class="star">*</span> Email ID
                    </th>
                    <td>
                        <asp:TextBox ID="txtEmail" runat="server" Width="200px" MaxLength="100"></asp:TextBox>&nbsp;
                        <br />
                        <asp:RegularExpressionValidator ID="RegularExpressionValidator1" runat="server" ErrorMessage="Enter valid email id"
                            Display="Dynamic" ControlToValidate="txtEmail" ValidationExpression="\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*"></asp:RegularExpressionValidator>
                        <asp:Label ID="lblEmail" runat="server"></asp:Label>
                    </td>
                </tr>
                <tr>
                    <th style="width: 150px;">
                        <span class="star">*</span> Password
                    </th>
                    <td>
                        <asp:TextBox ID="txtPassword" runat="server" TextMode="Password" Width="200px" MaxLength="100"></asp:TextBox>
                    </td>
                </tr>
                <tr>
                    <th>
                        <span class="star">*</span> Confirm Password
                    </th>
                    <td>
                        <asp:TextBox ID="txtCPassword" runat="server" TextMode="Password" Width="200px" MaxLength="100"></asp:TextBox>
                    </td>
                </tr>
</table>

In Aspx.cs page
protected void cmdCreateAgent_Click(object sender, ImageClickEventArgs e)
    {
      
            SqlConnection con = new SqlConnection("Data Source=RACHIT;Initial Catalog=userdb;Integrated Security=True");
            con.Open();
            SqlTransaction trans = con.BeginTransaction();

          string sqlquery = "insert into vp_user_login(username, emailid, password, user_type_id, created_date)"
                + " values("
                + "'" + txtUserName.Text + "',"
                + "'" + txtEmail.Text + "',"
                + "'" + txtPassword.Text + "',"
                + "'3',"
                + "'" + DateTime.Now.ToShortDateString() + "'"
                + ")";
            SqlCommand cmd = con.CreateCommand();
            cmd.Transaction = trans;
            try
            {
                cmd.CommandText = sqlquery;
                cmd.ExecuteNonQuery();
   clear();
                    ClientScript.RegisterStartupScript(this.GetType(), "onclick", "<script type='text/javascript'>alert('Agent created successfully')</script>");
                    trans.Commit();
                }
                else
                {
                    trans.Rollback();
                }
            }
            catch
            {
                trans.Rollback();
                ClientScript.RegisterStartupScript(this.GetType(), "onclick", "<script type='text/javascript'>alert('Sorry! Please try after some time')</script>");
            }
            finally
            {
                con.Close();
            }
}