Hi Ahmad,

I've been away at WhilFest, that's why I haven't replied sooner.

Two things:

1) The way you're assigning your data to the text box will work, but you really don't want to do it this way. You really need to get data binding working correctly, as in my previous replies to you. Part of the reason you may getting run-time errors when you try it is that I may have gotten the VB syntax wrong. Someone who knows VB may have to jump in here and help out.

2) Your update to the backend is not working because you need to do the da.Update() before you do the AcceptChanges(). AcceptChanges() marks all the changes in the dataset as not being changed anymore, and so the da.Update() thinks that there is nothing to be updated.

HTH,
~~Bonnie


>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?