如何传递多个值在SQLServer2005中的第

sucram:这气味像功课我但在任何情况下:codeprelang="SQL"stringsql=string.Format(spanclass="code-string""/spanspanclass="code-string"SELECT[column1],[column2],[column3]FROM[table1]WHERE[column1]={0}and[column2]={1}and[column3]={2}"/span,value1,value2,value3);/pre/code取代列名，表名和值varaibles需要。在这种情况下，做到以下几点:codeprelang="C#" StringBuildersb=spanclass="code-keyword"new/spanStringBuilder(spanclass="code-string""/spanspanclass="code-string"SELECTITEMCODE,BROKTYPE,BROKRATE,TRANRATE,TranType,uptostdt,MARTYPE,MARRATE,PARTYTYPEFROMPITBROK"/span); spanclass="code-keyword"if/span(cheakedlistbox1.SelectedItems.Count>spanclass="code-digit"0/span|cheakedlistbox1.SelectedItems.Count>spanclass="code-digit"0/span|cheakedlistbox1.SelectedItems.Count>spanclass="code-digit"0/span){spanclass="code-keyword"string/spanvalues=spanclass="code-keyword"string/span.Empty;sb.Append(spanclass="code-string""/spanspanclass="code-string"Where"/span); spanclass="code-keyword"foreach/span(ListItemlispanclass="code-keyword"in/spanCheckBoxList1.Items){spanclass="code-keyword"if/span(li.Selected)values+=li.Value+spanclass="code-string""/spanspanclass="code-string","/span }sb.Append(spanclass="code-keyword"string/span.Format(spanclass="code-string""/spanspanclass="code-string"PARTYNAMEin({0})AND"/span,values.Remove(values.Length-1,spanclass="code-digit"1/span));values=string.Emptyspanclass="code-keyword"foreach/span(ListItemlispanclass="code-keyword"in/spanCheckBoxList2.Items){spanclass="code-keyword"if/span(li.Selected)values+=li.Value+spanclass="code-string""/spanspanclass="code-string","/span }sb.Append(spanclass="code-keyword"string/span.Format(spanclass="code-string""/spanspanclass="code-string"EXCHANGETYPEin({0})AND"/span,values.Remove(values.Length-1,spanclass="code-digit"1/span));spanclass="code-keyword"foreach/span(ListItemlispanclass="code-keyword"in/spanCheckBoxList3.Items){spanclass="code-keyword"if/span(li.Selected)values+=li.Value+spanclass="code-string""/spanspanclass="code-string","/span }sb.Append(spanclass="code-keyword"string/span.Format(spanclass="code-string""/spanspanclass="code-string"NAMEin({0})AND"/span,values.Remove(values.Length-1,spanclass="code-digit"1/span)); spanclass="code-keyword"string/spansql=sb.ToString();spanclass="code-comment"///spanspanclass="code-comment"trimtrailingANDandwhitespaces/spansql=sql.Remove(sql.Length-5,spanclass="code-digit"5/span);  }  /pre/code
omid.nazifi

你应该写声明所有职位的if-elsecodeprelang="c#"spanclass="code-keyword"string/spansubquery=spanclass="code-string""/spanspanclass="code-string""/span;spanclass="code-keyword"if/span(chk1.spanclass="code-keyword"checked/span){subquery+=spanclass="code-string""/spanspanclass="code-string"chklib1items=true"/span;}spanclass="code-keyword"else/spansubquery+=spanclass="code-string""/spanspanclass="code-string"chklib1items=false"/span;... spanclass="code-keyword"string/spansql=spanclass="code-string""/spanspanclass="code-string"SELECTITEMCODE,BROKTYPE,BROKRATE,TRANRATE,TranType,uptostdt,MARTYPE,MARRATE,PARTYTYPEFROMPITBROKWhere"/span+subquery;/pre/code的
LAKHANP22:这里是我的问题的完整解决方案.....

（con.State == ConnectionState.Closed）
{
con.Open（）
NBSP }
NBSP StringBuilder的查询=新的StringBuilder（" SELECT ITEMCODE，BROKTYPE，BROKRATE，TRANRATE，TranType，uptostdt，MARTYPE，"从PITBROK MARRATE）
查询。 AppendFormat（"wherenbsp; NBSP"）
（I = 0;我LT checkedListBox1.CheckedItems.Count; I）
{
NBSP诠释coun = checkedListBox1.CheckedItems.Count
coun = coun - 1;
NBSP ;网上书店股市; 字符串值;
（checkedListBox1.CheckedItems的。计数> 0）
{
NBSP ; NBSP的DataRow行;
NBSP 行=（（DataRowView的）this.checkedListBox1.CheckedItems [I]）行; { BR} 值=（行[this.checkedListBox1 。的ValueMember]）的ToString（）
NBSP行= NULL;

query.AppendFormat（"PITBROK.AC_CODE ="{0}'"，val.ToString（））
NBSP
NBSP 如果（我LT; coun）
NBSP NBSP ; NBSP {
NBSP ; query.AppendFormat（""）
NBSP }


NBSP ;}


NBSP ; }
NBSP
如果（ checkedListBox3.CheckedItems.Count GT; 0）
{
query.Append（""）
}
NBSP为（int k = 0时，K LT; checkedListBox3.CheckedItems。计数; K）
NBSP {
NBSP coun1 checkedListBox3.CheckedItems.Count;
NBSP coun1 = coun1 - 1;
NBSP，query.AppendFormat（"PITBROK.ITEMCODE ="{0}'"，checkedListBox3.CheckedItems [K]）
NBSP 如果（K LT; coun1）
NBSP {
query.Append （"或"）
}
NBSP
}
query.Append（"和"Compcls.Gcomp_cd"compcode ="'"）;
NBSP
字符串SQL = query.ToString（）
NBSP

SqlDataAdapter的DA = SqlDataAdapter的（SQL，CON）
数据集DS1 =新的DataSet（）;
NBSP da.Fill（DS1）;