How to display image from db to gridview

Jaya Prakash

i am trying to display img from db to grid view but it is not working pls help me i image was successfully inserted but unable to display

 void GridView()
        {
            string q = "select * from masterwithimg";
            SqlCommand cmd = new SqlCommand(q, con);
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            con.Open();
            DataSet ds = new DataSet();
            da.Fill(ds);
            GridView1.DataSource = ds;
            GridView1.DataBind();
            con.Close();
        }

This is my source

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

Naimish Makwana3y ago
Accepted answer
Hello Jaya,

If the "aadhar" column contains the full file path of the image, you can modify your code to use the "~/" prefix to specify the root directory of the website and set the ImageUrl property to the value of the "aadhar" column:
```
    
        
    
```
Thanks

Naimish Makwana

Jaya Prakash3y ago

Jaya Prakash3y ago
@NIMISH SIR THE DATA IS IMAGE FILE .JPG AND PNG AND JFIF
Sachin Singh3y ago
On browser right click and inspect the ImageUrl (src for img in browser) and check the path.

If you are storing the filename in DB then modify the url as
Naimish Makwana3y ago
What is are the data in aadhar field?

Jaya Prakash3y ago

This is my table

create table masterwithimg(id int identity(1,100),name nvarchar(50),password nvarchar(50),gender varchar(20),
							email varchar(65),aadhar nvarchar(65),pancard nvarchar(70))

the aadhar is a name given to a column i successfully inserted image but unable to display it in gridview

Naimish Makwana3y ago
Hello Jaya,

it seems like you are trying to bind the "aadhar" field as the image URL. Make sure that the "aadhar" field in the database contains a valid image URL or base64 encoded image string.

Thanks

Naimish Makwana

Name:
Password:
Gender:
Email:
Mobile No:
Country:
State:
City:
Amount
Image1:
Image2