Retrieving data from database and storing in combobox

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

, +

hi,
I have a text box and combobox in aspx page, I have a database with two columns say "Parent" And "Child",First the combobox should be empty when I enter the value in textbox it should load to database ,and the same value sholud be displayed in aspx combobox.this has continue as i go on entering the textbox value it has to come to combobox. And when i select the value from combobox and press submit it should display on the database "Child" column.
Can any one help me please........................

Posted 13-Dec-11 23:32pm

manjunath NIE

Add a Solution

Comments

Shobana16 14-Dec-11 5:43am

After you enter the values in textbox insert it into database table and reload the page.Then in page load get the values from that table,fill it in one ds,assign it to a combobox..Do this repeatedly, when enter text in textbox..

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)

AHSAN111 · Answer 1 · 2011-12-13T23:51:00

Solution 1

try using the OnTextChange event of the Textbox control to insert data in the database and populate the combobox by setting the SelectedValue property of the combobox.

Posted 13-Dec-11 23:51pm

AHSAN111

arunrv · Answer 2 · 2011-12-14T01:43:00

1st you set the autopostback properity of a textbox to true.
ten u write the code for insert as well as fetching operation in TextChanged event

C#

protected void TextBox1_TextChanged(object sender, EventArgs e)
    {
      //here when you leave the mouse cursor out of textbox this event is triggred 
        //now you can insert the data into database using the insert statement 
     //after inserting write the select query to fetch the data now here by doing this you will get the updated database value then you can bind it to drop down

 DropDownList1.DataSource=//here you will fetch the data from data base and put in some DataTabel or DataSet then 

DropDownList1.DataTextField="Parent";

DropDownList1.DataBind();




    }

hope this will help you