dtDestStore = (DataTable) data.Tables[FGetStoreByUserData.mTableGetStoreByUser];
if(_curState== BillOpState.New)
{
DataRow dr =dtDestStore.NewRow();
dr[0] = "0";
[align=left][align=left]dr[1] = "请选择";
dtDestStore.Rows[/align].InsertAt[/align](dr,0);
}
TDefBuyerWS.TDefBuyerPWS buyer = new TDefBuyerWS.TDefBuyerPWS();
buyer.Url = XmlAppConfig.ServerURL + WSFileName.TDefBuyerWSName;
string num = buyer.getBuyerid(XmlAppConfig.StoreId);
string num ="2";
if(num.Equals("2"))
{
DataSet dataa = OnLineGlobals.MyUserStore.GetDataByConConSel.Both,ConSel.Yes,ConSel.Both,ConSel.Yes,ConSel.Both,ConSel.Yes,ConSel.Yes);
if(!(dataa==null || dataa.Tables[FGetStoreByUserData.mTableGetStoreByUser]==null))
{ comboBox1.DataSource = dataa.Tables[FGetStoreByUserData.mTableGetStoreByUser].DefaultView;
comboBox1.DisplayMember = FGetStoreByUserData.m_StoreName;
comboBox1.ValueMember = FGetStoreByUserData.m_Store;
int num2 = comboBox1.Items.Count;
}
foreach (object o in comboBox1.Items)
{
if(!cbDestStore.Items.Contains(o.ToString()))
{
cbDestStore.Items.Add(o.ToString());
}
}
num3 = cbDestStore.Items.Count;
}
cbDestStore.DataSource = dtDestStore.DefaultView;
cbDestStore.DisplayMember = FGetStoreByUserData.m_StoreName;
cbDestStore.ValueMember = FGetStoreByUserData.m_Store;
} 先查出来值。绑定到一个combox中,又从另外一个库中双查出来了一些值,也绑到这个combox中,但要去掉重复的。所以我就写foreach来判断,可值行完了以后没有一点反应。cbDestStore这个combox是我最后要放值的。我本来放在string num ="2";
这个前面,可没有想到说datasource以后,就不能在填加了,所以我就放在了后面。可后面又没有一点反应。特发些贴,寻求大哥大姐们帮忙,小弟不胜感激!不能用sql语句去重复。只能在程序里去,同时我用的开发工具是2003
if(_curState== BillOpState.New)
{
DataRow dr =dtDestStore.NewRow();
dr[0] = "0";
[align=left][align=left]dr[1] = "请选择";
dtDestStore.Rows[/align].InsertAt[/align](dr,0);
}
TDefBuyerWS.TDefBuyerPWS buyer = new TDefBuyerWS.TDefBuyerPWS();
buyer.Url = XmlAppConfig.ServerURL + WSFileName.TDefBuyerWSName;
string num = buyer.getBuyerid(XmlAppConfig.StoreId);
string num ="2";
if(num.Equals("2"))
{
DataSet dataa = OnLineGlobals.MyUserStore.GetDataByConConSel.Both,ConSel.Yes,ConSel.Both,ConSel.Yes,ConSel.Both,ConSel.Yes,ConSel.Yes);
if(!(dataa==null || dataa.Tables[FGetStoreByUserData.mTableGetStoreByUser]==null))
{ comboBox1.DataSource = dataa.Tables[FGetStoreByUserData.mTableGetStoreByUser].DefaultView;
comboBox1.DisplayMember = FGetStoreByUserData.m_StoreName;
comboBox1.ValueMember = FGetStoreByUserData.m_Store;
int num2 = comboBox1.Items.Count;
}
foreach (object o in comboBox1.Items)
{
if(!cbDestStore.Items.Contains(o.ToString()))
{
cbDestStore.Items.Add(o.ToString());
}
}
num3 = cbDestStore.Items.Count;
}
cbDestStore.DataSource = dtDestStore.DefaultView;
cbDestStore.DisplayMember = FGetStoreByUserData.m_StoreName;
cbDestStore.ValueMember = FGetStoreByUserData.m_Store;
} 先查出来值。绑定到一个combox中,又从另外一个库中双查出来了一些值,也绑到这个combox中,但要去掉重复的。所以我就写foreach来判断,可值行完了以后没有一点反应。cbDestStore这个combox是我最后要放值的。我本来放在string num ="2";
这个前面,可没有想到说datasource以后,就不能在填加了,所以我就放在了后面。可后面又没有一点反应。特发些贴,寻求大哥大姐们帮忙,小弟不胜感激!不能用sql语句去重复。只能在程序里去,同时我用的开发工具是2003
第一次查询出结果,先不要急着去绑定Combobox,待从其他表中查询出其他数据,把两个数据集合并到一个空的DataTable中去掉重复值后再绑定。