public void yearRank()
{
try
{
DataSet Ds = new DataSet();
Ds = Dm.Ranking1Year();
int Rowcount = Ds.Tables[0].Rows.Count;
if (Rowcount == 1)
{
yearrank1image = Ds.Tables[0].Rows[0].ItemArray[1].ToString();
rank1yearId.Text = Ds.Tables[0].Rows[0].ItemArray[1].ToString();
rank1yearName.Text = Ds.Tables[0].Rows[0].ItemArray[2].ToString();
rank1yearcount.Text = Ds.Tables[0].Rows[0].ItemArray[0].ToString();
yearrank2image = "";
rank2yearId.Text = "";
rank2yearName.Text = "";
rank2yearcount.Text = "";
yearrank3image = "";
rank3yearId.Text = "";
rank3yearName.Text = "";
rank3yearcount.Text = "";
}
else if (Rowcount == 2)
{
yearrank1image = Ds.Tables[0].Rows[0].ItemArray[1].ToString();
rank1yearId.Text = Ds.Tables[0].Rows[0].ItemArray[1].ToString();
rank1yearName.Text = Ds.Tables[0].Rows[0].ItemArray[2].ToString();
rank1yearcount.Text = Ds.Tables[0].Rows[0].ItemArray[0].ToString();
yearrank2image = Ds.Tables[0].Rows[1].ItemArray[1].ToString();
rank2yearId.Text = Ds.Tables[0].Rows[1].ItemArray[1].ToString();
rank2yearName.Text = Ds.Tables[0].Rows[1].ItemArray[2].ToString();
rank2yearcount.Text = Ds.Tables[0].Rows[1].ItemArray[0].ToString();
yearrank3image = "";
rank3yearId.Text = "";
rank3yearName.Text = "";
rank3yearcount.Text = "";
}
else if (Rowcount == 3)
{
yearrank1image = Ds.Tables[0].Rows[0].ItemArray[1].ToString();
rank1yearId.Text = Ds.Tables[0].Rows[0].ItemArray[1].ToString();
rank1yearName.Text = Ds.Tables[0].Rows[0].ItemArray[2].ToString();
rank1yearcount.Text = Ds.Tables[0].Rows[0].ItemArray[0].ToString();
yearrank2image = Ds.Tables[0].Rows[1].ItemArray[1].ToString();
rank2yearId.Text = Ds.Tables[0].Rows[1].ItemArray[1].ToString();
rank2yearName.Text = Ds.Tables[0].Rows[1].ItemArray[2].ToString();
rank2yearcount.Text = Ds.Tables[0].Rows[1].ItemArray[0].ToString();
yearrank3image = Ds.Tables[0].Rows[2].ItemArray[1].ToString();
rank3yearId.Text = Ds.Tables[0].Rows[2].ItemArray[1].ToString();
rank3yearName.Text = Ds.Tables[0].Rows[2].ItemArray[2].ToString();
rank3yearcount.Text = Ds.Tables[0].Rows[2].ItemArray[0].ToString();
}
else
{
yearrank1image = "";
rank1yearId.Text = "";
rank1yearName.Text = "";
rank1yearcount.Text = "";
yearrank2image = "";
rank2yearId.Text = "";
rank2yearName.Text = "";
rank2yearcount.Text = "";
yearrank3image = "";
rank3yearId.Text = "";
rank3yearName.Text = "";
rank3yearcount.Text = "";
}
}
catch (Exception e1)
{
}
}
