Use datagridview columns added from the designer on data table

Denis Morgan

void loadData()
{
dt = new DataTable();
dt.Columns.Add("Country", typeof(string));//dont want to add these columns here want to use columns from datagrid
dt.Columns.Add("Sales", typeof(int));//dont want to add these columns here want to use columns from datagrid
dt.Rows.Add(new object[] { "Argentina", 2000 });
dt.Rows.Add(new object[] { "Belgium", 4500 });
dataGridView1.DataSource = dt;
}

I need to use BindingSource class to filter data and i dont know how else i can do it so that I have columns added from the designer and am able to filter datagrid. https://stackoverflow.com/questions/63245000/filter-datagrid-view-from-data-populated-from-entity-in-c-sharp is the post that I had previously posted to get help on how to filter datagridview but the solutions seems is have to bind data using datasource. I need to maintain the style and format applied to the datagridview columns on the designer

I have created a datagridview in designer view and added columns to it. My question is how I can access these columns from my DataTable object instead of again manually adding columns to the Datatable again(Re use columns added from datagridview on Datatable). This is what have done so far

6 Replies

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

Laxmidhar Sahoo6y ago
hi

you can not add both columns of grid view and data table in designing view .But can add dynamic

Thanks and regards
+1
Navaneeth Krishnan6y ago
dataGridView1.Rows.Add(new object[] { "Country", typeof(string)})
dataGridView1.Rows.Add(new object[] { "Sales", typeof(int)})
+1
Denis Morgan6y ago
hello have explained more here
https://stackoverflow.com/questions/63410154/use-datagridview-columns-added-from-the-designer-on-data-table

the columns in the datagridview to be populated with data on datatable object
+1
Laxmidhar Sahoo6y ago
Hi

Re useble columns means dynamic columns or something else ?

Thanks and regars
+1
Denis Morgan6y ago
Hello I want to re use datagrid view columns
+1
Laxmidhar Sahoo6y ago
hi

whether you want to re initialize the data table and according to the data table the columns of the grid manipulated or something else

Thanks and regards
0