Show specific column into gridview from DataSet

Question

Hi I have a Dataset which contain one tabel and fields are EmpNameAddress City I have applied DataView filter on City and displing data on Gridview but i dont want show City coulumn and its data in Gridview In DataSet EmpName Address City AAA BBB Pune AAA BBB Pune AAA BBB Pune AAA BBB Pune and i want to show data into gridview like EmpName Address AAA BBB AAA BBB AAA BBB AAA BBB Please help me how can i do this Regards Sameer Shaikh

sameer shaikh · Answer

@Karthi and @Vivek Thanks for you help I got solution i have tried this in another way like below DataView view = new DataView(); view.Table = ds.Tables[0]; view.RowFilter = status='New'; dt = view.ToTable(); dt.Columns.Remove(status); gvPubPlanCreated.DataSource = dt; gvPubPlanCreated.DataBind(); this help to hide a status column from Gridview after applying filter on dataSet Regards Sameer Shaikh

Karthi Keyan · Answer

@sameer Try this DataTable dtTable = ds.Table[0].DefaultView.ToTable( true  EmpNameAddress ); Grid.DataSource = dtTable;

sameer shaikh · Answer

@Jyoti Thanks for your help but i have did this and i have data in DataSet. I was trying to apply filter on DS and save that data into specific GV and that column i mean filter column like i wrote below DataTable dt=new DataTable(); DataView view = new DataView(); view.Table = ds.Tables[0]; view.RowFilter = status='New'; dt = view.ToTable(); dt.Columns.Remove(status); gvPubPlanCreated.DataSource = dt; gvPubPlanCreated.DataBind(); Regards Sameer Shaikh

Karthi Keyan · Answer

@Sameer i didn't try that in dataview. but it should work in the DataTable and Dataset. Try this surely you will get output.

sameer shaikh · Answer

@Vivek I am getting data from Db and i have set AutoGeneratedColumn=true Show data into Grid dynamically. Please let me know How can i fix this problem. Regards Sameer Shaikh

sameer shaikh · Answer

@Karthi Sorry for late reply I was busy on other stuff. As per you have mentioned with dataset Can i do same thing with DataView. Regards Sameer

Vivek Kumar · Answer

Have a look into the below links. https://stackoverflow.com/questions/6358799/asp-net-programatically-bind-dataset-to-gridview https://stackoverflow.com/questions/10941104/c-sharp-and-asp-net-getting-a-specific-column-from-a-dataset-in-gridview

Jyoti Jodha · Answer

public static DataTable GetGridDatasource ( string database  string ordnum ) { using ( OleDbConnection con = new OleDbConnection ( PROVIDER=Microsoft.ACE.OLEDB.12.0;Data Source= + database )) { con . Open (); OleDbCommand cmd = con . CreateCommand (); cmd . CommandText = select * from [Order] where order_num=[OrderNumber] ; cmd . CommandType = CommandType . Text ; cmd . Parameters . AddWithValue ( OrderNumber  ordnum ); OleDbDataAdapter da = new OleDbDataAdapter ( cmd ); DataTable dt = new DataTable (); da . Fill ( dt ); return dt ; } }