---
title: "problem med datagrid"
type: "forum-thread"
url: "https://www.webforum.nu/amne/dotnet/59676-problem-med-datagrid"
topic: ".NET"
topic_url: "https://www.webforum.nu/amne/dotnet"
author: "andreas_lindh"
published: "2002-11-19T13:13:30.000Z"
updated: "2002-11-19T13:13:30.000Z"
replies: 0
views: 181
page: 1
pages: 1
language: "sv-SE"
site: "webForum — webforum.nu"
rights: "Upphovsrätten till varje inlägg tillhör dess författare."
attribution: "Citera som: webForum, https://www.webforum.nu/amne/dotnet/59676-problem-med-datagrid"
---

# problem med datagrid

## #1 — andreas_lindh, 2002-11-19T13:13Z

Har lite problem med datagrid.
Felmeddelande

```
Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.

Source Error: 

Line 25:         objcmd1.Fill(ds1, "info")
Line 26:         'Välj dataviewobjekt och bind till serverkontrollen
Line 27:         Datagrid1.DataSource = ds.Tables("kontakt"). _
Line 28:         DefaultView
Line 29:         Datagrid1.DataBind()
 

Source File: h:\inetpub\wwwroot\dena\default.aspx.vb    Line: 27
```

Koden ser ut så här.

```
Imports System
Imports System.Web
Imports System.Web.UI
Imports System.Web.UI.WebControls
Imports System.Data
Imports System.Data.OleDb
Imports System.Configuration

Public Class default1 : Inherits Page

    Public Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        Dim objconn As New OleDbConnection(ConfigurationSettings.AppSettings("connectionstring"))
        Dim Datagrid1 As DataGrid
        Dim Datagrid2 As DataGrid

        Dim objcmd As New OleDbDataAdapter _
                  ("select * from kontakt", objconn)
        Dim objcmd1 As New OleDbDataAdapter _
            ("select top 1 * from info", objconn)

        'Fyll datasetobjekt
        Dim ds As DataSet = New DataSet()
        objcmd.Fill(ds, "kontakt")
        Dim ds1 As DataSet = New DataSet()
        objcmd1.Fill(ds1, "info")
        'Välj dataviewobjekt och bind till serverkontrollen
        Datagrid1.DataSource = ds.Tables("kontakt"). _
        DefaultView
        Datagrid1.DataBind()
        Datagrid2.DataSource = ds1.Tables("info"). _
        DefaultView
        Datagrid2.DataBind()

        Dim id As Integer = "1"
        Dim datum As String = DateTime.Now.ToString("d")
        Dim strsql3 As String = String.Format("update statistik set antal=antal+1,senaste='{0}' where id={1}", datum, id)
        Dim objcmd3 As New OleDbCommand(strsql3, objconn)
        objconn.Close()
        objcmd3.Connection.Open()
        objcmd3.ExecuteNonQuery()
        objcmd3.Connection.Close()
        objconn.Open()
    End Sub

End Class
```

Permalänk: https://www.webforum.nu/p/59676

---

Tråden på webben: https://www.webforum.nu/amne/dotnet/59676-problem-med-datagrid