How to dispaly Data in gridview From Database with example.

Question

How to dispaly Data in gridview From Database with simple example.

Pankaj Kumar · Answer

Try to this code: take one button control and one gridview control . then write the code in button event see below example. using System; using System.Data; using System.Configuration; using System.Collections; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using System.Data.SqlClient; public partial class GridViewControl1 : System.Web.UI. Page { SqlConnection con; SqlDataAdapter da; DataSet ds; protected void Button1_Click( object sender EventArgs e) { con = new SqlConnection ( user id=sa;password=sa;database=C#Prac;Data Source=. ); ds = new DataSet (); da = new SqlDataAdapter ( SELECT * FROM Dept  con); da.Fill(ds Stud ); GridView1.DataSource = ds.Tables[0]; GridView1.DataBind(); } }

waqas memon · Answer

try this too with extra highlight row functionality.. http://www.codingresolved.com/discussion/894/how-to-correctly-highlight-gridview-rows-on-mouseover-in-asp-net/p1

sandy kumar · Answer

nice sir