作者linxintw (Louis)
看板Programming
标题[请益] 关於C#用Calender做查询
时间Fri Aug 6 09:44:54 2010
各位好
小弟现在的作业环境为C#的webform
做一个查询的功能，利用Calender所select的值与资料库里的Date资料做比对~如果查不
到或是空值~就会显示"查无资料"
现在写了一小段~但是出来的结果是
{
例外详细资讯: System.NullReferenceException: 并未将物件参考设定为物件的执行个
体
原始程式错误:
行 51: GridView1.DataBind();
行 52: }
行 53: GridView1.HeaderRow.Cells[1].Text = "消息编号";
行 54: GridView1.HeaderRow.Cells[2].Text = "消息名称";
行 55: GridView1.HeaderRow.Cells[3].Text = "消息日期";
}
我写的语法如下
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
string connstr =
ConfigurationManager.ConnectionStrings["Erlin"].ConnectionString;
string sqlstr = "Select NewsID,NewsName, NewsDate From News where
NewsDate = '" + Calendar1.SelectedDate.Date.ToShortDateString() + "' order by
NewsID DESC" ;
OleDbDataAdapter adpt = new OleDbDataAdapter(sqlstr, connstr);
DataSet ds = new DataSet();
adpt.Fill(ds);
if (Calendar1.SelectedDate.Date.ToShortDateString() != "NewsDate")
{
Label2.Text = "查无消息资料";
}
else
{
GridView1.DataSource = ds;
GridView1.DataBind();
}
GridView1.HeaderRow.Cells[1].Text = "消息编号";
GridView1.HeaderRow.Cells[2].Text = "消息名称";
GridView1.HeaderRow.Cells[3].Text = "消息日期";
}
有劳各位了...感谢
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 61.230.221.176
1F：→ flyskycat:没人回，我来回一下好了，你可到C#板 114.36.71.95 08/14 23:08