Dot Net Implementations

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 and select the image from file Upload control and click on Upload button  Checking the pic2 directory- There you go- CODE-

  Create a Link Button using Template Field.  Create an event of link button- Steps- 1. Select the Grid View.  2. Go to source. 3. Create the Event 'OnClick' in Link Button's attribute.  4. Create the Event of link button in code window-  protected void send_click(object sender, EventAgrs e) { // activate the control GridViewRow gr1 = ((LinkButton)sender.NamingContainer as GridViewRow;  // find control  LinkButton l1 = (LinkButton) gr1.FindControl("lb1"); ; Session["name"] = gr1.Cells[0].Text; Session["amu"] =  gr1.Cells[1].Text;  Response.Redirect("NextPage.aspx"); } 2. We have to call the Session in the page_load event of NextPage-  protected void Page_load(object sender, EventArgs e) { Label1.Text = (string) Session["name"]; Label2.Text = (string) Session["amu"]; } 

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"].ToString();             Label1.Text = dr["status"].ToString();         }         else         {             dr.Close();             Response.Write("Records not matched");         }     }

  Q. Insert checkbox and textbox in grid view and create a column in data base table named "Attendence" when a user Select the record using checkbox and input present/absent in textbox should be reflected to the database table. Update Selection(button)  Code-  {         string s = @"Data Source=49.50.88.43;Initial Catalog=grkistdb;Persist Security Info=True;User ID=grkistuser;Password=q2oR5w_356";         cn = new SqlConnection(s);         cn.Open();         foreach (GridViewRow gr1 in GridView1.Rows)         {             CheckBox c1 = (CheckBox) gr1.FindControl("cb1");             TextBox t1 = (TextBox)gr1.FindControl("tb1");             if (c1.Checked)             {                                  string q = "update Chitransh_reg set Attendance ='" + t1.Text + "' where roll='"+gr1.Cells[1].Text+"'";                    cm = new SqlCommand(q, cn);                                  cm.ExecuteNonQuery(

  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.Text+"', '"+TextBox2.Text+"', '"+TextBox3.Text+"', '"+DropDownList1.Text+"', '"+TextBox4.Text+&q

  1. display all records of data base-   Query- select * from Chitransh_stu;  2. display the name whose age is lesser than 20- Query-   SELECT name FROM     Chitransh_stu WHERE  (age < 20);  3. display the marks of students with their names whose section is BCA- Query-  SELECT name, marks FROM     Chitransh_stu WHERE  (course = 'BCA'); 4. Delete a record from the table whose address is jabalpur- Query-   DELETE FROM Chitransh_stu WHERE  (address = 'jabalpur'); 5. Delete the records whose marks are greater than 60- Query-   DELETE FROM Chitransh_stu WHERE  (marks < 60); 6. Insert a new record in the table- Query-   INSERT INTO Chitransh_stu                   (roll, name, age, course, address, marks) VALUES (10, 'sidhharth', 34, 'mca', 'jabalpur', 89); 7. Update the course of Students whose marks are greater than 70- Query-   UPDATE Chitransh_stu SET          course = 'MCA' WHERE  (marks > 70); 8. Update the name of a student whose

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.

    Write a code for this-                                                                    1.Registration.aspx- Coding of SUBMIT button- using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; public partial class Registration : System.Web.UI.Page {     protected void Page_Load(object sender, EventArgs e)     {     }     protected void Button1_Click(object sender, EventArgs e)     {         Response.Redirect("Login.aspx?name=" +TextBox1.Text + "&email=" + TextBox2.Text + "&mobile=" +TextBox3.Text + "&pass=" +TextBox4.Text + "&city=" + DropDownList1.Text);      } } 2. Login.aspx- Coding of LOGIN button- using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; public partial class Login : System.Web.UI.Page {     protected void Page_Load(object sender, EventArgs e)     {              }     protected void

  3.USING SESSION-   Code- 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)     {     }     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";         else             TextBox2.Text = "0";             if (RadioButtonList3.SelectedIndex == 2)             TextBox3.Text = "1";         else             TextBox3.Text = "0";              if (RadioButtonList4.SelectedIndex == 1)             TextBox4.Text = "1";         else             TextBox4.Text = "0";         if (RadioButt

  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";         else             TextBox2.Text = "0";             if (RadioButtonList3.SelectedIndex == 2)             TextBox3.Text = "1";         else             TextBox3.Text = "0";              if (RadioButtonList4.SelectedIndex == 1)             TextBox4.Text = "1";         else  

  1. Implementation Of DropDownList-    (i) Design - (ii) Code - using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; public partial class Assign1 : System.Web.UI.Page {     protected void Page_Load(object sender, EventArgs e)     {     }     protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)     {         if (DropDownList1.Text == "UG")         {             DropDownList2.Items.Clear();             DropDownList2.Items.Add("CSE");             DropDownList2.Items.Add("IT");             DropDownList2.Items.Add("CIVIL");             DropDownList2.Items.Add("MECH");             DropDownList2.Items.Add("ETC");             DropDownList2.Items.Add("ETRX");          }         if (DropDownList1.Text == "PG")         {             DropDownList2.Items.Clear();             DropDownList2.Items.Add("MCA&q

1. WAP to make a calculator- using System; using System.Collections.Generic; using System.Linq; using System.Text; namespace ConsoleApplication1 {     class Program     {         public void calc(float a, float b,int z)         {             float result;             switch (z)             {                 case 1: result = a + b;                     Console.WriteLine("the Addition is" +result);                     break;                 case 2: result = a - b;                     Console.WriteLine("the Subtraction is" + result);                     break;                 case 3: result = a * b;                     Console.WriteLine("the Multiplication is" + result);                     break;                 case 4: result = a / b;                     Console.WriteLine("the Division is " + result);                     break;                 default: Console.WriteLine("Invalid choice");                     break;             }