Sie sind aktuell nicht angemeldet.

Funktionen: Einloggen  |  Neu registrieren  |  Suchen

Update funktioniert nicht
Autor: Schili
Datum: 18.09.07 12:59
Hallo, ich habe hier eine Update Funktion erstellt aber er Updatet die Tabelle nicht, kann mir einer sagen warum?? Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click Dim strCon As String = "Data Source=DEBLN193\;Initial Catalog=QualityDB;Integrated Security=True" Dim da As SqlDataAdapter = New SqlDataAdapter() Dim con As SqlConnection = New SqlConnection(strCon) con.Open() Dim cmd As New SqlCommand("UPDATE treetable SET parent_id = 1, item = Project.Name FROM [User] INNER JOIN Site ON [User].Site_id = Site.Site_id INNER JOIN Project ON Site.Site_id = Project.Site_id CROSS JOIN treetable()WHERE [User].Name = 'benjamin.schilbach'", con) Dim cmd1 As New SqlCommand("UPDATE treetable SET item = Build.Name, parent_id = 2 FROM Build INNER JOIN Project ON Build.Project_id = Project.Project_id INNER JOIN Site ON Project.Site_id = Site.Site_id INNER JOIN [User] ON Site.Site_id = [User].Site_id CROSS JOIN treetable()WHERE [User].Name = 'benjamin.schilbach'", con) Dim cmd2 As New SqlCommand("UPDATE treetable SET parent_id = 3, item = 'language.name' FROM Build INNER JOIN [File] ON Build.Build_id = [File].Build_id INNER JOIN Project ON Build.Project_id = Project.Project_id INNER JOIN Site ON Project.Site_id = Site.Site_id INNER JOIN [User] ON Site.Site_id = [User].Site_id CROSS JOIN treetable WHERE [User].Name = 'benjamin.schilbach'", con) Dim cmd3 As New SqlCommand("UPDATE treetable SET parent_id = 4, item = Language.Name FROM Build INNER JOIN [File] ON Build.Build_id = [File].Build_id INNER JOIN Language ON [File].Language_id = Language.Language_id INNER JOIN Project ON Build.Project_id = Project.Project_id INNER JOIN Site ON Project.Site_id = Site.Site_id INNER JOIN [User] ON Site.Site_id = [User].Site_id CROSS JOIN treetable WHERE [User].Name = 'benjamin.schilbach' ", con) cmd.ExecuteNonQuery() con.Close() End Sub

Update funktioniert nicht	960	Schili	18.09.07 12:59
Re: Update funktioniert nicht	571	DaveS	18.09.07 13:15

Thread wurde geschlossen! Dieser Thread wurde von den Moderatoren geschlossen, d.h. es können keine neuen Beiträge mehr gepostet werden!

Funktionen:  Zum Thema  |  Gesamtübersicht

Suchen