gridview

Question

Hi i am new to .net, I need to knoe how to display the entire table data in grid view using c#..

rahul pawar · Answer

//First make the connection SqlConnection ObjConnection = new SqlConnection(" Connection string"); SqlDataAdapter ObjDataAdapter= new SqlDataAdapter("Select * from Table Name",ObjConnection); //Give the table name from where you want to fetch data DatSet ObjDataSet= new ObjDataSet(); ObjDataAdapter.Fill(ObjDataset,"Dataset table Name"); //Store data into dataset table by any Name GridView1.DataSource=ObjDataSet.Tables["DataSet Table Name"]; GridView1.Databind();

Gautam Sharma · Answer

DataSet ds = GetAllRecord(); if(ds.Rows.Count >0) { GridView1.DataSource = ds; } else { GridView1.DataSource = null; } GridView1.Databind();

Gautam Sharma · Answer

DataSet ds = GetAllRecord(); if(ds.Rows.Count >0) { GridView1.DataSource = ds; } else { GridView1.DataSource = null; } GridView1.Databind();

Raj Kumar · Answer

Dim dataTable As New DataTable dataTable = GetRecords() ' function If (dataTable.Rows.Count > 0) Then GridView.DataSource = dataTable.DefaultView GridView.DataBind() Else ErrorLabel.Visible = True ErrorLabel.Text = "No records found" .DataSource = Nothing End If

Kumar Duvvarapu · Answer

Hi, u can bind the table to gridview gridview.DataSource = dt; gridview.Databind();

gridview

Answers (5)