有一段 DataSet的
但是我想要 DataReader的 public DataTable GetLatestPic()
{
conn.Open();
Access = "Select TOP 9 ImgUrlSml FROM Product_Info order by ID desc";
Adcmd = new OleDbDataAdapter(sql, conn);
DataSet dt = new DataSet();
Adcmd.Fill(dt, "LatestPic");
conn.Close();
return dt.Tables("LatestPic");
}
public string no1 = showmenu.GetLatestPic.Rows(0)("ImgUrlSml").ToString;
但是我想要 DataReader的 public DataTable GetLatestPic()
{
conn.Open();
Access = "Select TOP 9 ImgUrlSml FROM Product_Info order by ID desc";
Adcmd = new OleDbDataAdapter(sql, conn);
DataSet dt = new DataSet();
Adcmd.Fill(dt, "LatestPic");
conn.Close();
return dt.Tables("LatestPic");
}
public string no1 = showmenu.GetLatestPic.Rows(0)("ImgUrlSml").ToString;
{
conn.Open();
Access = "Select TOP 9 ImgUrlSml FROM Product_Info order by ID desc";
Adcmd = new OleDbCommand(sql, conn);
OleDBDataReader dr = new OleDBDataReader ();
conn.open();
dr = Adcmd.ExcuteDataReader(CommandBehavior.CloseConnection);
return dr;
}
public string[] strs;
while(GetLatestPic().Read())
{
dr = GetLatestPic().GetString(0);
}
dr.close()public string no1 = showmenu.GetLatestPic.Rows(0)("ImgUrlSml").ToString;
int i=0;
OleDBDataReader dr = GetLatestPic();
while(dr.Read())
{
strs[i] = dr.GetString(0);
i=i+1;
}
dr.close();
----
没有看清楚别人的问题,lz问的是如何读取数据库的内容而不是问读完后存储到哪
while(dr.read())
{
aa[i]=dr["字段"].ToString();
i++;
}