---
title: "Cannot access a closed Stream"
type: "forum-thread"
url: "https://www.webforum.nu/amne/dotnet/156857-cannot-access-a-closed-stream"
topic: ".NET"
topic_url: "https://www.webforum.nu/amne/dotnet"
author: "xarfez"
published: "2007-02-06T14:28:20.000Z"
updated: "2007-02-06T16:51:42.000Z"
replies: 2
views: 283
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/156857-cannot-access-a-closed-stream"
---

# Cannot access a closed Stream

## #1 — xarfez, 2007-02-06T14:28Z

Jag använder följande för att hämta data till två nestlade repeaters. Men den klagar på "Cannot access a closed Stream." Varför?

```
Dim conString As String = "xxx"

        Dim sql As String = "SELECT * FROM forum_Category; SELECT a.heading, a.mainCategoryID, a.threadsID, a.datetime, a.post, AU.name FROM forum_Threads a INNER JOIN forum_User AU ON a.userID = AU.userID WHERE threadsID IN (SELECT b.threadsID FROM forum_Threads a INNER JOIN forum_Threads b ON a.threadsID >= b.threadsID AND a.mainCategoryID = b.mainCategoryID GROUP BY b.threadsID HAVING (COUNT(1) BETWEEN 1 AND 5)) ORDER BY a.datetime DESC;"

        Dim conn As MySqlConnection = New MySqlConnection(conString)

        Dim dsPersonLink As DataSet = New DataSet()
        Dim da As MySqlDataAdapter = New MySqlDataAdapter(sql, conn)
       
        da.Fill(dsPersonLink) '<-- här klagar den
 
        dsPersonLink.Relations.Add(New Data.DataRelation("NestThem", dsPersonLink.Tables(0).Columns("mainCategoryID"), dsPersonLink.Tables(1).Columns("mainCategoryID")))
        repPersonLink.DataSource = dsPersonLink
        repPersonLink.DataBind()
```

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

## #2 — flexish, 2007-02-06T16:35Z

Öppna databaskopplingen så ska det lösa sig.

```
conn.Open()
```

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

## #3 — xarfez, 2007-02-06T16:51Z

> **flexish skrev:**
>
> Öppna databaskopplingen så ska det lösa sig.
> 
>
>
> ```
> conn.Open()
> ```

Har försökt att göra det men det hjälpte inte.

<http://www.xfzdesign.se/infoko/forum/>

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

---

Tråden på webben: https://www.webforum.nu/amne/dotnet/156857-cannot-access-a-closed-stream