Solved

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

Posted on 2004-09-13
6
245 Views
Last Modified: 2012-05-05
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>
        <!-- Insert content here -->
    </form>
</body>
</html>

Thanks
0
Comment
Question by:DaDMan
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 18

Expert Comment

by:DotNetLover_Baan
ID: 12049687
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
0
 
LVL 10

Expert Comment

by:123654789987
ID: 12051306
This error shows that data is not returned from the database.
0
 
LVL 1

Author Comment

by:DaDMan
ID: 12070535
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


0
 
LVL 18

Expert Comment

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

Accepted Solution

by:
ee_ai_construct earned 0 total points
ID: 12173129
Closed, 150 points refunded.
ee_ai_construct (replacement part #xm34)
Community Support Admin
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to create and use a custom WaterMark textbox class.  The custom WaterMark textbox class allows you to set the WaterMark Background Color and WaterMark text at design time.   IMAGE OF WATERMARKS STEPS Create VB …
Since .Net 2.0, Visual Basic has made it easy to create a splash screen and set it via the "Splash Screen" drop down in the Project Properties.  A splash screen set in this manner is automatically created, displayed and closed by the framework itsel…
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …

689 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question