Wednesday, October 31, 2007

get the value from dataset

int j=0;
while(j
{
DateTimeFormatInfo dateTimeFormatInfo = new DateTimeFormatInfo();
//DateTimeFormatInfo dateTimeFormatInfo1 = new DateTimeFormatInfo();
string fromdate=dateTimeFormatInfo.GetAbbreviatedMonthName((Convert.ToDateTime(ds.Tables[0].Rows[j][0]).Month)).ToString();
string todate=dateTimeFormatInfo.GetAbbreviatedMonthName((Convert.ToDateTime(ds.Tables[0].Rows[j][1]).Month)).ToString();
string year=Convert.ToDateTime(ds.Tables[0].Rows[j][1].ToString()).Year.ToString();
string AppraisalPeriod=String.Concat(String.Concat (fromdate,todate),year);
string tempDistinctAppraisalRecord = AppraisalPeriod + "$" + ds.Tables[0].Rows[j][0].ToString() + "$" + ds.Tables[0].Rows[j][1].ToString();
distinctAppraisalRecord.Add(tempDistinctAppraisalRecord);
//Label3.Text=AppraisalPeriod;
appdroplist.Items.Add(AppraisalPeriod);
j++;
}
appdroplist.DataBind();

No comments: