multiple value pass in sql select query

Question

3.00/5 (2 votes)

See more:

C#

how to pass cheakeedlistbox value in where clause in select query(sql2005)

Posted 7-Dec-11 21:15pm

Lakhan Aanjana

Add a Solution

Comments

[no name] 8-Dec-11 3:21am

please help me frieds...........i have three chkeakedlistbox and i want to show data which filter from these three chkeakedlistbox

what is procedure and how to write select query ....C#,sqlserver

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)

Programm3r · Accepted Answer · 2011-12-07T21:25:00

Solution 1

Hi,

Well a starting point would be, getting hold of the checked items:

CheckedListBox - Selected Item[^]

Secondly, StringBuilder is a great way of builing up the SQL string: StringBuilder Class and example[^]

Lastly, I would not pass the clear text string into the where clause, the application would become vulnerably to SQL injection, rather make use of named parameters.

Kind regards,

Posted 7-Dec-11 21:25pm

Programm3r

Comments

[no name] 8-Dec-11 3:30am

thanks .....sorry but can u describe what actually i have to do

my query............string sqlqry = "SELECT ITEMCODE, BROKTYPE,BROKRATE,TRANRATE,TranType,uptostdt,MARTYPE,MARRATE,PARTYTYPE FROM PITBROK where ITEMCODE='" + str3 + "' ";

SqlDataAdapter da = new SqlDataAdapter(sqlqry, con);
DataSet ds1 = new DataSet();
da.Fill(ds1, "PITBROK");

//if (ds1.Tables[0].Rows.Count > 0)
for (int i = 0; i < ds1.Tables[0].Rows.Count; i++)
{
//for (int j = 0; j < ds1.Tables[0].Columns.Count; j++)
//{
dataGridView1.ColumnCount = 9;
dataGridView1.Rows.Add();

dataGridView1[0, i].Value = ds1.Tables[0].Rows[i][0].ToString();
//dataGridView1[1, i].Value = ds1.Tables[0].Rows[i][1].ToString();
string b = ds1.Tables[0].Rows[i][1].ToString();

if (b == "O")
{

dataGridView1[1, i].Value = "Opening Sauda";
dataGridView1[1, i].Style.BackColor = Color.LightBlue;
}
else if (b == "P")
{

dataGridView1[1, i].Value = "Persentage Wise";
dataGridView1[1, i].Style.BackColor = Color.SteelBlue;
}
else if (b == "T")
{

dataGridView1[1, i].Value = "Transaction";
dataGridView1[1, i].Style.BackColor = Color.Tomato;
}
dataGridView1[2, i].Value = ds1.Tables[0].Rows[i][2].ToString();
dataGridView1[3, i].Value = ds1.Tables[0].Rows[i][3].ToString();
string l = ds1.Tables[0].Rows[i][4].ToString();

if (l == "O")
{

dataGridView1[4, i].Value = "Opening Sauda";
dataGridView1[4, i].Style.BackColor = Color.LightBlue;
}
else if (l == "P")
{

dataGridView1[4, i].Value = "Persentage Wise";
dataGridView1[4, i].Style.BackColor = Color.SteelBlue;
}
else if (l == "T")
{

dataGridView1[4, i].Value = "Transation";
}

dataGridView1[5, i].Value = ds1.Tables[0].Rows[i][5].ToString();
string m = ds1.Tables[0].Rows[i][6].ToString();
if (m == "Q")
{

dataGridView1[6, i].Value = "Qty Wise(perunit)";
}
else if (m == "V")
{

dataGridView1[6, i].Value = "Value Wise(in%)";
}
else if (m == "I")
{

dataGridView1[6, i].Value = "Import Rates";
}
else if (m == "C")
{
dataGridView1[6, i].Value = "Client Wise Margine";
}

dataGridView1[7, i].Value = ds1.Tables[0].Rows[i][7].ToString();
dataGridView1[8, i].Value = ds1.Tables[0].Rows[i][8].ToString();

}
// }

Abhinav S · Accepted Answer · 2011-12-07T21:26:00

Solution 2

You need to pass the value of the checkedlistbox to the query as a boolean.

FOr e.g. if your checkbox is checked, your where clause would be something like where myColumn = true.

Posted 7-Dec-11 21:26pm

Abhinav S

Comments

[no name] 8-Dec-11 7:36am

but i have no cheakbox its cheakedlistbox which have more than one value may 10..or 15..or 15 select at a time