Why would this code give me the error
"Could not load type System.Web.UI.W ebControls.Acce ssDataSource from
assembly System.Web, Version=1.0.500 0.0" at line 16...
<form id="form1" runat="server">
Line 15: <div>
Line 16: <asp:AccessData Source ID="AccessDataS ource1"
Runat="server" DataFile="data\ pubs.mdb"
Line 17: SelectCommand=" select * from [authors]"
Line 18: DeleteCommand=" DELETE FROM [authors] WHERE [au_id] = ?"
I heard it might be because .net framework 2.0 is not installed
properly, so I reinstalled .net 2.0 from scratch (its on a winsows 2003
server) but to no avail.
Any idea what is going on here?
<%@ Page language="C#" %>
<%@ import namespace="Syst em" %>
<%@ import namespace="Syst em.Web" %>
<%@ import namespace="Syst em.Web.UI" %>
<%@ import namespace="Syst em.Web.UI.HtmlC ontrols" %>
<%@ import namespace="Syst em.Web.UI.WebCo ntrols" %>
<%@ import namespace="Syst em.Data" %>
<%@ import namespace="Syst em.Data.OleDb" %>
<script RunAt="server">
void EmployeesGridVi ew_OnSelectedIn dexChanged(Obje ct sender, EventArgs e)
{
EmployeeDetails SqlDataSource.S electParameters["EmpID"].DefaultValue =
EmployeesGridVi ew.SelectedValu e.ToString();
EmployeeFormVie w.DataBind();
}
void EmployeeFormVie w_ItemUpdated(O bject sender,
FormViewUpdated EventArgs e)
{
EmployeesGridVi ew.DataBind();
}
void EmployeeFormVie w_ItemDeleted(O bject sender,
FormViewDeleted EventArgs e)
{
EmployeesGridVi ew.DataBind();
}
void EmployeeDetails SqlDataSource_O nInserted(Objec t sender,
SqlDataSourceSt atusEventArgs e)
{
System.Data.Com mon.DbCommand command = e.Command;
EmployeeDetails SqlDataSource.S electParameters["EmpID"].DefaultValue =
command.Paramet ers["@EmpID"].Value.ToString ();
EmployeesGridVi ew.DataBind();
EmployeeFormVie w.DataBind();
}
</script>
<html>
<body>
<form RunAt="server">
<h3>FormView Example</h3>
<table cellspacing="10 ">
<tr>
<td>
<asp:GridView ID="EmployeesGr idView"
DataSourceID="E mployeeAccessDa taSource"
AutoGenerateCol umns="false"
DataKeyNames="E mployeeID"
OnSelectedIndex Changed="Employ eesGridView_OnS electedIndexCha nged"
RunAt="Server">
<HeaderStyle backcolor="Navy "
forecolor="Whit e" />
<Columns>
<asp:ButtonFiel d Text="Details.. ."
HeaderText="Sho w<BR>Details"
CommandName="Se lect"/>
<asp:BoundFie ld DataField="Empl oyeeID"
HeaderText="Emp loyee ID"/>
<asp:BoundFie ld DataField="Last Name"
HeaderText="Las t Name"/>
<asp:BoundFie ld DataField="Firs tName"
HeaderText="Fir st Name"/>
</Columns>
</asp:GridView>
</td>
<td valign="top">
<asp:FormView ID="EmployeeFor mView"
DataSourceID="E mployeeDetailsS qlDataSource"
DataKeyNames="E mployeeID"
Gridlines="Both "
OnItemUpdated=" EmployeeFormVie w_ItemUpdated"
OnItemDeleted=" EmployeeFormVie w_ItemDeleted"
RunAt="server">
<HeaderStyle backcolor="Navy "
forecolor="Whit e"/>
<RowStyle backcolor="Whit e"/>
<EditRowStyle backcolor="Ligh tCyan"/>
<ItemTemplate >
<table>
<tr><td align=right><B> Employee ID:</B></td><td><%#
Eval("EmployeeI D") %></td></tr>
<tr><td align=right><B> First Name:</B></td<td><%#
Eval("FirstName ") %></td></tr>
<tr><td align=right><B> Last Name:</B></td <td><%#
Eval("LastName" ) %></td></tr>
<tr>
<td colspan="2">
<asp:LinkButt on ID="EditButton "
Text="Edit"
CommandName="Ed it"
RunAt="server"/>
<asp:LinkButt on ID="NewButton"
Text="New"
CommandName="Ne w"
RunAt="server"/>
<asp:LinkButt on ID="DeleteButto n"
Text="Delete"
CommandName="De lete"
RunAt="server"/>
</td>
</tr>
</table>
</ItemTemplate>
<EditItemTempla te>
<table>
<tr><td align=right><B> Employee ID:</B></td><td><%#
Eval("EmployeeI D") %></td></tr>
<tr><td align=right><B> First Name:</B></td>
<td><asp:TextBo x ID="EditFirstNa meTextBox"
Text='<%# Bind("FirstName ") %>'
RunAt="Server" /></td></tr>
<tr><td align=right><B> Last Name:</B></td>
<td><asp:TextBo x ID="EditLastNam eTextBox"
Text='<%# Bind("LastName" ) %>'
RunAt="Server" /></td></tr>
<tr>
<td colspan="2">
<asp:LinkButt on ID="UpdateButto n"
Text="Update"
CommandName="Up date"
RunAt="server"/>
<asp:LinkButt on ID="CancelUpdat eButton"
Text="Cancel"
CommandName="Ca ncel"
RunAt="server"/>
</td>
</tr>
</table>
</EditItemTemplat e>
<InsertItemTemp late>
<table>
<tr><td align=right><B> First Name:</B></td>
<td><asp:TextBo x ID="InsertFirst NameTextBox"
Text='<%# Bind("FirstName ") %>'
RunAt="Server" /></td></tr>
<tr><td align=right><B> Last Name:</B></td>
<td><asp:TextBo x ID="InsertLastN ameTextBox"
Text='<%# Bind("LastName" ) %>'
RunAt="Server" /></td></tr>
<tr>
<td colspan="2">
<asp:LinkButt on ID="InsertButto n"
Text="Insert"
CommandName="In sert"
RunAt="server"/>
<asp:LinkButt on ID="CancelInser tButton"
Text="Cancel"
CommandName="Ca ncel"
RunAt="server"/>
</td>
</tr>
</table>
</InsertItemTempl ate>
</asp:FormView>
</td>
</tr>
</table>
<asp:AccessData Source
id="EmployeeAcc essDataSource"
DataFile="~/App_Data/Northwind.mdb"
runat="server"
SelectCommand=" SELECT EmployeeID, LastName, FirstName FROM
Employees WHERE EmployeeID = @EmpID"
InsertCommand=" INSERT INTO Employees(LastN ame, FirstName)
VALUES (@LastName, @FirstName);
SELECT @EmpID = SCOPE_IDENTITY( )"
UpdateCommand=" UPDATE Employees SET LastName=@LastN ame,
FirstName=@Firs tName
WHERE EmployeeID=@Emp loyeeID"
DeleteCommand=" DELETE Employees WHERE EmployeeID=@Emp loyeeID"
ConnectionStrin g="<%$ ConnectionStrin gs:NorthwindCon nection %>"
OnInserted="Emp loyeeDetailsSql DataSource_OnIn serted"
connectionstrin g="<%$ ConnectionStrin gs:NorthwindCon nection %>"
<SelectParamete rs>
<asp:Paramete r Name="Beginning Date" Type="DateTime"
defaultValue="1/1/1997" />
<asp:Paramete r Name="Ending Date" Type="DateTime"
defaultValue="1/31/1997" />
</SelectParameter s>
</asp:AccessDataS ource>
<SelectParamete rs>
<asp:Paramete r Name="EmpID" Type="Int32" DefaultValue="0 " />
</SelectParameter s>
<InsertParamete rs>
<asp:Paramete r Name="EmpID" Direction="Outp ut" Type="Int32"
DefaultValue="0 " />
</InsertParameter s>
</asp:AccessDataS ource>
</form>
</body>
--
_______________ _______________ _______________ __
DC
"You can not reason a man out of a position he did not reach through reason"
"Don't use a big word where a diminutive one will suffice."
"A man with a watch knows what time it is. A man with two watches is
never sure." Segal's Law
