hi
im new in .net and got an error in my first database access page. as follows
<%@ import namespace="system.data" %>
<%@ import namespace="system.data.oledb" %>
<script language="
VB" runat="server" debug="true">
Sub page_load(sender as object, e as eventargs)
dim objconnection as oledbconnection
dim objcommand as oledbdataadapter
dim strconnect as string
dim strcommand as string
dim Dataset1 as dataset
strconnect = "provider=microsoft.jet.oleb.4.0,"
strconnect + = "datasource=c:\inetpub\wwwroot\test\test.mdb,"
strconnect + = "persist security info=false"
strcommand = "select * from userinfo"
objconnection = new oledbconnection(strconnect)
objcommand = new oledbdataadapter(strcommand, objconnection)
objcommand.fill(dataset1, "userinfo")
datagrid1.datasource = dataset1.tables("userinfo").defaultview
datagrid1.databind()
end sub
</script>
<html>
<head>
<title>Data Grid Control Example</title>
</head>
<body>
<asp:datagrid id="datagrid1" runat="server" />
</body>
</html>
it is giving error "null value not allowed in data set."
i think the problem is in the fill dataset
plz if somebody tell me the solutoin
error in dataset
