error trying to open a database

Boomer · June 10th, 2003, 10:00 AM

Parser Error Message: Could not load type System.Web.UI.WebControls.Data from assembly System.Web, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a

I get the error above when trying to run this code below. Is my code wrong or did my network dude not install the .NET Framework wrong? I am trying to learn .net out of the book "Beginning ASP.Net using VB.Net" I take any help I can get. Thanks for your time.

<script language="vb" runat="server">
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
Sub Page_Load(Sender AS Object, E as EventArgs)
    Dim objConnectin As OldDbConnection
    Dim objCommand As OleDbDataAdapter
    Dim strConnect As String
    Dim strComand As String
    Dim DataSet1 As New DataSet

    strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;"
    strConnect += "Data Source="C:\Databases\brian.mdb;"
    strConnect += "Persist Security Info=False"

    strCommand = "SELECT fldTvShows, fldURL FROM TvShows "
    objConnection = New OleDbConnection(strConnect)
    objCommand = New OleDbDataAdapter(strCommand, objConnection)
    objCommand.Fill(DataSet1, "TvShows")
    DataGrid1.DataSource=DataSet1.Tables("TvShows").De faultView
    DataGrid1.DataBind()
End Sub
</script>

<html>
<head>
<title>Data Grid Control example</title>
<body>
<asp:Data Grid id="DataGrid1" runat="server" />
</body>
</head>
</html>

sg48 · June 21st, 2003, 02:32 PM

Hi, How do you know that is where the data base is?
A better way to connect would be sopmething like:

DBConn = New OleDbConnection("PROVIDER=" _
& "Microsoft.Jet.OLEDB.4.0;" _
& "DATA SOURCE=" _
& Server.MapPath("./databases/" _
& "brian.mdb;"))

Hope this helps. - Steve

NotNowJohn · June 22nd, 2003, 01:46 PM

The reason for an error you received is in this row:
<asp:Data Grid id="DataGrid1" runat="server" />
As you can see you wrote asp:Data Grid instead of asp:DataGrid and this is interpreted as an attempt to add a control named Data.
And, also, you omited a form tag - u have to enclosed all form elements in form tag.

Regs,

...but the Soon is eclipsed by the Moon