Help with DataGridView !!!

[Webwzrd]

Here is my problem: I have populated my dataset from an XML document. I have verified that the data is in the dataset. I have set the datasource for the databindingSOurce to be " BS1.datasource = ds.Tables(0)"

I then set the Datasource for the DataGridView to BS1

And All I still get is a grey box! Can someone please tell me what I'm doing wrong????

Here is my code:

Dim ds As New DataSet
ds.ReadXml(getFilePath() & "\ScheduleData.xml", XmlReadMode.InferSchema)

BS1.DataSource = ds.Tables(0)
dg1.DataSource = BS1

 

[NervousRex]

off top of my head as I'm dealing with my own problem, don't you need a dg1.databind() ?

 

[Webwzrd]

The windows DataGridView dosnt have a DataBinde() Method.

 

[SiriusBlackOp]

What value does BS1 serve for you???

dg1.DataSource = ds.Tables(0)
dg1.DataBind() 'If it's an ASP.NET App

Senior Software Developer

http://www.scoutsft.com

 

[Webwzrd]

No, this is a windows app. Thats why I'm having trouble.

 

[SiriusBlackOp]

No, this is a windows app. Thats why I'm having trouble.

Huh?

Why are you using the DataGridVeiw? You don't need it! it is used for Excel... Not a DataGrid.

Just use:

dg1.DataSource = ds.Tables(0)

and get rid of the DataGridVeiw object. If you want to sort and filter a dataset post query, then you can use something like this:

Dim dv as New DataView(ds.Tables(0))
dv.RowFilter = "SomeColumn='criteria'"
dv.Sort = "SomeColumn DESC"
dg1.DataSource = ds.Tables(0)

Make sense?

Senior Software Developer

http://www.scoutsft.com

 

[SiriusBlackOp]

My Bad... Change the last line to

dg1.DataSource = dv

Senior Software Developer

http://www.scoutsft.com