VB.NET - how to retrieve values from database into dropdownlist....???

Use this code-



SqlConnection con = new SqlConnection("con string ");
SqlDataAdapter da;
string mySQL = "Your Query";
da = new SqlDataAdapter(mySQL, con);
DataSet ds = new DataSet();
da.Fill(ds);
ddl1.DataValueField = "col1";
ddl1.DataTextField = "col2";
ddl1.DataSource=ds;
ddl1.DataBind();

Try this and let em know.

Hi Frndz,

 

Functionality:  Bind DropDown trhogh DB table

 

 

 

Logic:

 

 

Hope this helpful!

Thanks

 

 

eg :
if we type college name automatically thje dropdownlist which stores branch name should be updated with all the branches available in that particular college


collegename:(textbox)--->once we enter collegename all branches available in that college should appear in  the dropdownlist---
branch:(dropdownlist)

eg :
if we type college name automatically thje dropdownlist which stores branch name should be updated with all the branches available in that particular college


collegename:(textbox)--->once we enter collegename all branches available in that college should appear in  the dropdownlist---
branch:(dropdownlist)

eg :
if we type college name automatically thje dropdownlist which stores branch name should be updated with all the branches available in that particular college


collegename:(textbox)--->once we enter collegename all branches available in that college should appear in  the dropdownlist---
branch:(dropdownlist)

For this you need to Implement TextBox_Changed event like this-

protected void txtCollege_TextChanged(object sender, EventArgs e)
    {
      SqlConnection con = new SqlConnection("con string ");
      SqlDataAdapter da;
      string mySQL = "select * from tablename where collegename='" + txtCollege.Text + "'";
      da = new SqlDataAdapter(mySQL, con);
      DataSet ds = new DataSet();
      da.Fill(ds);
      ddl1.DataValueField = "col1";
      ddl1.DataTextField = "col2";
      ddl1.DataSource = ds;
      ddl1.DataBind();

    }

Hi Frndz,

 

Functionality:  Ontexbox Change Event Bind DropDown list trhough DB table

 

Added one texbox set AutoPostback True and added OnTextChange Event

 

<asp:TextBox ID="txtCollage"  runat="server" OnTextChanged="txtCollage_TextChanged" AutoPostBack="true"></asp:TextBox>

 

After then based on Collage Textbox value bind Dropdown

 

        myCMD.CommandText = "Select BaranchID, BranchName from Collage where CollageName='" + txtCollage.Text + "'";

 

 

Full Logic wtih Textbox and DropDown    :

 

<asp:TextBox ID="txtCollage"  runat="server" OnTextChanged="txtCollage_TextChanged" AutoPostBack="true"></asp:TextBox>

    <asp:DropDownList ID="ddlBranch" runat="server"></asp:DropDownList>

 

 

protected void txtCollage_TextChanged(object sender, EventArgs e)

    {

      BindBranchDDByCollageName(ddlBranch);

 

    }

    public void BindBranchDDByCollageName(DropDownList ddlBranch)

    {

 

      SqlConnection con;

      SqlCommand myCMD;

      SqlDataReader myReader;

      try

      {

        con = new SqlConnection(Convert.ToString(System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"]));

        con.Open();

        myCMD = new SqlCommand();

        myCMD.Connection = con;

        myCMD.CommandTimeout = 200;

        myCMD.CommandText = "Select BaranchID, BranchName from Collage where CollageName='" + txtCollage.Text + "'";

        myCMD.CommandType = CommandType.Text;

        myReader = myCMD.ExecuteReader();

        ddlBranch.DataSource = myReader;

        ddlBranch.DataValueField = "BranchID";

        v.DataTextField = " BranchName";

        ddlBranch.DataBind();

        myReader.Close();

        con.Close();

      }

      catch (Exception ex)

      {

        throw ex;

      }

    }

 

Hope this helpful!

Thanks

 

 

its not working,,, after i enter data in the textbox drop down list is showing empty...this is ma code once please check it once and tell me the error--

aspx page-

<asp:DropDownList ID="DropDownList1" runat="server" Width="279px" AutoPostBack="True">

</asp:DropDownList>

aspx.vb page-

Protected Sub TextChanged(ByVal sender As Object, ByVal e As EventArgs)

BindSupplierNameByPartNumber(DropDownList1)

End Sub

Public Sub BindSupplierNameByPartNumber(ByVal DropDownList1 As DropDownList)

Dim con As SqlConnection

Dim myCMD As SqlCommand

Dim myReader As SqlDataReader

Dim strconn As String

Try

strconn = "Data Source=10.179.26.2;Initial Catalog=PPEP;user id=scala;pwd=scala"

con = New SqlConnection(strconn)

con.Open()

myCMD =

New SqlCommand()

myCMD.Connection = con

myCMD.CommandTimeout = 200

myCMD.CommandText = "select SNAME from sqm where PNUMBER='" + TextBox1.Text & "'"

myCMD.CommandType = CommandType.Text

myReader = myCMD.ExecuteReader()

DropDownList1.DataSource = myReader

DropDownList1.DataTextField = "SNAME"

DropDownList1.DataBind()

myReader.Close()

con.Close()

Catch ex As Exception

Throw ex

End Try

End Sub

Hi Frndz,

 

Functionality:  DropDown  Bind Problem

 

First Pass DataValue Field as Same as DataTextField

 

DropDownList1.DataTextField = "SNAME"

DropDownList1.DataValueField = "SNAME"

 

 

After then check in sqm table has data or not for search PNUMBER

 

 

Logic   :

 

DropDownList1.DataSource = myReader

DropDownList1.DataTextField = "SNAME"

DropDownList1.DataValueField = "SNAME"

DropDownList1.DataBind()

 

Hope this helpful!

Thanks

 

 

 

thankyou so much!! i have got it:):)

thankyou!! i got it:):)

You always welcome.