Show specific column into gridview from DataSet

sameer shaikh

I have a Dataset which contain one tabel and fields are EmpName,Address, 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

and i want to show data into gridview like

EmpName Address

AAA BBB

Please help me how can i do this

Regards

Sameer Shaikh

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

sameer shaikh9y ago
@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
sameer shaikh9y ago
@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 Keyan9y ago
@Sameer,

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

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;