Skip to main content

Posts

Link Button in Grid View [Usage of Session]

  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"]; } 

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...

Grid View Assignment -01 [Attendence]

  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)             {                        ...

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...

DBMS- Queries

  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- Que...

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.

QueryString_Assignment

    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...

Quiz[Session]

  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";           ...

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";     ...

Implementation Of DropDownList

  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.Ad...

Assignment_Console

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;   ...