Hi All,

Finaly I found a way to get my data & I hope it's correct..
1. Created the DataAdapter
2. Created the DataSet
3. Filled the DataAdapter with the my table information.

Now I need to assign my info which in the table to appear in my form textbox, so to do that I did the following:

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")


Any suggestions please.

ADSC