---
title: "Databind"
type: "forum-thread"
url: "https://www.webforum.nu/amne/dotnet/69206-databind"
topic: ".NET"
topic_url: "https://www.webforum.nu/amne/dotnet"
author: "Nickemannen"
published: "2003-02-24T11:01:05.000Z"
updated: "2003-02-25T07:37:52.000Z"
replies: 4
views: 263
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/69206-databind"
---

# Databind

## #1 — Nickemannen, 2003-02-24T11:01Z

Någon som kan se det enkla felet ?

```
			DataSet objDs = new DataSet();
			
			string strSql = "Select * From diary order by diary_date desc;";
			SqlConnection sqlConn = new SqlConnection("database=falk;server=localhost;Trusted_Connection=yes;");
			sqlConn.Open();
			
			SqlDataAdapter objAdapter = new SqlDataAdapter(strSql, sqlConn);
			objAdapter.Fill(objDs, "diary");

			DataView objDv = new DataView(objDs.Tables["diary"]);

			viewlist.DataSource = objDv;
			viewlist.DataBind();
```

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

Source Error: 

Line 33: 			DataView objDv = new DataView(objDs.Tables\["diary"\]);
Line 34: 
Line 35: 			viewlist.DataSource = objDv;
Line 36: 			viewlist.DataBind();
Line 37:

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

## #2 — NETwork, 2003-02-24T11:10Z

Du ska inte ha ett semikolon i din sql-sats efter "desc".¨

```
string strSql = "Select * From diary order by diary_date desc";
```

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

## #3 — Nickemannen, 2003-02-24T13:33Z

oj, det var enkelt. Tack

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

## #4 — kristoffer, 2003-02-24T21:44Z

Öh. Det kan ju inte ha varit felet. Ett semikolon kan man ju visst ha där. Det separerar ju sql-satser.

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

## #5 — NETwork, 2003-02-25T07:37Z

Aha, det visste jag inte. Prova det här istället kanske:

```
DataView objDv = objDs.Tables["diary"].[b]DefaultView[/b];
```

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

---

Tråden på webben: https://www.webforum.nu/amne/dotnet/69206-databind