How can you fill combobox in vb.net with column name from Microsoft SQL Server

Question

How to fill combobox in vb.net with column name from Microsoft Sql Server? I have table name called Table_Categories. I wish to fill the combobox with the column names of that table . I am also planning on adding column names in the table using vb.net as its front end . how can I do it ?

    Public Sub Categories()
    Dim Connect As New SqlConnection
    Dim Adapter As New SqlDataAdapter
    Dim DataTable As New System.Data.DataTable
    Dim Query As String
    ConnectionString = "Data Source=LUSPOC-PC;Initial Catalog=Sales_Invnetory;Integrated Security=True"
    Connect = New SqlConnection(ConnectionString)
    Connect.Open()
    Connect.ChangeDatabase("Sales_Inventory")
    Query = "select Column_name from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME='Table_Categories'"
    Adapter.SelectCommand = New SqlCommand(Query, Connect)

    Adapter.Fill(DataTable)
    Admin.items_category_combobx.DataSource = DataTable
    Admin.items_category_combobx.DisplayMember = "Column_name"
    Admin.items_category_combobx.ValueMember = "Column_name"

End Sub

Please avoid using the comments to write code. Edit your question instead. — Zohar Peled
– Zohar Peled, Commented Sep 1, 2016 at 6:47
Don't put it as a comment. Put that in your post to help improve your question so people can help you better. — Aethan
– Aethan, Commented Sep 1, 2016 at 6:47

Akshey Bhat · Accepted Answer · 2016-09-01 12:45:46Z

0

Connect.ChangeDatabase("database-name")    
Query = "select Column_name from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME='your-Table-name'"
    Admin.items_category_combobx.DataSource = DataTable
    Admin.items_category_combobx.DisplayMember = "Column_name"
    Admin.items_category_combobx.ValueMember = "Column_name"

Change your query as above and you will get column names in your dataset. For adding column, take column name and type from user. build and execute an alter table query for adding column from it.

edited Sep 1, 2016 at 12:45

answered Sep 1, 2016 at 6:55

Akshey Bhat

8,6872 gold badges23 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

21 Comments

Akshey Bhat Over a year ago

what exactly is the problem?

Ralph Over a year ago

I edited my question with the Query use sent . for you to see how I use it . is that correct ?

Akshey Bhat Over a year ago

set displaymember and valuemember to "column_name". You have set it incorrectly

Akshey Bhat Over a year ago

check my modified answer

Ralph Over a year ago

you mean the rest are correct already ? I already change it to Column_name ,still nothing happens . by the way Im a module , do i need to put it on the combobox ?

|

Chetan Sanghani · Accepted Answer · 2016-09-01 08:08:48Z

0

          Using sqlconn As New SqlConnection("your connection string")
                sqlconn.Open()
                Using SqlCommand As New SqlCommand("select Column_name from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME='Table_Categories'", sqlconn)
                    SqlCommand.CommandTimeout = 0                     
                    Using sqlAdp As New SqlDataAdapter(SqlCommand)
                        sqlAdp.Fill(dt)
                    End Using
                End Using
        End Using
        ComboBox1.DataSource = dt
        ComboBox1.DataTextField = "Column_name" 
        ComboBox1.DataValueField = "Column_name"
        ComboBox1.DataBind()

answered Sep 1, 2016 at 8:08

Chetan Sanghani

2,1313 gold badges22 silver badges39 bronze badges

2 Comments

Ralph Over a year ago

do i have to declare DataTextField,DataValueField,DataBind() ? its not working

Ralph Over a year ago

how ? Im new at this .

Collectives™ on Stack Overflow

How can you fill combobox in vb.net with column name from Microsoft SQL Server

2 Answers 2

21 Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

21 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related