求助各位帮我看看~！

[tom143]

public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

}

protected void TBday_TextChanged(object sender, EventArgs e)
{
string dt = this.TBday.Text;
}
protected void Btday_Click(object sender, EventArgs e)
{

SqlConnection con = new SqlConnection("Server=.;database=Tjutgl;uid=sa;pwd=;");
con.Open();
SqlCommand cmd = new SqlCommand("select * from StData ", con);
SqlDataReader dd;
dd = cmd.ExecuteReader();



DateTime dt1 = DateTime.Parse?????;
DateTime dt2 = DateTime.Parse(TBday.Text.ToString());
TimeSpan ddd = dt2 - dt1;

int Week = int.Parse(ddd.TotalDays.ToString()) / 7;
int WeekNo = Week + 1;
this.ShowWeekNo.Text="您输入的日期为本学期第" + WeekNo.ToString("") + "周";

}
}


请各位高手指点下，红色部分我该怎么写才能使dt1的值为数据库中取出的值？

[NqIceCoffee]

SqlConnection con = new SqlConnection("Server=.;database=Tjutgl;uid=sa;pwd=;");
con.Open();
SqlCommand cmd = new SqlCommand("select * from StData ", con);
SqlDataReader dd;
dd = cmd.ExecuteReader();


dd.Read();
DateTime dt1 = dd.GetDateTime("日期的字段名");
DateTime dt2 = DateTime.Parse(TBday.Text.ToString());
TimeSpan ddd = dt2 - dt1;

int Week = int.Parse(ddd.TotalDays.ToString()) / 7;
int WeekNo = Week + 1;
this.ShowWeekNo.Text="您输入的日期为本学期第" + WeekNo.ToString("") + "周";

[NqIceCoffee]

DateTime dt1 = dd.GetDateTime("日期的字段名");

==>

DateTime dt1 = dd.GetDateTime(i); //i为日期字段的序号

[tom143]

我试过了，老是报错。说什么超出检索范围……

数据库编写好像不对……

我就库里插入了一个datatime的值 2008-4-19

[tom143]

解决了，谢谢~！