How to display some columns of database

Question

i have database and i don't want to load all columns how can i go about it so that datagrid will select columns on form load

Pankaj Kumar Choudhary · Answer

You can use this method SqlCommand com = new SqlCommand(select * from TblMaster_Main_Categorycon); //This query will return a collection of all column of table TblMaster_Main_Category SqlDataAdapter da = new SqlDataAdapter(com); DataTable tab = new DataTable(); da.Fill(tab); //WE take a new table DataTable tab2 = new DataTable(); DataRow[] tb=new DataRow(); tb= tab.Select(select Serial_OrdernvCategory_Name); // this query return a collection of all column which you want to select foreach (DataRow dr in tb) { tab2.Rows.Add(dr); } tab2.AcceptChanges(); // Now you can Binf this table to your gridview