dataset 101

[crmoffat]

Hi all

Just doing my first VB.net project for Uni and have come a bit stuck using a dataset...if anybody has some advice I would appreciate it.

I have a form that has a dataAdapter on it (OleDbDataAdapter3) which I have configured with a WHERE statement based on ItemID which I get from a text box. I want to get the other data from the dataset (dataset11) such as the description field, the title etc. I can do this by binding a textbox (did that to make sure the DataAdapter WHERE statement was working...however I was wondering if there is a way to use the dataset data straight into a variable. I tired the following...

strDescription = Me.txtDescription.DataBindings.Add(New System.Windows.Forms.Binding("Text", Me.DataSet11, "Items.Description"))

but I get the error message saying "this expression does not produce a value". Is there an easy way to get the value from a dataset? I can post more code if it's helpful...

thanks in advance

cameron

[mendhak]

Just by looking at the names of the dataset and dataadapter, I'm pretty sure you're using the drag and drop method of creating your datasets. I am not very familiar with that method, and neither are a lot of the members here. We prefer handcoding it.

Here's a simple example with a sqldataadapter:

Dim da As SqlClient.SqlDataAdapter
        Dim strSQL As String
        Dim strConn As String
 
        strConn = "Data Source=(local); Initial Catalog=Northwind; User ID=sa;"
        strSQL = "SELECT * FROM Products"
 
        ds = New DataSet
        Try
            da = New SqlClient.SqlDataAdapter(strSQL, strConn)
            da.Fill(ds, "Products")
            TextBox1.text = ds.Tables(0).Rows(0).Item(4).ToString()
 
        Catch ex As Exception
            MessageBox.Show(ex.Message.ToString)
 
        End Try

[crmoffat]

Cheers

it's the drag and drop that is making the whole thing hard I think....it's the way the lecturer reccomended doing it...however just looking at your code it's clearer what is actually happening so think I will make the switch to handcoding

thanks for the assistance
cameron

[mendhak]

That's why I reccommended this method. It helps you understand what actually is going on. I do not understand why your lecturer would reccommend this, but hey, to each his own.