Hi Bonnie,
I found another way and hope it's correct..
I created a DataRow object:
For Each myDR In myDS.Tables("Bank").Rows
Next
Then assign my form textbox to the fiels:
Me.txtBankName_e.Text = Trim(myDR("bankname_e"))
But stuck in 2 things:
1. Could not assign the myDS to my combo box ( Me.cbSelect.DataSource = myDS)
2. Could not update the dataset with the modified data :
myDR.BeginEdit()
myDR("bankname_e") = Me.txtBankName_e.Text
myDR.EndEdit()
myDR.AcceptChanges()
myDA.Update(myDS, "bank")
So what do you think?
>Hi Ahmad,
>
>First you need to databind your textbox (and I hope I get the VB syntax right):
>
>me.DataBindings.Add("Text", MyTable, "MyColumn")
>
>Then, you use the Position property of the BindingContext to navigate the rows:
>
>-- nRow is an integer, specifying which row of the DataSet you are on.
>me.BindingContext(MyTable).Postion = nRow
>
>
>HTH,
>~~Bonnie
>
>
>
>>Hi All,
>>
>>I succeeded to create my DataSet & DataAdapter:
>>Dim myDS As New DataSet()
>>Dim myDA As New SqlClient.SqlDataAdapter("Select * From AN_Bank", myConn.oConnection)
>>myDA.Fill(myDS, "MyTable")
>>
>>- But stuck in retrieving the table rows and assigning the table fields to my form TextBox
>>
>>- How record Louck in handeled in MS-MSDE?
>>
>>Can anyone help please?
<><><><><><><><><><><><><><><><><><><><>
<><> REMEMBER,,,,KNOWLEDGE IS POWER <><>
<><><><><><><><><><><><><><><><><><><><>