Can anyone tell me why im getting this error??
Heres the code Im using
%@ Page Language="
vb" AutoEventWireup="false" Codebehind="WebForm1.aspx.
vb" Inherits="DataControlCH2.WebForm1" debug="True"%>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.Oledb" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<title>Data Grid Control Example</title>
<script runat="server">
'Sub Page_Load(Sender as Object, E as EventArgs)
Dim myCNN as OleDbConnection
Dim objCommand as OleDbDataAdapter
Dim mySQL as string
Dim strConnect as string
Dim DataSet1 as DataSet
strConnect= "Provider=Microsoft.Jet.OLEDB.4.0;"
strConnect+="Data Source=C:\AccessWork\CompanyDatabase.mdb;"
strConnect+="Persist Security Info=False"
mySQL= "Select SSN,FName,LName From Employee"
myCNN= New OleDBConnection(strConnect)
objCommand=New OleDBDataAdapter(mySQL,myCNN)
objCommand.Fill(DataSet1, "employee")
DataGrid1.DataSource=DataSet1.Tables("Employee").D efaultView
DataGrid1.DataBind()
End Sub
</script>
<meta name="GENERATOR" content="Microsoft Visual Studio .NET 7.1">
<meta name="CODE_LANGUAGE" content="Visual Basic .NET 7.1">
<meta name="vs_defaultClientScript" content="VBScript">
<meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">
</HEAD>
<body MS_POSITIONING="GridLayout" BGCOLOR="#ffffff">
<form id="WebForm1" method="post" runat="server">
<asp:DataGrid id="DataGrid1" style="Z-INDEX: 101; LEFT: 136px; POSITION: absolute; TOP: 136px"
runat="server" Width="216px" Height="168px"></asp:DataGrid>
</form>
</body>
</HTML>
Value cannot be null. Parameter name: dataSet
