Skip to main content

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"].ToString();

            Label1.Text = dr["status"].ToString();


        }


        else

        {

            dr.Close();

            Response.Write("Records not matched");

        }



    }


Comments

Popular posts from this blog

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- Query-   UPDATE Chitransh_stu SET          course = 'MCA' WHERE  (marks > 70); 8. Update the name of a student whose

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