how to pass multiple values in where clause in sql server 2005

This smells like homework to me.

But in any case:

string sql = string.Format("SELECT [column1],[column2],[column3]FROM [table1] WHERE [column1] ={0} and [column2] = {1} and [column3] = {2}",value1,value2,value3);

Substitute column names, table name and value varaibles as needed.

In that case do the following:

StringBuilder sb = new StringBuilder("SELECT ITEMCODE, BROKTYPE,BROKRATE,TRANRATE,TranType,uptostdt,MARTYPE,MARRATE,PARTYTYPE FROM PITBROK ");

if(cheakedlistbox1.SelectedItems.Count > 0 | cheakedlistbox1.SelectedItems.Count > 0 | cheakedlistbox1.SelectedItems.Count > 0)
{
    string values = string.Empty;
    sb.Append("Where ");

    foreach (ListItem li in CheckBoxList1.Items)
    {
        
        if (li.Selected)
           values += li.Value + ","

    }
    sb.Append(string.Format("PARTYNAME in ({0}) AND ", values.Remove(values.Length -1,1));
    values=string.Empty
    foreach (ListItem li in CheckBoxList2.Items)
    {
        if (li.Selected)
          values += li.Value + ","

    }
    sb.Append(string.Format("EXCHANGETYPE in ({0}) AND ", values.Remove(values.Length -1,1));
    foreach (ListItem li in CheckBoxList3.Items)
    {
        if (li.Selected)
           values += li.Value + ","


    }
    sb.Append(string.Format("NAME in({0}) AND ", values.Remove(values.Length -1,1));

    string sql = sb.ToString();
    //trim trailing AND and whitespaces
    sql = sql.Remove(sql.Length-5,5); 



}

here is complete solution of my problem.....

if (con.State == ConnectionState.Closed)
{
con.Open();
}
StringBuilder query = new StringBuilder("SELECT ITEMCODE, BROKTYPE,BROKRATE,TRANRATE,TranType,uptostdt,MARTYPE,MARRATE FROM PITBROK ");
query.AppendFormat("where ");
for (int i = 0; i < checkedListBox1.CheckedItems.Count; i++)
{
int coun = checkedListBox1.CheckedItems.Count;
coun = coun - 1;
string val;
if (checkedListBox1.CheckedItems.Count > 0)
{
DataRow row;
row = ((DataRowView)this.checkedListBox1.CheckedItems[i]).Row;
val = (row[this.checkedListBox1.ValueMember]).ToString();
row = null;

query.AppendFormat("PITBROK.AC_CODE='{0}' ", val.ToString());

if (i < coun)
{
query.AppendFormat(" or ");
}


}


}

if (checkedListBox3.CheckedItems.Count > 0)
{
query.Append("AND ");
}
for (int k = 0; k < checkedListBox3.CheckedItems.Count; k++)
{
int coun1 = checkedListBox3.CheckedItems.Count;
coun1 = coun1 - 1;
query.AppendFormat("PITBROK.ITEMCODE='{0}'", checkedListBox3.CheckedItems[k]);
if (k < coun1)
{
query.Append("or ");
}

}
query.Append("and compcode='" + Compcls.Gcomp_cd + "' ");

string sql = query.ToString();


SqlDataAdapter da = new SqlDataAdapter(sql, con);
DataSet ds1 = new DataSet();
da.Fill(ds1);