---
title: "databas uppdateras inte"
type: "forum-thread"
url: "https://www.webforum.nu/amne/dotnet/157272-databas-uppdateras-inte"
topic: ".NET"
topic_url: "https://www.webforum.nu/amne/dotnet"
author: "MizzK"
published: "2007-02-16T10:59:27.000Z"
updated: "2007-02-16T10:59:27.000Z"
replies: 0
views: 260
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/157272-databas-uppdateras-inte"
---

# databas uppdateras inte

## #1 — MizzK, 2007-02-16T10:59Z

Har en funktion där de ska uppdatera en text mot databasen, men koden går igenom som om de vore ok, men de sker ingen uppdatering.Tips?

 

```
 Public Sub update_Click(ByVal Sender As System.Object, ByVal E As System.EventArgs)
        '<- Databasanslutning ->
        Dim strConn As String = DbHandler.GetstrConnection
        Dim myConnection As New OleDbConnection(strConn)

        '<- Hämta all ifyllt data från webbsidan ->

        Dim Ainfo As String = info.Text
        Dim Uploader_value As String = getname(HttpContext.Current.User.Identity.Name)

        Dim Tnman As String = getname(HttpContext.Current.User.Identity.Name)

        Dim strSQL As String = "UPDATE Texter SET Texter.texten= @text WHERE (((Texter.Namn)='Startinfo'));"

        Dim myCommand As New OleDbCommand(strSQL, myConnection)
        myCommand.Parameters.Add("@text", OleDbType.VarChar, 50).Value = Ainfo

        Dim numRowsAffected As Integer = 0
        Try
            myCommand.Connection.Open()
            numRowsAffected = myCommand.ExecuteNonQuery()
            myCommand.Connection.Close()
        Catch ex As Exception
            lblMessage.Text = ex.Message
            Exit Sub
        End Try

        If numRowsAffected > 0 Then
            lblMessage.Text = lblMessage.Text & "Information sparad"
 

        Else
            lblMessage.Text = lblMessage.Text & "Information INTE sparat"
        End If

    End Sub
```

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

---

Tråden på webben: https://www.webforum.nu/amne/dotnet/157272-databas-uppdateras-inte