Disply image from Sql 2005 in asp .net

Question

Hi I want to retrive all the data on a web page from sql server in asp .Net...In my table i have a image columns...how to select image code from database...Pls help me someone.. Thanks

Kirtan Patel · Answer

Edit Columns >> then Uncheck  Auto Generate Columns  Add Bound Field Columns in GridView then Set its Header Text Property and DataField Property =  Your Columnname  in Database Just Take care that you select Image Field For Column where you have image :) and for ImageField Write Image Column Name in which your Image url is there in ImageURLField property then Just Bind the Grid with data as you Normally do with code :) Thats it :)