How to bind SQL data into HTML dropdownlist using vb.net.

Question

0.00/5 (No votes)

See more:

Hi all,
how to bind sql data into html dropdownlist using vb.net.
the dropdownlist should fill when the pageload event starts.

i have tryied databind into dropdownlist , its working fine.
but my sql table column should come like below, that i can't do the expected output.

MCH- Batch|0 ; non mch - Batch|1

But my expected output is,

MCH-Batch
non mch-Batch

Please drop me a solution.
thanks in advance

What I have tried:

how to bind sql data into html dropdownlist using vb.net.

Posted 28-Jun-16 20:58pm

stellus

Updated 9-Jul-16 2:33am

Add a Solution

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

khaled Ezzat Abdelfattah Abdelgawad · Answer 1 · 2016-07-07T22:54:00

Solution 1

Why don't you use server side Dropdownlist and SQLDatasource to get data from sql then you in the design time you may select the Dropdownlist and configure its datasource property to use sqldatasource and set the "display member" property and the "value member" property to the fields you need from your sql query.

Posted 7-Jul-16 22:54pm

khaled Ezzat Abdelfattah Abdelgawad

Updated 7-Jul-16 22:56pm

v2

khaled Ezzat Abdelfattah Abdelgawad · Answer 2 · 2016-07-09T00:53:00

Solution 2

In The Source

<![CDATA[<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default6.aspx.vb" Inherits="Default6" %>]]>

Posted 9-Jul-16 0:53am

khaled Ezzat Abdelfattah Abdelgawad

khaled Ezzat Abdelfattah Abdelgawad · Answer 3 · 2016-07-09T02:31:00

ASP.NET

<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default6.aspx.vb" Inherits="Default6" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head  runat="server">
    <title></title>
</head>
<body>
    <form id="form1"  runat="server">
    <div>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
            ConnectionString="<%$ ConnectionStrings:StreamNETConnectionString %>" 
            SelectCommand="SELECT TOP (10) * FROM Worker"></asp:SqlDataSource>
        <asp:DropDownList ID="DropDownList1" runat="server" 
            DataSourceID="SqlDataSource1" DataTextField="FullName" 
            DataValueField="WorkerID">
        </asp:DropDownList>
    </div>
    </form>
</body>
</html>

khaled Ezzat Abdelfattah Abdelgawad · Answer 4 · 2016-07-09T02:33:00

Solution 4

VB.NET

Partial Class Default6
    Inherits System.Web.UI.Page

    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        DropDownList1.SelectedValue = 1
    End Sub
End Class

Posted 9-Jul-16 2:33am

khaled Ezzat Abdelfattah Abdelgawad

How to bind SQL data into HTML dropdownlist using vb.net.

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0

Existing Members

...or Join us