Hi All,
I'm trying to get a DataGrid to show the result DataSet of a SQL query. I drop the SQLAdapter object onto my page and go through the configuration of the Connection and Adapter and that seems to be okay. I go about generating a DataSet from the Data item on VS.Net's menu and that seems to be okay. I adjust the DataSouce, DataMember and DataKeyField in the DataGrid and the grid assumes the columns from the DataSet... okay, fine. When I try to test run the page I get an error:
D:\My Webs\DataCraft\Schedule\Schedule.aspx.cs(28): The type or
namespace name 'MyDataSet' does not exist in the class or
namespace 'Schedule.Schedule' (are you missing an assembly reference?)
Apparently a line of code:
protected Schedule.MyDataSet myDataSet1;
is created in the code-behind section that is causing the error.
Does anyone have any idea what else I need to do to get this to work. It seems that what I've done so far should be very trivial in VS.Net.
Aloha,
James