Hello
I have a form with a datagrid that i bound to a table and
several controls and 1 combobox box. The combox is bound
to a datatable. When i click and a row the grid i want to
read the values and update all the controls of the form
and also the combobox - that has dropdownlist style on.
Here the code :

        Dim dataset3 As New DataSet()
        Dim tabela1 As New DataTable()
        dim cliente as string = 'Delphi'

        SqlDataAdapter2.Fill(dataset3, "clientes")
        tabela1 = dataset3.Tables("clientes")
        dataset3.Tables(0).PrimaryKey() = New DataColumn
() {dataset3.Tables(0).Columns("nome")}

        Dim view As New Data.DataView()
        view.Table = tabela1
        view.RowFilter = "Nome = '" & cliente & "'"

        ComboBox1.DataSource = tabela1
        ComboBox1.DisplayMember = "Nome"

When the form loads it show all clients in combobox1 i i change it to :
        ComboBox1.DataSource = view
        ComboBox1.DisplayMember = "Nome"

It only shows one client. What i want is the combo to contain all clients and to display the searched one.

Any suggestion would be most welcome, thanks.

Kind Regards
Jorge Cavalheiro




Sleep is for the weak.

As per the qry i undestood was, whn u click on the Grid on Form, the data should be filtered as per the PK value and form controls should have the value of the Gird's Primary Key Value.

As per ur code no need to create a PK in the DataTable, whn u fill the dataset after filling it use the select method of the Dataset and the Pass the Grid's Selected Rows Value in it and Bind to the Controls/Combo u want.


Dim dataset3 As New DataSet()
SqlDataAdapter2.Fill(dataset3, "clientes")

dataset3.Tables("clientes").Select("nome='" & DATAGRID'S SELECTED ROW VALUE & "'")

if isnothing(combobox1.datasource))=FALSE then
     combobox1.datasource=NOTHING
end if


combobox1.datasource=dataset3.Tables("clientes")
combobox1.displaymember="nome"

I Hope this will solve ur problem.
if u any further quieries u can get back to me @






Allways try and U'll Be successful
Bhavin