Hi,
It should. I dont think you need the mbr. Try this.
dfsMbr_Surname.DataBindings.Add(New Binding("Text", dsMbr, "mbr_surname"))
Ken
-------------------
"Marnie" <anonymous@discussions.microsoft.com> wrote in message
news:B86ADE35-B120-4559-A9C1-7418F310E320@microsoft.com...[color=blue]
> Hi Ken,
> Thanks for your response.
>
> I did try using something similar to that ie:
>
> Protected Sub BindControls()
> dfsMbr_Surname.DataBindings.Add(New Binding("Text", dsMbr,
> "mbr.mbr_surname"))
> End Sub
>
> Should that work too?
>
> Although I wasn't sure then where to call BindControls() from? Where are
> you suggesting to put the code:
> TextBox2.DataBindings.Add("Text", ds.Tables(0), "CategoryName")
>
> Does Tables(0) select the first table (being the only one in my case) in
> the query?
>
> I thought that I was going to be able to do this by going through the
> properties of TextBox2 (in my case dfsMbr_Surname) as per the
> documentation. I assume the code you gave me is generated for you if you
> do it through the properties dialog?
> Still wondering why nothing appeared in the Data Bindings section of the
> datafield properties?
> Thanks,
> Marnie.
>
>
>
> ----- Ken Tucker [MVP] wrote: -----
>
> Hi,
>
> To bind a textbox to a datasource. This will bind the
> CategoryName
> field of a dataset ds to textbox2.
>
> TextBox2.DataBindings.Add("Text", ds.Tables(0),
> "CategoryName")
>
> To use the oracle data provider you need to add a reference to
> system.data.oracleclient.dll.
>
>
>
http://msdn.microsoft.com/library/de...sctorTopic.asp
>
> Ken
> ------------------
>
> "Marnie" <anonymous@discussions.microsoft.com> wrote in message
> news:434EAECA-8715-4AE0-9321-CC6270A2D518@microsoft.com...[color=green]
> > Hi there,
> > I am new to VB.Net (formerly a Centura 'Gupta' programmer) and just[/color]
> trying[color=green]
> > to do a simple excercise out of the help to populate a couple of[/color]
> text[color=green]
> > fields on a form by using a parameterized query..
> > ie. Walkthrough 'Displaying Data in a Windows Form Using a[/color]
> Parameterized[color=green]
> > Query'
> > Sounds simple but for some reason when I get to the step where you[/color]
> are[color=green]
> > supposed to 'Expand the (DataBindings) node, and for the Text[/color]
> property,[color=green]
> > expand DsAuthors1, expand authors, and select au_id from the[/color]
> drop-down[color=green]
> > list.'
> > I don't have a drop down list?! It's empty.
> > Please help me find what I'm missing here![color=darkred]
> >> I have the following on my form:[/color]
> > OdbcDataAdapter with a simple select command 'SELECT MBR_SAID,
> > MBR_SURNAME, MBR_ADDR1 FROM FHP_MBR WHERE (MBR_SAID = ?)'
> > OdbcConnection (to an Access database)
> > and a DataSet (dsMbr)[color=darkred]
> >> The following code is for the button click:[/color]
> > Private Sub Button1_Click_1(ByVal sender As System.Object, ByVal e[/color]
> As[color=green]
> > System.EventArgs) Handles Button1.Click
> > OdbcDataAdapter1.SelectCommand.Parameters("mbr_sai d").Value =
> > dfnMbr_said.Text
> > dsMbr.Clear()
> > OdbcDataAdapter1.Fill(dsMbr)
> > End Sub[color=darkred]
> >> So what am I missing here please? I know it's probably simple... I[/color][/color]
> just[color=green]
> > need a jumpstart!
> > How do I bind the results of this query to the appropriate fields?
> > I am using the VB.Net Standard edition and have therefore had to[/color]
> export my[color=green]
> > Oracle tables into Access for the purpose of this excercise since I
> > believe you need the full blown Enterprise edition of Visual Studio[/color]
> to[color=green]
> > connect to Oracle.
> > Thanks,
> > Marnie.
> >[/color][/color]
