how to show image in gridview c#

Question

how to show image in c# gridview

Satyapriya Nayak · Answer

Hi Snehal create a table student Create table student (sid varchar(50)sname varchar(50) saddress varchar(50) smarks intpic nvarchar (50)) Store the picture in the program folder and save there name in pic column of the table with there extension like (.gif.jpg.bmp). Untitled Page AllowPaging=True PageSize=1 BackColor=#FF9999 onpageindexchanging=GridView1_PageIndexChanging> ' runat=server /> '> '> '> '> using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; namespace Show_image_in_gridview { public partial class _Default : System.Web.UI.Page { string strConnString = ConfigurationManager.ConnectionStrings[ConnectionString].ConnectionString; SqlCommand com; SqlDataAdapter sqlda; DataSet ds; string str; protected void Page_Load(object sender EventArgs e) { if (!IsPostBack) { bindgrid(); } } void bindgrid() { SqlConnection con = new SqlConnection(strConnString); con.Open(); str = SELECT * FROM student; com = new SqlCommand(str con); sqlda = new SqlDataAdapter(com); ds = new DataSet(); sqlda.Fill(ds student); GridView1.DataSource = ds; GridView1.DataMember = student; GridView1.DataBind(); con.Close(); } protected void GridView1_PageIndexChanging(object sender GridViewPageEventArgs e) { GridView1.PageIndex = e.NewPageIndex; bindgrid(); } } } Thanks If this post helps you mark it as answer

Vishnujeet Kumar · Answer

try this http://www.codeproject.com/Articles/20782/Displaying-Images-from-a-Database-in-a-GridView