Change Password

Changepassword.aspx

<table cellpadding="5" cellspacing="5"  >

        <tr>

            <td>UserName</td><td>

                <asp:TextBox ID="txtChangeUserName" runat="server" ReadOnly="true"></asp:TextBox></td>

        </tr>

        <tr>

            <td>New Password</td><td>

                <asp:TextBox ID="txtNewPassword" runat="server" TextMode="password"></asp:TextBox></td>

        </tr>

        <tr>

            <td>Confirm Password</td><td>

                <asp:TextBox ID="txtConfirmNewPassword" runat="server" TextMode="password"></asp:TextBox></td>

        </tr>

        <tr>

            <td colspan="2" align="center">

                <asp:Button ID="cmdChangePassword" runat="server" Text="Change Password" OnClientClick="return checkPassword();" OnClick="cmdChangePassword_Click" />

            </td>

        </tr>

</table>

Changepassword.aspx.cs(Code Behind)

using System.Data.SqlClient;

string sql;

    DataSet ds;

SqlConnection con = new SqlConnection(_ConnectionString);
            con.Open();
            SqlTransaction trans = con.BeginTransaction();

SqlCommand cmd = con.CreateCommand();
            cmd.Transaction = trans;

    protected void Page_Load(object sender, EventArgs e)

    {

        if (Session["did"] != null & Session["user"] != null)

        {

        }

        else

        {

            Response.Redirect("login.aspx");

        }

        lblUserName.Text = Session["user"].ToString();

        sql = "select * from tablename where id= "+Session["did"].ToString();

        try
            {
                cmd.CommandText = sql;                

cmd.ExecuteNonQuery();trans.Commit();

        }

        catch(Exception ex)

        {

           

trans.Rollback();

        }

        if (ds != null & ds.Tables[0].Rows.Count > 0)

        {

            txtChangeUserName.Text = ds.Tables[0].Rows[0][1].ToString();

        }

    }

    protected void cmdChangePassword_Click(object sender, EventArgs e)

    {

        sql = "update tablename set password = '" + txtNewPassword.Text.Trim() + "' where Id=" + Session["did"].ToString();

        try
            {
                cmd.CommandText = sql;
                cmd.ExecuteNonQuery();

            lblMsg.Text = "Password Change successfully.";

  trans.Commit();

            }

            catch (Exception ex)

            {

                trans.Rollback();

            }

        }

Forget Password

Forgetpassword.aspx

<table border="0" style=" background-color:#FAFFF8; font-family:Arial; font-size:12px" width="100%" cellspacing="5px">

        <tr>

            <td style="height: 20px; text-align:left;">

                <b>Forgot Password</b>

            </td>

        </tr>

        <tr>

            <td style="height: 20px;">

                <asp:Panel ID="pnlinfo" runat="server" class="pnlinfo">

                  <asp:Label ID="lblinfo" runat="server"></asp:Label>

                  </asp:Panel>

                </td>

        </tr>

       <tr><td>Just enter the Email-ID with which you registered on ballgrinder.com and click Submit. Your password will be sent to the email address entered below. Please do enter the email address associated with your account.</td></tr>

       <tr><td>

           <asp:TextBox ID="txtmailid" runat="server" style="width:300px"

               CausesValidation="True"></asp:TextBox>

           <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server"  ValidationGroup="a"

               ControlToValidate="txtmailid" ErrorMessage="Please Enter your email id"></asp:RequiredFieldValidator>

           <cc1:ValidatorCalloutExtender ID="ValidatorCalloutExtender1" runat="server" TargetControlID="RequiredFieldValidator1" >

           </cc1:ValidatorCalloutExtender>

       </td></tr>

       <tr><td>

        

           </td></tr>

       <tr><td>

           <asp:Button ID="Button1" runat="server" Text="Submit" onclick="Button1_Click" ValidationGroup="a"/>

           </td></tr>

    </table>

Forgetpassword.aspx.cs

protected void Button1_Click(object sender, EventArgs e)

    {

        getpassword();

    }

    public void getpassword()

    {

        string str = "select username,password from tablename where username='"+txtmailid.Text+"' or email='"+txtmailid.Text+"'";

        SqlConnection con = new SqlConnection(_ConnectionString);
            con.Open();
            SqlTransaction trans = con.BeginTransaction();
SqlCommand cmd = con.CreateCommand();
            cmd.Transaction = trans; 

        try

        {

            cmd.CommandText = str;
                 DataSet ds = new DataSet();
                SqlDataAdapter da = new SqlDataAdapter(cmd);
                da.Fill(ds);

            if (ds.Tables[0].Rows.Count > 0)

            {

                string username = ds.Tables[0].Rows[0][0].ToString();

                string password = ds.Tables[0].Rows[0][1].ToString();

                sendMailNow(username, password, txtmailid.Text);

                pnlinfo.Visible = true;

                pnlinfo.BackColor = System.Drawing.ColorTranslator.FromHtml("#EEF4FC");

                pnlinfo.BorderColor = System.Drawing.ColorTranslator.FromHtml("#7FB0E0");

                pnlinfo.BorderWidth = 1;

                lblinfo.Text = "Your Password has been sucessfully sent to your email address.";

                txtmailid.Text = "";

            }

            else

            {

                pnlinfo.Visible = true;

                pnlinfo.BackColor = System.Drawing.ColorTranslator.FromHtml("#FFDDDD");

                pnlinfo.BorderColor = System.Drawing.ColorTranslator.FromHtml("#F26060");

                pnlinfo.BorderWidth = 1;

                lblinfo.Text = "You need to create a new account.";

            }
 trans.Commit();

        }

        catch (Exception ex)

        {

           

trans.Rollback();

        }

    }

    public void sendMailNow(string username, string password, string email)

    {

       

            // Code to send mail

        }

Login page code

Login.aspx

<table style="margin: auto; margin-top: 20px; font-family: Arial; font-size: 13px;"

                        cellpadding="5px" cellspacing="5px">

                        <tr>

                            <td colspan="2" align="center" style="text-decoration: underline;">

                                User Login

                            </td>

                        </tr>

                        <tr>

                            <td colspan="2">

                                <asp:Label ID="lblUserMessage" runat="server" ForeColor="Red"></asp:Label>

                            </td>

                        </tr>

                        <tr>

                            <td>

                                Username:

                            </td>

                            <td>

                                <asp:TextBox ID="txtuser" runat="server"></asp:TextBox>

                            </td>

                        </tr>

                        <tr>

                            <td>

                                Password:

                            </td>

                            <td>

                                <asp:TextBox ID="txtpass" runat="server" TextMode="Password"></asp:TextBox>

                            </td>

                        </tr>

                        <tr>

                            <td>

                            </td>

                            <td>

                                <asp:Button ID="btnsubmit" runat="server" Text="Login" OnClick="btnsubmit_Click" />

                            </td>

                        </tr>

                        <tr>

                            <td align="left">

                                <asp:LinkButton ID="cmdUserForget" runat="server" CssClass="normal-link"

                                    onclick="cmdUserForget_Click">Forget password</asp:LinkButton>

                            </td>

                            <td align="right">

                                for register <a href="registration.aspx" class="normal-link">Click here</a>

                            </td>

                        </tr>

                    </table>

Login.aspx.cs(Code Behind)

protected void btnsubmit_Click(object sender, EventArgs e)

    {

        sqlquery = "select * from tablename where email_id='"+txtuser.Text+"' and password='"+txtpass.Text+"'";

SqlConnection con = new SqlConnection(_ConnectionString);
            con.Open();
            SqlTransaction trans = con.BeginTransaction();
SqlCommand cmd = con.CreateCommand();
            cmd.Transaction = trans;
DataSet ds = new DataSet();
              

        try

        {

             SqlDataAdapter da = new SqlDataAdapter(cmd);
                da.Fill(ds);

        }

        catch (Exception ex)

        {

           

        }

        if (ds != null & ds.Tables[0].Rows.Count > 0)

        {

            if (ds.Tables[0].Rows[0]["usertype"].ToString() == "1")

            {

                Session["userid"] = ds.Tables[0].Rows[0]["userid"].ToString();

                Session["username"] = ds.Tables[0].Rows[0]["username"].ToString();

            }

            else

            {

               

            }

        }

        else

        {

            Response.Redirect("login.aspx");

        }

    }

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();
            }
}