刚刚接触.net,提个问题,将数据库中的xh列的值插入到数组当中,应该怎样把数值从数组中读出来
string bj = "0";
ArrayList ad = new ArrayList();
SqlConnection con = this.SqlCon();
con.Open();
string sql = "select xh from db";
SqlCommand mycom = new SqlCommand(sql, con); try
{
//int i = mycom.ExecuteNonQuery();
SqlDataReader myreader = mycom.ExecuteReader();
while (myreader.Read())
{
bj = myreader[0].ToString().Trim();
ad.Add(bj);
} return ad;
}
catch
{
ad.Add(bj);
return ad;
}
finally
{
con.Close();
}
string bj = "0";
ArrayList ad = new ArrayList();
SqlConnection con = this.SqlCon();
con.Open();
string sql = "select xh from db";
SqlCommand mycom = new SqlCommand(sql, con); try
{
//int i = mycom.ExecuteNonQuery();
SqlDataReader myreader = mycom.ExecuteReader();
while (myreader.Read())
{
bj = myreader[0].ToString().Trim();
ad.Add(bj);
} return ad;
}
catch
{
ad.Add(bj);
return ad;
}
finally
{
con.Close();
}
{
string item = ad[i].ToString();
}
{
string itemstring = item.ToString();
}