如何在StringBuilder表单cheackedlistbox中传递传递值成员 [英] how to pass pass value member in StringBuilder form cheackedlistbox

问题描述

这是我的cheakellistbox数据绑定的代码

here is my code for databinding of cheakellistbox

//***********************************************************************************
public void FillCheckedListBox1party()
        {
            try
            {
                if (con.State == ConnectionState.Closed)
                {
                    con.Open();
                }

                string commandString = "SELECT NAME ,AC_CODE FROM AccountM where compcode='" + Compcls.Gcomp_cd + "'";
               
                DataTable accTable = new DataTable();
                SqlCommand cmd = new SqlCommand(commandString, con);
                SqlDataAdapter adpObj = new SqlDataAdapter(cmd);
                accTable.TableName = "tbl";
                adpObj.Fill(accTable);
                con.Close();
                checkedListBox1.DataSource = accTable;
                checkedListBox1.ValueMember = "AC_CODE";
                checkedListBox1.DisplayMember ="NAME";
            }
            catch (Exception ex)
            {

                throw ex;
            }
            finally
            {
                con.Close();
            }

在这里弹弦琴

here for stringbulder

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;

query.AppendFormat("PITBROK.AC_CODE='{0}' ", checkedListBox1.CheckedItems[value]);

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

罢工时(query.AppendFormat("PITBROK.AC_CODE =''{0}''"，checkedListBox1.CheckedItems [value];)
我想通过所有CHeackeditem的AC_CODE ....
有什么伙伴可以帮助我.............

at strike(query.AppendFormat("PITBROK.AC_CODE=''{0}'' ",checkedListBox1.CheckedItems[value];)
i want to pass AC_CODE OF all CHeackeditem....
can any buddy Help me .............

推荐答案

尝试使用IN

Try using IN

where AC_CODE in(...add check box values...)

if(checkedListBox1 .CheckedItems.Count> 0)
{
DataRow行；
行=(((DataRowView)this.checkedListBox1.CheckedItems [i]).Row;
val =(row [this.checkedListBox1.ValueMember]).ToString();
row = null;

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

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());

这篇关于如何在StringBuilder表单cheackedlistbox中传递传递值成员的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！