如果用sql查询出datatable得话可以这样写string status = dt.Rows[0]["CardState"].ToString();
如果是linq呢?该怎么写?
BLL层
Array dt = myCard.GetCards(CreditCardID, CardPass);//根据参数执行查询方法 把面值 状态 得值给dt
DAL层
public Array GetCards(string CreditCardID, string CardPassword)
{
DALDataContext ocDC = new DALDataContext(ConfigurationManager.ConnectionStrings["OfficeChannelConnectionString_Web"].ConnectionString);
var aaa = (from cc in ocDC.CreditCard
where cc.CreditCardID == CreditCardID && cc.CardPassword == CardPassword
select cc).ToArray();
return aaa;
}我想在BLL层把dt中得元素取出来像string status = dt.Rows[0]["CardState"].ToString();
这样?该怎么写呢?
如果是linq呢?该怎么写?
BLL层
Array dt = myCard.GetCards(CreditCardID, CardPass);//根据参数执行查询方法 把面值 状态 得值给dt
DAL层
public Array GetCards(string CreditCardID, string CardPassword)
{
DALDataContext ocDC = new DALDataContext(ConfigurationManager.ConnectionStrings["OfficeChannelConnectionString_Web"].ConnectionString);
var aaa = (from cc in ocDC.CreditCard
where cc.CreditCardID == CreditCardID && cc.CardPassword == CardPassword
select cc).ToArray();
return aaa;
}我想在BLL层把dt中得元素取出来像string status = dt.Rows[0]["CardState"].ToString();
这样?该怎么写呢?
{
DALDataContext ocDC = new DALDataContext(ConfigurationManager.ConnectionStrings["OfficeChannelConnectionString_Web"].ConnectionString);
var aaa = (from cc in ocDC.CreditCard
where cc.CreditCardID == CreditCardID && cc.CardPassword == CardPassword
select cc).ToArray();
return aaa;
}
.ToArray()就是转换成数组,CreditCard[].CreditCard[] cards = GetCards("...","...");
string status = cards[0].CardState.ToString();
这样?该怎么写呢?
---
Array dt = myCard.GetCards(CreditCardID, CardPass);//根据参数执行查询方法 把面值 状态 得值给dt
string status=dt[i].CardState;