A few basic questions on DataView and DataBinding (Mainly syntax)

[Aziz]

1. If I create a sorted DataView object from a DataSet table, how do I
reference the sorted elements? (Say I want to output the CustomerName
for the first row in the sorted DataView to a label or textbox)

Dim view As DataView = New DataView(dsData set.Customer)
view.Sort = "CustomerID ASC"
DataGrid1.DataS ource = view

2. If after displaying the CustomerName above for the first row in the
sorted DataView, how do I then change it's value. Normally with a
DataSet I'd use:

dsDataset.Custo mer.Rows(intRow Pos)("CustomerN ame") = "John Smith"

But how would it be done using the DataView. I know a DataView is read
only so obviously I'll have to pass a paramater to the Dataset code
above so it knows, that "this DataView row matches this DataSet table
row".

3.
lblCustomerID.D ataBindings.Add ("Text", dsDataset,
"Customer.Custo merID")
lblCustomerAddr ess.DataBinding s.Add("Text", dsDataset,
"Customer.Custo merAddress")

cmbCustomerName .DataSource = dsDataset
cmbCustomerName .DisplayMember = "Customer.Custo merSurname"
cmbCustomerName .ValueMember = "Customer.Custo merID"

The above code populates and binds a ComboBox so that when a Surname is
selected it simply outputs the related CustomerID and CustomerAddress
to labels. How do I make it so that both CustomerSurname and the
related CustomerForenam e both appear in the ComboBox?
4. What's the alternative to Q3 if I don't wanna use Binding. This is
what i have so far:

Private Sub FillComboBox()
Dim intCustomerRow As Integer = 0
cmbCustomerName .Items.Clear()

Do Until intCustomerRow = dsTurbobraze.Cu stomer.Rows.Cou nt

cmbCustomerName .Items.Add(dsTu rbobraze.Custom er.Rows(intRowP os)_
("CustomerSurna me").ToString () & ", " &
dsTurbobraze.Cu stomer.Rows(int RowPos)_
("CustomerForen ame").ToString( ))
intCustomerRow = intCustomerRow + 1
intRowPos = intRowPos + 1
Loop
End Sub

But all this does is fill the ComboBox with the Forenames and Surnames.
I've tried loads of code in cmbCustomerName _SelectedIndexC hanged but
none works.
I know these are basic Q's, but they also tend to be difficult to find
since everyone assumes everyone else knows it.

--

Aziz