how the hell do i do this

[carlblanchard]

Hey all, bit of a long winded one here

ok created a oledbconnection - fine
created oleDataAdapter - fine
Created dataset11 - fine

everything works fine (this is all done with VS.net built in controls)

HOW THE HELL DO I STUFF A VARIABLE WITH SOMETHING FROM THE DATASET

i need this

m_intBlockId = blah blah blah from binding data
here is some of windows generated code

Me.txtAccId.DataBindings.Add(New System.Windows.Forms.Binding("Text", Me.DataSet11, "CustomerDetails.CustomerId"))

i need to fill m_intBlockId with a column titled "BlockId"

????????????????????????

[ishaaseja]

Can you be a bit clear about what you want..As far as I could get your problem, you want to extract the data from a DataSet into a variable. Am I right? then whats this Binding all about...

[Edneeis]

Yeah I'm not sure what the binding is about either but here all the data is in the dataset once its filled. A dataset is a collection of dataTables which are just collections of dataRows. So you just drilldown to the data you need: MyDataSet.Tables("MyTable").Rows(0)("MyField")

So something like this:

m_intBlockId=Me.DataSet11.Tables("CustomerDetails").Rows(0)("CustomerId")