data can't be retrieved from drop down connected to database

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

I am using the following coding to fill a drop down list.The values are imported from a table in sql server.There's no error in the code but the data isn't retrieved. What is the problem? Thanks in advance.

C++

SqlDataAdapter da;
SqlConnection con;
SqlCommand com;

string connect = ConfigurationSettings.AppSettings["connstring"];
con = new SqlConnection(connect);
con.Open();


com = new SqlCommand("select PostCode from PostCode", con);
da = new SqlDataAdapter(com);
DataTable dt = new DataTable();
da.Fill(dt);
PostCode.DataSource = dt;
PostCode.DataTextField = "PostCode";
PostCode.DataBind();
con.Close();

Posted 22-Aug-12 23:27pm

Smrng

Add a Solution

Comments

Smrng 23-Aug-12 6:34am

when i used
if (!IsPostBack)
{
//above syntax
}

it worked fine but not with all fields.some are not displayed

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

Sarrrva · Answer 1 · 2012-08-22T23:47:00

Hi Smrng,

try to use like this!!

VB

ddl.datasource = dt;
PostCode.DataTextField = "PostCode";

PostCode.DataValueField = "PostCode";

 PostCode.DataBind();


otherwise use this


 string qry1 = "select RoutNo from Tbl_Bus_RoutDetails";
        da = new SqlDataAdapter(qry1, con);

        da.Fill(ds, "Tbl_Bus_RoutDetails");
        dt = ds.Tables["Tbl_Bus_RoutDetails"];

        DropDownList1.Items.Clear();
        foreach (DataRow Row in dt.Rows)
        {
            ListItem item1 = new ListItem();
            item1.Value = Row[0].ToString();
            DropDownList1.Items.Add(item1.Value);
        }
        DropDownList1.Items.Insert(0, new ListItem("Select", "Default value"));
        da.Dispose();

regards
sarva

RAKESH CHAUBEY · Answer 2 · 2012-08-22T23:57:00

SqlDataAdapter da;
SqlConnection con;
SqlCommand com;

string connect = ConfigurationSettings.AppSettings["connstring"];
con = new SqlConnection(connect);
con.Open();

com = new SqlCommand("select PostCode from PostCode", con);
da = new SqlDataAdapter(com);
DataTable dt = new DataTable();
da.Fill(dt);
PostCode.DataSource = dt;
PostCode.DataTextField = "PostCode";
postcode.DatavalueField="Provide value"
PostCode.DataBind();
con.Close();

Mits Machhi · Answer 3 · 2012-08-22T23:58:00

Try This:

 private void FillDropDownList1()
    {
        con.open();
        DataSet ds = new DataSet();
        SqlDataAdapter myda = new SqlDataAdapter("select PostCode from PostCode", connection Object);
        myda.Fill(ds);
        Drop_Postcode.DataSource = ds;
        Drop_Postcode.DataValueField = "Postcode";
        Drop_Postcode.DataBind();

    }

Call this function In Page Load Event....

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            FillDropDownList1();
        }
        
    }


if any Query,Please Post It....

data can't be retrieved from drop down connected to database

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0