Dear sir/madam,
I get this error wen I try to run my page:
Object reference not set to an instance of an object
on:
Groups.DataSource = dsgroup.Tables("tblGroup").DefaultView
I think I have created every instance, so I don't know why it's saying that. It's a very small application with the following code:
ASPX:
-----
<%@ Page Language="vb" AutoEventWireup="false" Codebehind="repeater.aspx.vb" Inherits="Datagrid.repeater"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<title>repeater</title>
<meta name="GENERATOR" content="Microsoft Visual Studio.NET 7.0">
<meta name="CODE_LANGUAGE" content="Visual Basic 7.0">
<meta name="vs_defaultClientScript" content="JavaScript">
<meta name="vs_targetSchema" content=" </HEAD>
<body MS_POSITIONING="GridLayout">
<form id="Form1" method="post" runat="server">
<asp:Repeater Runat="server" ID="Groups">
<HeaderTemplate>
<table width="100%">
</HeaderTemplate>
<ItemTemplate>
<tr>
<td>
<%# DataBinder.Eval(Container.DataItem, "Groupnumber") %>
</td>
<td>
<%# DataBinder.Eval(Container.DataItem, "Groupname") %>
</td>
</tr>
</ItemTemplate>
<FooterTemplate>
</table>
</FooterTemplate>
</asp:Repeater>
</form>
</body>
</HTML>
CODE BEHIND:
------------
Imports System.Data
Imports System.Data.OleDb
Imports System.Text
Public Class repeater
Inherits System.Web.UI.Page
Protected WithEvents Groups As System.Web.UI.WebControls.Repeater
Dim cnAccess As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\temp\franchises\franchises.mdb")
#Region " Web Form Designer Generated Code "
'This call is required by the Web Form Designer.
<System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()
End Sub
Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init
'CODEGEN: This method call is required by the Web Form Designer
'Do not modify it using the code editor.
InitializeComponent()
End Sub
#End Region
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'Connect to the database
cnAccess.Open()
'Make the select statement to get the groups
Dim sSelectSQL As String
sSelectSQL = "select * from tblGroup"
'Make the OLEDBCommand object
Dim cmdSelect As New OleDbCommand(sSelectSQL, cnAccess)
Dim daGroup As New OleDbDataAdapter(cmdSelect)
Dim dsgroup As New DataSet()
daGroup.Fill(dsgroup, "Groups")
Groups.DataSource = dsgroup.Tables("tblGroup").DefaultView
Groups.DataBind()
cnAccess.Close()
End Sub
End Class
Please help me with this problem. You have my great thanks in advance.
Kind regards
Jelle
I get this error wen I try to run my page:
Object reference not set to an instance of an object
on:
Groups.DataSource = dsgroup.Tables("tblGroup").DefaultView
I think I have created every instance, so I don't know why it's saying that. It's a very small application with the following code:
ASPX:
-----
<%@ Page Language="vb" AutoEventWireup="false" Codebehind="repeater.aspx.vb" Inherits="Datagrid.repeater"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<title>repeater</title>
<meta name="GENERATOR" content="Microsoft Visual Studio.NET 7.0">
<meta name="CODE_LANGUAGE" content="Visual Basic 7.0">
<meta name="vs_defaultClientScript" content="JavaScript">
<meta name="vs_targetSchema" content=" </HEAD>
<body MS_POSITIONING="GridLayout">
<form id="Form1" method="post" runat="server">
<asp:Repeater Runat="server" ID="Groups">
<HeaderTemplate>
<table width="100%">
</HeaderTemplate>
<ItemTemplate>
<tr>
<td>
<%# DataBinder.Eval(Container.DataItem, "Groupnumber") %>
</td>
<td>
<%# DataBinder.Eval(Container.DataItem, "Groupname") %>
</td>
</tr>
</ItemTemplate>
<FooterTemplate>
</table>
</FooterTemplate>
</asp:Repeater>
</form>
</body>
</HTML>
CODE BEHIND:
------------
Imports System.Data
Imports System.Data.OleDb
Imports System.Text
Public Class repeater
Inherits System.Web.UI.Page
Protected WithEvents Groups As System.Web.UI.WebControls.Repeater
Dim cnAccess As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\temp\franchises\franchises.mdb")
#Region " Web Form Designer Generated Code "
'This call is required by the Web Form Designer.
<System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()
End Sub
Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init
'CODEGEN: This method call is required by the Web Form Designer
'Do not modify it using the code editor.
InitializeComponent()
End Sub
#End Region
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'Connect to the database
cnAccess.Open()
'Make the select statement to get the groups
Dim sSelectSQL As String
sSelectSQL = "select * from tblGroup"
'Make the OLEDBCommand object
Dim cmdSelect As New OleDbCommand(sSelectSQL, cnAccess)
Dim daGroup As New OleDbDataAdapter(cmdSelect)
Dim dsgroup As New DataSet()
daGroup.Fill(dsgroup, "Groups")
Groups.DataSource = dsgroup.Tables("tblGroup").DefaultView
Groups.DataBind()
cnAccess.Close()
End Sub
End Class
Please help me with this problem. You have my great thanks in advance.
Kind regards
Jelle