Displaying data in gridview in c#

Question

How t display whole table in gridview in c#

Mayur Gujrathi · Answer

TRY THIS IT MAY HELP YOU con = new SqlConnection ( "User Id=Sa;Password=123;Database=CSharp" ); cmd = new SqlCommand ( "Select_employee" , con); cmd.CommandType = CommandType .StoredProcedure; da = new SqlDataAdapter (cmd); ds = new DataSet (); da.Fill(ds, "employee" ); dataGridView1.DataSource = ds.Tables[0];

Bala Krishnan · Answer

Hi am able to work on this but , what i need is i need to display a data with time interval , is it possible ?

Purushottam Rathore · Answer

Hi rahul Drag and drop Gridview on your page from toolbar asp : GridView ID ="DataGrid1" runat ="server"> asp : GridView > Write the code to bind the record into Gridview as: private void ShowFavoriteArticles() { SqlConnection con = new SqlConnection (); SqlCommand cmd = new SqlCommand (); con = new SqlConnection ( "Data Source=TestServer;Initial Catalog=TestData; uid=sa;pwd=wintellect" ); cmd.Connection = con; cmd.CommandText = "Select * from Puru_test_Employee" ; con.Open(); Gridview1.DataSource = cmd.ExecuteReader(); Gridview1.DataBind(); con.Close(); }

Ankit Nandekar · Answer

Rahul r u working in nashik?

Karthikeyan Anbarasan · Answer

Take this small code sample to bind the data SqlConnection sqlConnection = new SqlConnection ( "connectionString" ); SqlDataAdapter sqlDataAdapter = new SqlDataAdapter ( "Select * From TableName", sqlConnection ); DataSet dataSet = new DataSet (); GridView1.DataSource = dataSet; GridView1.DataBind ();

Ravishankar Singh · Answer

Hi Rahul, Check this article .Hope it will be helpfull for you.

Ankit Nandekar · Answer

if you want to display whole table in gridview follow this simple steps.... 1. you should create connection with database and fetch all data with the use of DataAdapter and store it into DataSet like SqlConnection con = new SqlConnection("ConnectionStringSettings name");//pass ur Connection String name here SqlDataAdapter da = new SqlDataAdapter("Selecrt Query", con); DataSet ds = new DataSet(); da.Fill(ds,"tablename"); 2.Now Bind DataSet With GridView Like GridView1.DataSource = ds.Tables[0]; GridView1.DataBind(); Note: Dont Forget to add Namespace using System.Data; and using System.Data.SqlClient; if u get any problem then let me know.