Adding Table Field to Combobox in windows form.

See more:

VB

SQL

Dear Sir,

Please guide me how to add a Table 1 or 2 fields to a Combobox in Windows Form and Table from SQLserver Database.Kindly give complete code so I can apply to my project.
I'm using VS2010 and Databae SQLserver.
Combo Table Job_Category and my connection as follows:-

Imports System.Data.SqlClient
Public Class EmpEntryForm
    Dim connstring As String = "Data Source=.\SQLExpress;Initial Catalog=StudioSamra;Integrated Security=True;Pooling=False"
    
    Dim connection As New SqlConnection(connstring)
    Dim da As New SqlDataAdapter(connstring, conn)
    Dim sSql As String = "select * from Job_category" 

'Combo Table Name also Field to be add into combo is "Category"


Please help me.
Thanks.