how to show a data from sql server in gridview

Question

Hi, i am beginner for Dot Net and i don't know how to show a data from sql server in gridview. Please give me solutions . Thanks & Regards

Narasimha Reddy Chennupalli · Answer

Hi Rahul, Small correction on your code snippet SqlCommand cmd=new SqlCommand("select * from table_Name", con); SqlDataAdapter da=new SqlDataAdapter(cmd,con);//Wrong // here no need to give connection SqlDataAdapter da=new SqlDataAdapter(cmd);// correct // bcz you already mention the connection in cmd(object of Sql Command).

Rahul Prajapat · Answer

String strConnection="";// connection string here SqlConnection con=new SqlConnection(strConnection); con.Open(); SqlDataAdapter da=new SqlDataAdapter(select * from table_Name", con); Dataset ds=new Dataset (); da.fill(ds); Gridview1.DataSource=ds; Gridview1.DataBind(); con.Close();

Narasimha Reddy Chennupalli · Answer

we can show the data from database using Gridview. String strConnection="";// connection string here SqlConnection con=new SqlConnection(strConnection); SqlCommand cmd=new SqlCommand("select * from EmpTable", con); SqlDataAdapter da=new SqlDataAdapter(cmd); Dataset ds=new Dataset (); con.Open(); da.fill(ds); Gridview1.DataSource=ds; Gridview1.DataBound; con.Close();

Munesh Sharma · Answer

http://dotnetprof.blogspot.in/2012/08/display-data-from-database-using.html

Pankaj Kumar Choudhary · Answer

Hello @Satish you can refers these sites how to get data from sql database to gridview by coding C# DataGridView Binding - SQL S how to display data from sql server in gridview - CodeProject erver dataset

Rakesh · Answer

http://www.c-sharpcorner.com/UploadFile/b926a6/fill-gridview-record-from-database-using-Asp-Net-control-com/

Rajeesh Menoth · Answer

Hi, Examples are given below.. 1) http://www.aspdotnet-suresh.com/2015/03/insert-fetch-data-from-access-database-in-aspnet-using-csharp-vbnet.html 2) http://www.codeproject.com/Questions/361703/how-to-display-data-from-sql-server-in-gridview 3) http://www.dotnetspark.com/kb/643-how-to-editupdatedelete-gridview.aspx 4) http://www.aspdotnet-suresh.com/2013/04/display-images-in-aspnet-gridview-from.html 5) http://www.aspdotnet-suresh.com/2011/02/how-to-inserteditupdate-and-delete-data.html

how to show a data from sql server in gridview

Answers (7)