I really do not understand what I am doing wrong.
I was trying to get familiar with WebParts and I am getting the following
error:
The DataSourceID of 'DataList1' must be the ID of a control of type
IDataSource. A control with ID 'SqlMeggitt' could not be found.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.
Exception Details: System.Web.Http Exception: The DataSourceID of 'DataList1'
must be the ID of a control of type IDataSource. A control with ID
'SqlMeggitt' could not be found.
Source Error:
An unhandled exception was generated during the execution of the current web
request. Information regarding the origin and location of the exception can
be identified using the exception stack trace below.
Stack Trace:
[HttpException (0x80004005): The DataSourceID of 'DataList1' must be the ID
of a control of type IDataSource. A control with ID 'SqlMeggitt' could not
be found.]
System.Web.UI.W ebControls.Base DataList.Connec tToDataSourceVi ew() +1783839
System.Web.UI.W ebControls.Base DataList.OnLoad (EventArgs e) +16
System.Web.UI.C ontrol.LoadRecu rsive() +47
System.Web.UI.C ontrol.LoadRecu rsive() +131
System.Web.UI.C ontrol.LoadRecu rsive() +131
System.Web.UI.C ontrol.LoadRecu rsive() +131
System.Web.UI.C ontrol.LoadRecu rsive() +131
System.Web.UI.P age.ProcessRequ estMain(Boolean
includeStagesBe foreAsyncPoint, Boolean includeStagesAf terAsyncPoint) +1061
The website has only one page Default.aspx and I am trying to open a small
table using a dataList control (also I tried GridView and I has the same
results.
here is the code on the page:
<asp:WebPartZon e ID="MainZone" runat="server">
<ZoneTemplate >
<asp:SqlDataSou rce ID="SqlMeggitt "
runat="server" ConnectionStrin g="<%$ ConnectionStrin gs:MSAMFconn %>"
ProviderName="< %$ ConnectionStrin gs:MSAMFconn.Pr oviderName %>"
SelectCommand=" SELECT [Value], AccessType FROM MSAMF.dbo.Acces sType">
</asp:SqlDataSour ce>
<asp:DataList ID="DataList1" runat="server"
DataKeyField="V alue" DataSourceID="S qlMeggitt">
<ItemTemplate >
Value:
<asp:Label ID="ValueLabel "
runat="server" Text='<%# Eval("Value") %>'></asp:Label><br />
AccessType:
<asp:Label ID="AccessTypeL abel"
runat="server" Text='<%# Eval("AccessTyp e") %>'>
</asp:Label><br />
<br />
</ItemTemplate>
</asp:DataList>
</ZoneTemplate>
</asp:WebPartZone >
And here are the connectionStrin gs definitions (Web.config)
<connectionStri ngs>
<add name="MyAspNetD B"
connectionStrin g="server=XXXX\ YYYYY;database= aspnetdb;uid=sa ;pwd=*******;in tegrated security=true" />
<add name="MSAMFconn " connectionStrin g="Dsn=ZZZZZ;ui d=sa;pwd=*****"
providerName="S ystem.Data.Odbc " />
</connectionStrin gs>
Thanks,
Giovanni
