预览时,老是在dbAdapter.Fill(dataset, TableName)这一行提示列名 'issueDate' 无效。搞了快一晚上,还是不得其解。高人指点一下,感激中!
我把相关源码复制在下:我在Web.Config文件中的配置如下:
<appSettings/>
<connectionStrings>
<add name="coon" connectionString="Server=(local)\SQLEXPRESS;database=News_All;Integrated Security=False;User ID=sa;Password=" /> </connectionStrings>BaseClass文件:
public System.Data.DataSet GetDataSet(string sQueryString,string TableName)
{
SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["coon"].ConnectionString );
con.Open();
SqlDataAdapter dbAdapter = new SqlDataAdapter(sQueryString, con);
DataSet dataset = new DataSet();
dbAdapter.Fill(dataset, TableName);
con.Close();
return dataset;
下面是cs文件中的:
BaseClass bc = new BaseClass();
protected void Page_Load(object sender, EventArgs e)
{
//即时新闻
dljs.DataSource = bc.GetDataSet("SELECT TOP 30 ID, Style, Title FROM tbNews where issueDate='" + DateTime.Today.ToString() + "'", "tbNews");
dljs.DataKeyField = "id";
dljs.DataBind();
//友情链接
DataList1.DataSource = bc.GetDataSet("SELECT TOP 5 * FROM tbLink order by addDate desc", "tbLink");
DataList1.DataKeyField = "id";
DataList1.DataBind();
}
我把相关源码复制在下:我在Web.Config文件中的配置如下:
<appSettings/>
<connectionStrings>
<add name="coon" connectionString="Server=(local)\SQLEXPRESS;database=News_All;Integrated Security=False;User ID=sa;Password=" /> </connectionStrings>BaseClass文件:
public System.Data.DataSet GetDataSet(string sQueryString,string TableName)
{
SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["coon"].ConnectionString );
con.Open();
SqlDataAdapter dbAdapter = new SqlDataAdapter(sQueryString, con);
DataSet dataset = new DataSet();
dbAdapter.Fill(dataset, TableName);
con.Close();
return dataset;
下面是cs文件中的:
BaseClass bc = new BaseClass();
protected void Page_Load(object sender, EventArgs e)
{
//即时新闻
dljs.DataSource = bc.GetDataSet("SELECT TOP 30 ID, Style, Title FROM tbNews where issueDate='" + DateTime.Today.ToString() + "'", "tbNews");
dljs.DataKeyField = "id";
dljs.DataBind();
//友情链接
DataList1.DataSource = bc.GetDataSet("SELECT TOP 5 * FROM tbLink order by addDate desc", "tbLink");
DataList1.DataKeyField = "id";
DataList1.DataBind();
}
解决方案 »
- 急!求名片天下(www.namex.cn)标志在线设计的实现思路!
- public static修改值无效
- ajax 里面使用RegisterClientScriptBlock 调用前台函数???
- 页面源文件里 乱码的问题
- Reporting service 轉換成excel問題
- 急!!求Gridview中取得cell的列的值的方法!
- 新闻的“相关新闻”问题,请高手指教。
- asp.net 2.0问题读取web_config的简单方法
- DataGrid中有一个CheckBox列,AutoPostBack=ture,事件处理程序怎么样写?参数是什么?
- 关于sql2000与vs2005自带数据库的问题,急的各位麻烦了
- 页面登录的问题
- Repeater 控制 LinkButton
取得当天的前30条记录:
"select30 ID, Style, Title from tbNews where datediff(Day,issueDate,getdate())=0"最好加个排序。
看看你的 DataList1 绑定列上的数据源字段是否名字与issueDate一样
出现问题这里
protected void Page_Load(object sender, EventArgs e)
{
//即时新闻
dljs.DataSource = bc.GetDataSet("SELECT TOP 30 ID, Style, Title FROM tbNews where issueDate='" + DateTime.Today.ToString() + "'", "tbNews");
dljs.DataKeyField = "id";
dljs.DataBind();
下面应该再声明 个dataset 来做数据源,不能用之前的dataset做数据源,否则会导致第一个的datalist数据源变成最新的数据源,所以找不到列名 //友情链接
DataList1.DataSource = bc.GetDataSet("SELECT TOP 5 * FROM tbLink order by addDate desc", "tbLink");
DataList1.DataKeyField = "id";
DataList1.DataBind();
}
public System.Data.DataSet GetDataSet(string sQueryString,string TableName)
{
SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["coon"].ConnectionString );
con.Open();
SqlDataAdapter dbAdapter = new SqlDataAdapter(sQueryString, con);
DataSet dataset = new DataSet();
dbAdapter.Fill(dataset, TableName);
con.Close();
return dataset;
}
一个负责、dljs.DataBind();
另外个负责DataList1.DataBind();