protected void Page_Load(object sender, EventArgs e)
{
sqlcon = new SqlConnection(strCon);
string sqlstr = "select top 1 * from tb_Member";
SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon);
DataSet myds = new DataSet();
sqlcon.Open();
myda.Fill(myds,"tb_Member");
DataList1.DataSource = myds;
DataList1.DataBind();
DataRowView mydrv = myds.Tables["tb_Member"].DefaultView[0];
for(int i=0;i<=DataList1.Items.Count-1;i++)
{
Label lab=(Label)DataList1.Items[i].FindControl("Lable1");
DateTime dt=Convert.ToDateTime(mydrv["date"]);
lab.Text=dt.ToLongDateString();
}
sqlcon.Close()
}