query database with selected variables in mysql

Question

0.00/5 (No votes)

See more:

i am trying to do a c# mysql

select * from table where variable =(selected tableColumn from dropdownlist)

like variable(text from text box does anyone know what the query should look like in my sql

Posted 10-Oct-12 23:00pm

mrDivan

Updated 10-Oct-12 23:54pm

Toniyo Jackson

v2

Add a Solution

3 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

fjdiewornncalwe · Answer 1 · 2012-10-11T04:20:00

Solution 3

C#

MySqlCommand cmd = new MySqlCommand("Select * from table where variable = '@selectedValue'");
cmd.Parameters.AddWithValue("@selectedValue", value);
...

Posted 11-Oct-12 4:20am

fjdiewornncalwe

Updated 11-Oct-12 4:29am

v2

Comments

mrDivan 11-Oct-12 10:59am

Hi Marcus

Thank you for your response
here is my code im trying to use the selected value from a dropdown list as a variable but that seems broken

protected void btnFilter_Click(object sender, EventArgs e)
{

string filterlist = ddFillist.SelectedItem.Value;
string filterText = " % " + txtFilter.Text + "%";
MySql.Data.MySqlClient.MySqlConnection myconfill = new MySqlConnection(GetConnectionString());
if (myconfill.State != ConnectionState.Open)
try
{
myconfill.Open();
}
catch (MySqlException ex)
{
throw (ex);
}

// where ?filterList like ?filterText
MySqlCommand sqlC = new MySqlCommand("select * from T_company where ?filterlist like ?filterText ", myconfill);
MySqlDataAdapter da = new MySqlDataAdapter(sqlC);

sqlC.Parameters.AddWithValue("?filterlist", filterlist);
sqlC.Parameters.AddWithValue("?filtertext",'%'+txtFilter.Text+'%');

DataSet ds = new DataSet();
da.Fill(ds);
gdvauthors.DataSource = ds;
gdvauthors.DataBind();
myconfill.Close();
}
if i change ? filterlist with company_name it works seems like im somehow not giving my parameter the right vale

fjdiewornncalwe 11-Oct-12 11:02am

Why the ?filterlist. The accepted way to use parameters is @filterlist.

Maciej Los 11-Oct-12 13:33pm

Good answer, my 5!

mrDivan 12-Oct-12 2:43am

Ho I changed the parameters back to@filterlist but it doesnt work but thanks for your help anyway

mrDivan · Answer 2 · 2012-10-16T20:53:00

Solution 4

turns out you cannot use column names as a parameter in mysql so I wrote I different select statement for each column chose from the dropdown list

Posted 16-Oct-12 20:53pm

mrDivan

Al Hizbul · Answer 3 · 2012-10-11T02:50:00

Solution 2

C#

select * from table where variable in (selected tableColumn from dropdownlist)

Posted 11-Oct-12 2:50am

Al Hizbul

query database with selected variables in mysql

3 solutions

Solution 3

Solution 4

Solution 2

Add your solution here

Preview 0

query database with selected variables in mysql

3 solutions

Solution 3

Solution 4

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us