how to get s specific column from a data source

[Administrator]

Hi there,
How do I get a specific column from a table in a bound data source?

DataSet ds;
...

this.ds.Table["myTable"]....?????

grid.DataSource = [just the column I want];

Thanks
Dimitri

[Administrator]

I should add that my data is coming from XML...

myDataSource.ReadXML("file");


>Hi there,
How do I get a specific column from a table in a bound data source?

DataSet ds;
...

this.ds.Table["myTable"]....?????

grid.DataSource = [just the column I want];

Thanks
Dimitri

[Administrator]

Any help on this would be great, thanks.

>I should add that my data is coming from XML...

myDataSource.ReadXML("file");


>Hi there,
How do I get a specific column from a table in a bound data source?

DataSet ds;
...

this.ds.Table["myTable"]....?????

grid.DataSource = [just the column I want];

Thanks
Dimitri

[Administrator]

Hi Dimitri,

Use the GridBoundColumns property to manages the bound columns in a GridDataBoundGrid. Here is a code snippet.

//Clear the All columns bound to grid...
this.gridDataBoundGrid1.GridBoundColumns.Clear();

//Add the new column to display in a grid.
GridBoundColumn EmpName = new GridBoundColumn();
EmpName.MappingName = "ColumnName";
this.gridDataBoundGrid1.GridBoundColumns.Add(EmpName);

this.gridDataBoundGrid1.DataSource = ds.Tables[0];

Here is a sample.
GDBGSingleColumn.zip

Best Regards,
Haneef

[Administrator]

Thank you Haneef - that works, except that it doesn't let me load combo box cells from yet another DataSource. How can I do that?

[Administrator]

Hi Dimitri,

Try setting the StyleInfo.CellType property of the BoundColumn to "ComboBox" in a grid. Here is a code snippet.

GridBoundColumn EmpName = new GridBoundColumn();
EmpName.MappingName = "EmpName";
EmpName.HeaderText = "EmployeeName";
EmpName.StyleInfo.DataSource = GetComboTable();

//For setting the Combobox column with datasource as Datatable.
EmpName.StyleInfo.CellType = "ComboBox";
EmpName.StyleInfo.ValueMember = "ComboEmpName";
EmpName.StyleInfo.DisplayMember = "ComboEmpName";

this.gridDataBoundGrid1.GridBoundColumns.Add(EmpName);

Here is a modified sample.
GDBGModifiedsample.zip

Best Regards,
Haneef

[Administrator]

Thanks!
I will take a look.