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

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

Selecting directory using DropDownList

ASSIGNMENT- The objective is to write the name of directory in the first textbox and click on Create dir then all directories have to added in the below DropDownList. By Selecting the image from FileUpload control and the directory from dropdownlist we can put the image in the specific selected directory How to add the directories using code-     protected void CheckDir_Click(object sender, EventArgs e)     {         Directory.CreateDirectory(Server.MapPath(TextBox1.Text) + "/");          DropDownList1.Items.Add(TextBox1.Text);     }   UploadButton Code-      protected void Upload_Click(object sender, EventArgs e)     {         FileUpload1.SaveAs(Server.MapPath("~") + "//"+DropDownList1.Text+"//" + FileUpload1.FileName);     } Insert 4 directories- 1. pic1 2. pic 2  3. pic3  4. pic4  Selecting pic2 from the Drop Down List an...
Post a Comment
Read more

Implementation Of RadioButtonList

  2.QUIZ(Implementation Of RadioButtonList)- using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; public partial class Assign2 : System.Web.UI.Page {     protected void Page_Load(object sender, EventArgs e)     {         if (!IsPostBack)         {         }     }     protected void Button11_Click(object sender,EventArgs e)     {         if (RadioButtonList1.SelectedIndex == 0)              TextBox1.Text = "1";         else              TextBox1.Text = "0";                               if (RadioButtonList2.SelectedIndex == 2)             TextBox2.Text = "1";     ...
Post a Comment
Read more