how AutoCompleteSource code work with data grid view

[muhammadanzar]

hi

qry1 = kury1
qry2 = kury2
Using connection1 As New SqlConnection("Data Source=.\SQLEXPRESS;Initial Catalog=Northwind;Integrated Security=True")
Dim command1 As New SqlCommand(qry1, connection1) '"SELECT * FROM area"
Dim table1 As New DataTable
Dim adapter1 As New SqlDataAdapter(command1)
Dim col As New AutoCompleteStringCollection
adapter1.Fill(table1)
For i = 0 To table1.Rows.Count - 1
col.Add(table1.Rows(i)(qry2).ToString()) '"AreaName"
Next
Textbox1.AutoCompleteSource = AutoCompleteSource.CustomSource
Textbox1.AutoCompleteCustomSource = col
Textbox1.AutoCompleteMode = AutoCompleteMode.SuggestAppend


i want to know, how this code work with data grid view, i want to show list of multi column in

datagrid view.


MUHAMMAD ANZAR E-mail : muhammadanzar@hotmail.com Mobile # :0092-3215096959

Continue reading...