have a problem in dropdownlist

Question

0.00/5 (No votes)

See more:

this code is running and showing the data in gridview.
but now if i have 2 or 3 values in combobox how to pick that??

C#

SqlConnection con;
con = new SqlConnection(connstring);
con.Open();

string a = DropDownList1.SelectedValue.ToString();
string str = "SELECT * FROM ['ISB VAS Nodes$'] WHERE HardDisks=" + a + "";
//city is the column name in table
SqlCommand cmd;
cmd = new SqlCommand(str, con);
SqlDataReader dr;
dr = cmd.ExecuteReader();
if (dr.Read())
{

   TextBox1.Text = dr.GetString(0);
    //if city is in 0 index of table
    GridView1.DataSource = dr;
    GridView1.DataBind();
}
else
{
    Response.Write("City does not exist");

}
dr.Close();
con.Close();

Posted 22-Apr-13 1:54am

fak_farrukh

Updated 22-Apr-13 1:57am

Karthik Harve

v2

Add a Solution

Comments

Karthik Harve 22-Apr-13 7:58am

[Edit] pre tags added.

Zafar Sultan 22-Apr-13 8:00am

Your question does not explain what you want to achieve? Can you be a little more clear?

Karthik Harve 22-Apr-13 8:00am

do you want to pass more then one value of the dropdownlist instead of only selected one ?

fak_farrukh 22-Apr-13 8:19am

in this i can only get hardDisks Column but if i want to select different value from combox it will not run because in query harddisk column se selected.
so how to get more column??

[no name] 22-Apr-13 11:35am

Do you want to show all column of table in gridview or single one ?

Aner Bautista 22-Apr-13 13:00pm

To tell you the truth, I don't get if you want to select more than one value from the dropdownlist or if you want to filter more columns in your query (obviously using other controls on your page).

Please help us, to help you, adding more details.

1 solution

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)

RelicV · Answer 1 · 2013-04-22T19:45:00

Hi Member 7909184334,

As per my understanding, you need to select multiple values in a combobox which are to be used in the search query.

If so, then you can get the combobox selected values in an array and set the query as follows:

C#

string str = "SELECT * FROM ['ISB VAS Nodes$'] WHERE HardDisks IN (" + a[0].toString() + ", " + a[1].toString() + ", " + a[2].toString() + ")";

The above part shows that there are only 3 selected options. We can make it dynamic as below:

First get all the selected options into an array, lets call it as aryOptions

C#

string params = string.Empty;

// Get the array items into a comma seperated string
for(int i = 0; i < aryOptions.Length; i++)
{  
     params = params + aryOptions[i] + ",";
}

// Remove the last comma
if(params.Length > 0)
{
   params = params.SubString(0, parmas.Length - 1); 
}

// pass the value with WHERE IN clause
string str = "SELECT * FROM ['ISB VAS Nodes$'] WHERE HardDisks IN (" + params  + ")";

Please try this let me know the result.

Thank you,
Vamsi