Skip to main content

Generate otp (Send to Email)



Fill the information and click on 'Generate Id' ..The otp will get sent to you in your mail.

Generate_id Link button code-


protected void LinkButton1_Click(object sender, EventArgs e)
    {
        string s = ConfigurationManager.AppSettings["db"];
        cn = new SqlConnection(s);
        cn.Open();

        string q = "select max(roll)+1 from gen_id ";
        cm = new SqlCommand(q, cn);

        SmtpClient sm = new SmtpClient("student-cell.com", 25);

        sm.Credentials = new System.Net.NetworkCredential("contact@student-cell.com", "Fg8@or61");

        sm.DeliveryMethod = SmtpDeliveryMethod.Network;

        MailMessage mm = new MailMessage("contact@student-cell.com", TextBox3.Text);

        if(TextBox3.Text == "" )
        {
            Response.Write("Please enter the email id");
        } 

        else
        {
        mm.Subject = "ID GENERATED!!!";

        Random rm = new Random();

        int k = (int)(rm.NextDouble() * 999);

        mm.Body = "Dear Employee, your id is" + "EMP" + "-" + DateTime.Now.ToString("yyy") + "-" + cm.ExecuteScalar().ToString()+ "-" + k;

        mm.IsBodyHtml = true;

        sm.Send(mm);


        string qu = "insert into gen_id values('" + TextBox1.Text + "','" + TextBox3.Text + "','" + TextBox4.Text + "','" + TextBox2.Text + "','" + "EMP" + "-" + DateTime.Now.ToString("yyy") + "-" + cm.ExecuteScalar().ToString() + "-" + k + "','" + TextBox6.Text + "')";

        cm = new SqlCommand(qu, cn);

        cm.ExecuteNonQuery();

        }
    }
    
    

Click on Login Button. 




protected void Button2_Click(object sender, EventArgs e)
    {
        string s = ConfigurationManager.AppSettings["db"];
        cn = new SqlConnection(s);
        cn.Open();

        string q = "select * from gen_id where roll='" + TextBox6.Text + "'";
        cm = new SqlCommand(q, cn);
        dr = cm.ExecuteReader();

        if (dr.Read())
        {

            TextBox1.Text = dr["name"].ToString();
            TextBox3.Text = dr["email"].ToString();
            TextBox4.Text = dr["mobile"].ToString();
            TextBox2.Text = dr["age"].ToString();
        }

        else 
        {
            dr.Close();
            Response.Write("no records found");
        
        }

    }

Comments

Post a Comment

Popular posts from this blog

DataBase Assignment

  1. Registration page(Design)  Note:- We used Range validator in Age 's textbox.  Coding- using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls;  using System.Data.SqlClient; public partial class Registration : System.Web.UI.Page {     SqlConnection cn;     SqlCommand cm;     SqlDataReader dr;     protected void Page_Load(object sender, EventArgs e)     {     }      //Coding of submit button     protected void Button1_Click(object sender, EventArgs e)     {         string p=@"Data Source=49.50.88.43;Initial Catalog=grkistdb;Persist Security Info=True;User ID=grkistuser;Password=q2oR5w_356";         cn = new SqlConnection(p);         cn.Open();         string q = "insert into Chitransh_reg values ( '"+TextBox1.Te...
Post a Comment
Read more

FileUpload And QueryString

1. Took File Upload control, Button, Image button control,  Label (First Page) [Browse your desired file > Click on Upload Button > Image will be shown in Image Button Control  ]  Inside the event of ImageButton QueryString is defined.  CODING- 2. When we click on it then the next page will be shown Image ,Using QueryString-  (Next Page) Image control will be used-  Inside page_load event we will call QueryString.
Post a Comment
Read more

Grid View Assignment 02[Fetching Image from Data Base]

WRITE THE CODE FOR FIND BUTTON TO FIND THE DATA AND IMAGE WITH THE REFERENCE OF USER ID-     FIND BUTTON CODING-      protected void Find_Click(object sender, EventArgs e)     {         string k = @"Data Source=49.50.88.43;Initial Catalog=grkistdb;Persist Security Info=True;User ID=grkistuser;Password=q2oR5w_356";         cn = new SqlConnection(k);         cn.Open();         string q = "select * from addhar where id='" + TextBox1.Text + "'";         cm = new SqlCommand(q, cn);         dr=cm.ExecuteReader();         if (dr.Read())         {             TextBox2.Text = dr["name"].ToString();             TextBox3.Text = dr["address"].ToString();             Image1.ImageUrl = "~/pics/" + dr["status"].ToStr...
Post a Comment
Read more