Populating textbox with mysql data values from combobox selection

Question

0.00/5 (No votes)

See more:

Hi everyone.

I am trying to populate my text boxes with the values in my database so when a user selects a name of a teacher from the combobox, the text-boxes will populate with their contact details. This is the code I have so far. There are no errors however the textboxes are still blank when I select a value from combo box.

private void comboBox1_SelectionChanged(object sender, SelectionChangedEventArgs e)
      {
          MySqlConnection cs = new MySqlConnection(connectionSQL);
          cs.Open();

          DataSet ds = new DataSet();

          MySqlDataAdapter da = new MySqlDataAdapter("Select * from Teacher WHERE name='" + comboBox1.Text + "'", cs);

          MySqlCommandBuilder cmd = new MySqlCommandBuilder(da);

          da.Fill(ds);


          if (comboBox1.SelectedIndex > 0)
          {


              NameBox.Text = ds.Tables[0].Rows[0]["name"].ToString();
              AddressBox.Text = ds.Tables[0].Rows[0]["address"].ToString();

          }

Any help or advice would be greatly appreciated

UPDATED CODE:
private void comboBox1_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
MySqlConnection cs = new MySqlConnection(connectionSQL);

string query = "SELECT name FROM Teacher WHERE name= 'Liz Murphy'";
MySqlDataAdapter adapter = new MySqlDataAdapter(query, cs);
DataSet DS = new DataSet();

adapter.Fill(DS);

NameBox.Text = DS.Tables[0].Rows[0].ToString();

Posted 3-Apr-13 5:55am

Member 9611735

Updated 3-Apr-13 9:46am

v4

Add a Solution

Comments

Richard C Bishop 3-Apr-13 12:01pm

I think you want to use "comboBox1.SelectedValue" when you query the database.

Member 9611735 3-Apr-13 12:05pm

Thank you. I changed my code but the textboxes are still not being populated

Richard C Bishop 3-Apr-13 12:07pm

Is your dataset getting filled with data?

Member 9611735 3-Apr-13 12:15pm

I just checked and it's not. Do you think there is something wrong with my query?

Richard C Bishop 3-Apr-13 12:23pm

Check my solution below and see if you can get that to work.

Member 9611735 3-Apr-13 12:51pm

Your solution throws up the following error Error 1 'MySql.Data.MySqlClient.MySqlCommand' is a 'type' but is used like a 'variable'. I've tried changing it to different things but dataset is still empty

Richard C Bishop 3-Apr-13 13:41pm

Look at my update to the solution please.

Member 9611735 3-Apr-13 14:20pm

There is still nothing in dataset

Richard C Bishop 3-Apr-13 14:22pm

Maybe your query is the problem. Is "Teacher" the name of the table? Can you post your connection string please?

Member 9611735 3-Apr-13 14:26pm

Yes teacher is the name of the table. My connection string is
string connectionSQL= "server=sql.byethost27.org;user id=xxxxxxx;password=xxxxxxxxxx;database=xxxxxxxxxx";

Richard C Bishop 3-Apr-13 14:29pm

Odd, I hate to ask this, but is there data in the table? What type of database is it?

Member 9611735 3-Apr-13 14:33pm

Yes there is two records in the database. It's mySQL database. I am getting combobox values from the same table in the database and it's working fine

Richard C Bishop 3-Apr-13 14:41pm

I found another sample you can try. See my solution.

Member 9611735 3-Apr-13 14:51pm

I added in NameBox.Text = DS.Tables[0].Rows[0].ToString(); after your newly posted solution and this error occurred
There is no row at position 0.

Richard C Bishop 3-Apr-13 15:02pm

It has to be your query not returning anything. Is "name" the exact column name in "Teacher"? When you debug, what is the value of "comboBox1.SelectedValue"?

Member 9611735 3-Apr-13 15:23pm

yes name is the column name. Do i need to bind my textbox with the table in xaml or anything? Am i using the correct code to add the result into textbox?

Richard C Bishop 3-Apr-13 15:26pm

No binding needed. I think it is correct as long as the dataset is getting filled.

Member 9611735 3-Apr-13 15:38pm

I tried specifying the query by adding a where clause to query and specifying a name. Now when I debug the textbox is populated with System.Data.DataRow

Richard C Bishop 3-Apr-13 15:41pm

Can you use the "Improve question" widget to add all the code you are using now please? Leave what you have already, just add what you have now to the bottom of it.

Member 9611735 3-Apr-13 16:44pm

There is definitely something wrong with the query. I played about with the code and by specifying the name of teacher all the textboxes were populated with the correct data from database. Any suggestions?? Thank you so much for your help thus far.

2 solutions

Solution 1

Try something like this:

MySqlConnection cs = new MySqlConnection(connectionSQL);

string query = "SELECT * FROM Teacher WHERE name= '" + comboBox1.SelectedValue + "'";
adapter = new MySqlDataAdapter(query, cs);
DataSet DS = new DataSet();

adapter.Fill(DS);

You will have to alter how you get your textboxes filled after the query.

Posted 3-Apr-13 6:23am

Richard C Bishop

Updated 3-Apr-13 8:40am

v5

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)

Member 9611735 · Accepted Answer · 2013-04-03T10:58:00

Solution 2

PROBLEM SOLVED!!! I hadn't assigned combobox selectedValuePath when I was populating combo box. Many thanks to richcb for helping me

Posted 3-Apr-13 10:58am

Member 9611735

Comments

Richard C Bishop 3-Apr-13 17:29pm

You are welcome.