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

How to dispaly Data in gridview From Database with example.

Answers (3)