public ArrayList GetPositionIDByOut(int startPoint, int endPoint) { ArrayList list = new ArrayList(); String v_sql = "select top " + startPoint + " PositionID from result_particular_t where PositionID not in(select top " + endPoint + " PositionID from result_particular_t) order by PositionID desc;"; SqlDataReader dr = ExecuteReader(v_sql); while (dr.Read()) { list.Add(dr["positionID"]); } dr.Close(); return list; }
string sqlstr = "select a,b,c from yourtable"; da = new SqlDataAdapter(sqlstr, conn); ds = new DataSet(); da.Fill(ds); string[,] dsArr = new string[ds.Tables[0].Rows.Count,3]; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { dsArr[i,0]= ds.Tables[0].Rows[i][0].ToString(); dsArr[i,1]= ds.Tables[0].Rows[i][1].ToString(); dsArr[i, 2] = ds.Tables[0].Rows[i][2].ToString(); }
{
ArrayList list = new ArrayList();
String v_sql = "select top " + startPoint + " PositionID from result_particular_t where PositionID not in(select top " + endPoint + " PositionID from result_particular_t) order by PositionID desc;";
SqlDataReader dr = ExecuteReader(v_sql);
while (dr.Read())
{
list.Add(dr["positionID"]);
}
dr.Close();
return list;
}
da = new SqlDataAdapter(sqlstr, conn);
ds = new DataSet();
da.Fill(ds);
string[,] dsArr = new string[ds.Tables[0].Rows.Count,3];
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
dsArr[i,0]= ds.Tables[0].Rows[i][0].ToString();
dsArr[i,1]= ds.Tables[0].Rows[i][1].ToString();
dsArr[i, 2] = ds.Tables[0].Rows[i][2].ToString();
}