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

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.

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

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