Hier die gesamte codeBehind datei vielleicht siehst du ja etwas falsches!
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs)
Handles MyBase.Load
If Not Page.IsPostBack Then
BindData()
End If
End Sub
Public Sub BindData()
Dim strConn As String = "server=**;uid=**;pwd=**;database=**"
Dim sql As String = " select MaGruppe, Bezeichnung, KostGruppe,Leistungsgruppe
from v_MaGruppe"
Dim conn As New SqlConnection(strConn)
Dim objDR As SqlDataReader
Dim Cmd As New SqlCommand(sql, conn)
conn.Open()
objDR = Cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection)
DataGrid1.DataSource = objDR
DataGrid1.DataBind()
conn.Close()
End Sub
Public Sub myDataGrid_EditCommand(ByVal s As Object, ByVal e As
DataGridCommandEventArgs)
DataGrid1.EditItemIndex = e.Item.ItemIndex
BindData()
End Sub
Public Sub myDataGrid_Cancel(ByVal Source As Object, ByVal E As
DataGridCommandEventArgs)
DataGrid1.EditItemIndex = -1
BindData()
End Sub
Public Sub MyDataGridUpdateCommand(ByVal s As Object, ByVal e As
DataGridCommandEventArgs)
Dim conn As SqlConnection
Dim mycommand As SqlCommand
Dim strConn As String = "server=**;uid=**;pwd=**;database=**"
Dim txtBezeichnung As TextBox = e.Item.Cells(2).Controls(0)
Dim txtKostGruppe As TextBox = e.Item.Cells(3).Controls(0)
Dim txtLeistungsgruppe As TextBox = e.Item.Cells(4).Controls(0)
Dim strUpdate As String
strUpdate = "UPDATE v_MaGruppe SET" & _
"Bezeichnung = @Bezeichnung,KostGruppe = @KostGruppe, Leistungsgruppe =
@Leistungsgruppe WHERE MaGruppe = @MaGuppe"
conn = New SqlConnection(strConn)
mycommand.ExecuteNonQuery()
DataGrid1.EditItemIndex = -1
conn.Close()
BindData()
End Sub
-----Urspr�ngliche Nachricht-----
Von: Brunmair, Patrick
Gesendet: Montag, 02. Februar 2004 15:41
An: [EMAIL PROTECTED]
Betreff: AW: [Asp.net] Aktives Schema
Ja , das hat der form designer gemacht
-----Urspr�ngliche Nachricht-----
Von: Alexander Zeitler [mailto:[EMAIL PROTECTED]
Gesendet: Montag, 02. Februar 2004 15:42
An: [EMAIL PROTECTED]
Betreff: RE: [Asp.net] Aktives Schema
Hallo,
> Sub BindData()
> Dim strConn as string =
> "server=YourServer;uid=UID;pwd=PWD;database=Northwind"
> Dim sql as string = "Select EmployeeID, FirstName, LastName,
> Title from Employees"
> Dim conn as New SQLConnection(strConn)
> Dim objDR as SQLDataReader
> Dim Cmd as New SQLCommand(sql, conn)
> conn.Open()
> objDR=Cmd.ExecuteReader(system.data.CommandBehavior.CloseConnection)
> MyDataGrid.DataSource = objDR ------>hier become ich den fehler!
> MyDataGrid.DataBind()
> conn.close
>
hast Du das DataGrid in der CodeBehind deklariert?
also z.B. public System.Web.UI.WebControls.DataGrid MyDataGrid?
Gruss
Alex
_______________________________________________
Asp.net mailing list
[EMAIL PROTECTED]
http://www.glengamoi.com/mailman/listinfo/asp.net
_______________________________________________
Asp.net mailing list
[EMAIL PROTECTED]
http://www.glengamoi.com/mailman/listinfo/asp.net
_______________________________________________
Asp.net mailing list
[EMAIL PROTECTED]
http://www.glengamoi.com/mailman/listinfo/asp.net
