get DataTable of a DataGrid

[hamid]

i have a datagrid with following code

this.dataSet11.Clear();
this.oleDbDataAdapter1.Fill(this.dataSet11,"ClientsTable");
this.dataGrid1.DataSource=this.dataSet11.Tables["ClientsTable"].DefaultView;
DataTable dataTable = (DataTable)dataGrid1.DataSource;

but app return error when try this line:

DataTable dataTable = (DataTable)dataGrid1.DataSource;

why?

i want this code for autoresize DataGrid, so let me know if you have a correct code for autoresizing datagrid. ;)

[PlausiblyDamp]

Does it make a difference if you set the data source to the table rather than the table's default view?

[hamid]

there is'nt DataSource properties for table object! but i remove default view and it done.

this.dataSet11.Clear();
this.oleDbDataAdapter1.Fill(this.dataSet11,"ClientsTable");
this.dataGrid1.DataSource=this.dataSet11.Tables["ClientsTable"];
DataTable dataTable = (DataTable)dataGrid1.DataSource;

thank you

[Nerseus]

If you wanted to bind to the DefaultView, then cast the DataSource back to a DataView instead of DataTable. You would do that if you wanted to bind to a filtered or sorted list of records - things the DataView lets you do.

 

-ner

[hamid]

thanks Nerseus,

so if i want use DataView in my datagrid then how can i get DataTable from it?

[hamid]

Change sort to specific column

 

how can i change sort to specific column in datagrid, in fact i want sort column that user change focus to it.

maybe you can help me about it here before i create new topic ;)