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 NameObjConnection); //Give the table name from where you want to fetch data DatSet ObjDataSet= new ObjDataSet(); ObjDataAdapter.Fill(ObjDatasetDataset 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();