为什么我循环遍历数据时取不到recevid, recevid = dr["receiverID"].ToString();这句好像没执行
Poucan.BLL.ReceiverAddress receivebll = new Poucan.BLL.ReceiverAddress();
Poucan.Model.CustomerShopping model2 = new Poucan.Model.CustomerShopping();
DataSet ds = new DataSet();
ds = receivebll.CustomerShopping(PageProduct.getCustomerName());
string recevid = "";
if (ds.Tables[0].Columns.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
recevid = dr["receiverID"].ToString();
}
}
model2.receiverID = recevid;CustomerShopping方法:
public DataSet CustomerShopping(string customer)
{
SqlParameter[] parameters = {
new SqlParameter("@customer", SqlDbType.VarChar,50),
};
parameters[0].Value = customer;
return DbHelperSQL.RunProcedure("prd_GetRecevierID", parameters, "ds");
}
sql语句:select * from tb_receiver where ordercode in(select top 1 ordercode from tb_order where customer=@customer order by created desc)
Poucan.BLL.ReceiverAddress receivebll = new Poucan.BLL.ReceiverAddress();
Poucan.Model.CustomerShopping model2 = new Poucan.Model.CustomerShopping();
DataSet ds = new DataSet();
ds = receivebll.CustomerShopping(PageProduct.getCustomerName());
string recevid = "";
if (ds.Tables[0].Columns.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
recevid = dr["receiverID"].ToString();
}
}
model2.receiverID = recevid;CustomerShopping方法:
public DataSet CustomerShopping(string customer)
{
SqlParameter[] parameters = {
new SqlParameter("@customer", SqlDbType.VarChar,50),
};
parameters[0].Value = customer;
return DbHelperSQL.RunProcedure("prd_GetRecevierID", parameters, "ds");
}
sql语句:select * from tb_receiver where ordercode in(select top 1 ordercode from tb_order where customer=@customer order by created desc)
foreach (DataRowView drv in ds.Tables[0].DefaultView)
{
recevid = drv["receiverID"].ToString();
}
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
recevid = dr["receiverID"].ToString();
}
}你的ds数据是几行? 怎么遍历ds重复赋值的呀
receivebll.CustomerShopping(PageProduct.getCustomerName()); 没有取到值,你说没问题你要调试肯定是没有数据的。
改
if (ds.Tables.Columns.Count > 0)
改成if (ds.Tables.Rows.Count > 0)
count是0,没数据. 当然不能recevid = dr["receiverID"].ToString();