asked on

Object reference not set to an instance of an object. error msg

I all,
Am new to the dot net world and unfortunatly facing what is probably the most discouraging step when learning a new environment, this is those weirdos error message that could be written in chiness ( well for my case ) and would be meaning the same thing... so.

Am simply trying to populate a datagrid from data in a sql table. Currently the datagrid is define to be update/edit/add also.
Am using web matrix. There is yet no data in the table, could it be this the problem? I highly doubt.
Any help would be greatly appreciated.

here's what is under the hood.

Error message I received? yeah sure..
Object reference not set to an instance of an object.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.
Source Error: dtGridPersDir.DataSource=ds.Tables("MyTable").DefaultView

And the code

<%@ Page Language="VB" Debug="true"%>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>

<script runat="server">

Sub Page_Load(Sender As Object, E As EventArgs)

Dim DS As DataSet
Dim MyConnection As SqlConnection
Dim MyCommand As SqlDataAdapter

MyConnection = New SqlConnection("server=(local);database=testing;Trusted_Connection=yes")
MyCommand = New SqlDataAdapter("select * from MyTable", MyConnection)

DS = new DataSet()
MyCommand.Fill(ds, "MyTable")
dtGridPersDir.DataSource=ds.Tables("MyTable").DefaultView
dtGridPersDir.DataBind()
End Sub

</script>

<html>
<head>
</head>
<body>
<form runat="server">
<asp:DataGrid id="dtGridPersDir" runat="server">
<Columns>
<asp:EditCommandColumn ButtonType="LinkButton" UpdateText="Update" CancelText="Cancel" EditText="Edit"></asp:EditCommandColumn>
<asp:HyperLinkColumn Text="Set Inactive" HeaderText="Set Inactive"></asp:HyperLinkColumn>
</Columns>
</asp:DataGrid>

</form>
</body>
</html>

Thanks

DotNetLover_Baan

Your code looks absolutely alright to me. Anyway try this, and see what you get...

DS = new DataSet()
MyCommand.Fill(ds, "MyTable")
If DS.Tables("MyTable").Rows.Count <> 0 Then
dtGridPersDir.DataSource=DS.Tables("MyTable").DefaultView
dtGridPersDir.DataBind()
End If

-Baan

123654789987

This error shows that data is not returned from the database.

DaDMan

ASKER

Thanks for your thoughts guy's but this was my own mistake...
Am stupid..

MyCommand.Fill(ds,"MyTable") was not openening MyTable... was Opening "Authors" table!!!! Did a copy paste from an exemple and missed to change this name...

Well I'll award the points or I ask for a refund. What do you think guys?

Thanks

DotNetLover_Baan

lol.. that was funny... must be working too much.
Go here https://www.experts-exchange.com/Community_Support/
and ask for refund. Good luck :)
-Baan

ASKER CERTIFIED SOLUTION

ee_ai_construct

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial