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) { } }