Solved

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

Posted on 2004-09-13
6
234 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
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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Help with Syntax 9 36
VB.net Open Folder in Windows Explorer 3 29
cannot connect to sqlserver 8 26
start a process from a service 3 22
Article by: Kraeven
Introduction Remote Share is a simple remote sharing tool, enabling you to see, add and remove remote or local shares. The application is written in VB.NET targeting the .NET framework 2.0. The source code and the compiled programs have been in…
Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

776 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