Create RDLC report using vb.net 2010 from SQL database
Private Sub Formlogin_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Try
Dim con As New SqlConnection
con.ConnectionString = "connection Path"
con.Open()
Dim cmd1 As New SqlClient.SqlCommand("select'columnname' from 'tablename'", con)
Dim da As New SqlClient.SqlDataAdapter(cmd1)
Dim ds As New DataSet()
da.Fill(ds, "list")
Dim col As New AutoCompleteStringCollection
Dim i As Integer
For i = 0 To ds.Tables(0).Rows.Count - 1
col.Add(ds.Tables(0).Rows(i)("columnname").ToString)
Next
TextBox1.AutoCompleteSource = AutoCompleteSource.CustomSource
TextBox1.AutoCompleteCustomSource = col
TextBox1.AutoCompleteMode = AutoCompleteMode.Suggest
con.Close()
Catch ex As Exception
MessageBox.Show(ex.ToString)
End Try
End Sub