string Sql="SELECT Top 6 blog_Content.[Title], blog_Content.[ID],blog_Config.[UserName],blog_Content.[DateAdded] FROM blog_Links INNER JOIN blog_Content ON blog_Links.[PostID] = blog_Content.[ID] INNER JOIN blog_Config ON blog_Config.[BlogID] = blog_Content.[BlogID] WHERE blog_Links.[CategoryID] = 12 ORDER BY blog_Content.[DateAdded] DESC";SqlConnection myConnection = new SqlConnection(Conn);
myConnection.Open();
SqlDataAdapter myDataAdapter = new SqlDataAdapter(Sql,myConnection);
DataSet myDataSet = new DataSet();
myDataAdapter.Fill(myDataSet);
CategoryRepeater.DataSource = myDataSet;
CategoryRepeater.DataBind();
myConnection.Close();Sql语句放到表里运行觉得出结果
可是放到C#中说对象未引用
你看看
myConnection.Open();
SqlDataAdapter myDataAdapter = new SqlDataAdapter(Sql,myConnection);
DataSet myDataSet = new DataSet();
myDataAdapter.Fill(myDataSet);
CategoryRepeater.DataSource = myDataSet;
CategoryRepeater.DataBind();
myConnection.Close();Sql语句放到表里运行觉得出结果
可是放到C#中说对象未引用
你看看
你要帮定table,或者.defaultview,不能直接帮定DataSet
我把这个程序到另外一个项目上运行
发现是myDataAdapter.Fill(myDataSet)
E:\website\Webs\applet312\IndexCategory.ascx.cs(48): 与“System.Data.Common.DbDataAdapter.Fill(System.Data.DataTable)”最匹配的重载方法具有一些无效参数