How to connect dropdownlist with sql database ?

Question

0.00/5 (No votes)

See more:

hey, i have two dropdownlist and one textbox in which

dpl.1> name of city
dpl.2> name of city
txtbox.1>kilometer to get

As it is connected to sql database , so i wish that the data(name of city) in dropdownlist directly select from database in both dropdownlist and quick answer the kms in txtbox.

Is there any genius , who can solve these problem....!

Posted 24-Aug-12 18:00pm

kinjal b patel

Add a Solution

Comments

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 25-Aug-12 0:08am

Not clear. Can you please elaborate simply ?

veenusethi 25-Aug-12 0:28am

do you want bind dropdownlist with sql?
if yes simply click on arrow of dropdownlist in right hand and select your database and table from where city name will come.
and on textbox you can use like
textbox.text=dropdownlist1.selecteditem.text on any event

kinjal b patel 25-Aug-12 1:03am

thanks buddy.....

AmitGajjar 25-Aug-12 3:02am

this is really very easy question. you just need to learn ADO.NET asking for code is not the right way of learning anything. i'm sorry if you think i'm rude.

Brandon Caruana 25-Aug-12 16:20pm

I agree with @amitgajjar. Have you tried google at all to find an answer?

5 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)

Abhai Oza · Answer 1 · 2012-08-24T18:44:00

Solution 1

cmd.commondtext = "Select kilometer From CityMast Where City1=drop1 and city2=drop2"
txetbox.text=cme.executesaclar().tostring();

Posted 24-Aug-12 18:44pm

Abhai Oza

Comments

kinjal b patel 25-Aug-12 0:49am

thanq........!

Mits Machhi · Answer 2 · 2012-08-24T19:35:00

You also Try this:
make Both Dropdown Autopost Back Proprty = True..

on Page Load Event :

SQL

if (!IsPostBack)
{
         FillDropDownList();
         FillDropDownList1();
}


The Function is :

 private void FillDropDownList()
    {
        DataSet ds = new DataSet();
        SqlDataAdapter myda = new SqlDataAdapter("select city from tablename ",con);
        myda.Fill(ds);
        drop_city.DataSource = ds;
        drop_city.DataValueField = "city";
        drop_city.DataBind();
    }


private void FillDropDownList1()
    {
        DataSet ds = new DataSet();
        SqlDataAdapter myda = new SqlDataAdapter("select city from tablename ",con);
        myda.Fill(ds);
        drop_city1.DataSource = ds;
        drop_city1.DataValueField = "city";
        drop_city1.DataBind();
    }

Double Click on drop_city1 Drop down

string str="Select km from tablename where city ='"+drop_city.SelectedItem.Value+"' and city1='"+drop_city1.SelectedItem.Value+"'";
        SqlDataAdapter ad = new SqlDataAdapter(str,connection object);
        DataSet ds = new DataSet();
        ad.Fill(ds);

        if (ds.Tables[0].Rows.Count != 0)
        {
            Textbox1.Text = ds.Tables[0].Rows[0][0].ToString();
        }

if any query, please post it....

Member 9120792 · Answer 3 · 2012-08-24T19:06:00

Solution 2

use dataset for fetch value(nameofCity,km, etc...) and then use fill combobox like that:

cmb_city.Items.Add(dataset.Tables[0].Rows[i]["column_name"]);

:)happy to help

--TK--

Posted 24-Aug-12 19:06pm

Member 9120792

Sreegth V · Answer 4 · 2012-08-25T03:08:00

Use a single function for binding both drop down lists.

C#

if (!IsPostBack)
{
         FillDropDownList();
} 
 
 private void FillDropDownList()
    {
        DataSet ds = new DataSet();
        SqlDataAdapter myda = new SqlDataAdapter("select city from tablename ",con);
        myda.Fill(ds);
        drop_city.DataSource = ds;
        drop_city.DataValueField = "city";
        drop_city.DataBind();
        drop_city1.DataSource = ds;
        drop_city1.DataValueField = "city";
        drop_city1.DataBind();
    }

NandaKumer · Answer 5 · 2012-08-25T06:06:00

Solution 5

check this link
http://www.ezineasp.net/post/ASP-Net-DropDownList-SQL-Datasource-Databinding.aspx[^]
--NDK

Posted 25-Aug-12 6:06am

NandaKumer