int myreadercount=0;
SqlCommand Acmd=new SqlCommand("select * from ata where ID='"+id+"' order by id desc",AConnStr);
SqlDataReader myreader=null;
myreader=Acmd.ExecuteReader();
while(myreader.Read())
{
myreadercount+=1;
}
string[,] array=new string[myreadercount,2];
while(myreader.Read())
{
array[i,0]=myreader["id"].ToString();
array[i,1]=myreader["title"].ToString();
i++;
}
myreader.Close();这里出现问题,array数组赋值总是不成功,一直为空,请问这是为何啊?
SqlCommand Acmd=new SqlCommand("select * from ata where ID='"+id+"' order by id desc",AConnStr);
SqlDataReader myreader=null;
myreader=Acmd.ExecuteReader();
while(myreader.Read())
{
myreadercount+=1;
}
string[,] array=new string[myreadercount,2];
while(myreader.Read())
{
array[i,0]=myreader["id"].ToString();
array[i,1]=myreader["title"].ToString();
i++;
}
myreader.Close();这里出现问题,array数组赋值总是不成功,一直为空,请问这是为何啊?
int myreadercount=0;
DataSet ds = new DataSet();
SqlDataAdaper da = new SqlDataAdapter("select * from ata where ID= '"+id+" ' order by id desc",AConnStr);
da.Fill(ds);
if(ds.Tables[0].Rows.Count > 0)
{
string[,] array=new string[ds.Tables[0].Rows.Count,2];
for(int i=0; i<ds.Tables[0].Rows.Count;i++)
{
array[i,0] = ds.Tables[0].Rows[i]["id"].ToString();
array[i,1] = ds.Tables[0].Rows[i]["title"].ToString();}
}
}
int myreadercount=0;
DataSet ds = new DataSet();
SqlDataAdaper da = new SqlDataAdapter("select * from ata where ID= '"+id+" ' order by id desc",AConnStr);
da.Fill(ds);
if(ds.Tables[0].Rows.Count > 0)
{
string[,] array=new string[ds.Tables[0].Rows.Count,2];
for(int i=0; i <ds.Tables[0].Rows.Count;i++)
{
array[i,0] = ds.Tables[0].Rows[i]["id"].ToString();
array[i,1] = ds.Tables[0].Rows[i]["title"].ToString();}
}
}
private void main(object sender, System.EventArgs e)
{
string Afile=System.Configuration.ConfigurationSettings.AppSettings["Conn"];
SqlConnection AConnStr=new SqlConnection(Afile); AConnStr.Open();
SqlDataAdapter sda=new SqlDataAdapter("select * from class_data where parentID=0 order by id desc",AConnStr);
SqlCommandBuilder CB=new SqlCommandBuilder(sda);
DataSet ds=new DataSet();
sda.Fill(ds,"info"); for(int i=0;i<ds.Tables["info"].Rows.Count;i++)
{
/*
这里是很多程序
*/
select(int.Parse(ds.Tables["info"].Rows[i]["id"].ToString()),AConnStr);
}
AConnStr.Close();
}
public void select(int id,SqlConnection AConnStr)
{
int myreadercount=0;
int i=0;//THE INCREASING NUMBER
SqlCommand Acmd=new SqlCommand("select * from class_data where parentID='"+id+"' order by id desc",AConnStr);
SqlDataReader myreader=null;
myreader=Acmd.ExecuteReader();
while(myreader.Read())
{
myreadercount+=1;
}
string[,] array=new string[myreadercount,2];
while(myreader.Read())
{
array[i,0]=myreader["id"].ToString();
array[i,1]=myreader["title"].ToString();
i++;
}
myreader.Close();//CLOSE THE DATA FLOW
if(myreadercount!=0)
{
Width+=12;
for(int m=0;m<myreadercount;m++)
{
/*
这里是很多程序
*/
}
Width-=12;
}
}