Dnamic comboox value in a select Query

Question

0.00/5 (No votes)

See more:

Hi friends i need to bind the value in grid view as per the Combobox selected Event..The Problem which i got nw is the value is not retrieving from an database am getting the op as combobox value pls help me... The value should retrieve from an database...

Note: The Combo box value contain the database column Names
Here is my code

C#

string a = comboBox1.SelectedItem.ToString();
string a1 = comboBox2.SelectedItem.ToString();

groupBox3.Visible = true;
da = new SqlDataAdapter("select '" + a + "','" + a1 + "' from probablitystate1 ", cn.con);
dt = new DataTable();
da.Fill(dt);
dataGridView1.DataSource = dt;

Thnak You...
:-)

Posted 14-Jul-13 20:05pm

usha C

Updated 14-Jul-13 20:15pm

Renju Vinod

v4

Add a Solution

Comments

berrymaria 15-Jul-13 2:18am

Is the table source of the combox1 and combobox2 is probablitystate1 ?

usha C 15-Jul-13 2:22am

Yes ...the probablitystate1 is an table name and combox1 and combobox2 contains the field name in tat particular table

berrymaria 15-Jul-13 2:26am

Why there is single quote in your query?
Try to use this.
da = new SqlDataAdapter("select " + a + "," + a1 + " from probablitystate1 ", cn.con);

usha C 15-Jul-13 2:27am

Ya i done mistake thnk u got op nw chimcham thnks lot....

berrymaria 15-Jul-13 2:29am

:) great!

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)

Renju Vinod · Accepted Answer · 2013-07-14T20:24:00

Solution 1

Hi
Please remove the single quotes from the query and try.

C#

string a = comboBox1.SelectedItem.ToString();
 string a1 = comboBox2.SelectedItem.ToString();

 groupBox3.Visible = true;
 da = new SqlDataAdapter("select " + a + "," + a1 + " from probablitystate1", cn.con);
 dt = new DataTable();
 da.Fill(dt);
 dataGridView1.DataSource = dt;

Posted 14-Jul-13 20:24pm

Renju Vinod

Updated 14-Jul-13 20:27pm

v2

Comments

usha C 15-Jul-13 2:26am

Thank you ...Thnks lot

berrymaria · Accepted Answer · 2013-07-14T20:29:00

Solution 2

Remove single quotes in your query.

C#

da = new SqlDataAdapter("select " + a + "," + a1 + " from probablitystate1 ", cn.con);

Posted 14-Jul-13 20:29pm

berrymaria