Refresh dropdownlist data source in asp.net

Question

0.00/5 (No votes)

See more:

Hello guys,

I want to refresh dropdownlist data source in asp.net when data is changed in source table.

I am using popup window to add new entry in table and entry is submited success fully. but when I close the popup window data in dropdownlist remains same. New value doesnot displaying in drop down list.

and if I refresh page then data entered in previous textboxes is removed and I need to re enter all data.

Please help me...

Thanx in advance....

Posted 28-May-13 0:45am

jagdish123061

Add a Solution

Comments

RelicV 28-May-13 8:16am

It depends on your code actually. Are you using any Cache? Please provide the code..

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

Jignesh Khant · Answer 1 · 2013-05-28T00:49:00

try this:

protected void Page_Load(object sender, EventArgs e)
   {
        if (!IsPostBack)
       {
           string str = ConfigurationManager.ConnectionStrings["Class28ConnectionString"].ToString();
           SqlConnection con = new SqlConnection(str);
           string sql = "select * from t_c";
           SqlCommand cmd = new SqlCommand(sql, con);
           con.Open();

           SqlDataReader rdr = cmd.ExecuteReader();
           while (rdr.Read())
           {
               ListItem lst = new ListItem();
               lst.Text = rdr[1].ToString();
               lst.Value = rdr[0].ToString();
               DropDownList1.Items.Add(lst);
           }
           DropDownList1.DataSource = rdr;
           DropDownList1.Items.Insert(0, new ListItem("select", "0"));

       }
   }

sainadh.chintha · Answer 2 · 2013-05-28T01:40:00

Refresh the parent page from popup window, 
Then Bind the dropdownlist items on !is post back.

protected void Page_Load(object sender, EventArgs e)
    {
         if (!IsPostBack)
        {
SqlConnection con = new SqlConnection("Data Source=;Database=;User ID=;Password=!;Asynchronous Processing=true");
con.Open();
            SqlCommand cmd = new SqlCommand("select firstname from contacts", con);
            SqlDataAdapter dtAdapter = new SqlDataAdapter(cmd);
            DataTable dt= new DataTable();
            dtAdapter.Fill(dt);
            ddl1.DataSource = dt;
            ddl1.DataTextField = "firstName";
            ddl1.DataValueField = "firstName";
            ddl1.DataBind();
            ddl1.Items.Insert(0, new ListItem("select", "0"));
         }
    }

Refresh dropdownlist data source in asp.net

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0