[.net] Datagrid

[deedlyt]

Qualcuno ha qualche esempio su come eseguire L'EDIT, CANCEL e UPDATE events usando la griglia di default di .net???

[Ottavio]

Public Sub DataGrid_Delete(Source As Object, _
E As DataGridCommandEventArgs)
dim MyConnection as new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=miopath\miodb.mdb")
Dim myCommand As OleDBCommand
Dim strUpdateStmt As String


strUpdateStmt = " DELETE FROM Fornitore " & _
" WHERE IDFornitore = " & MyDataGrid2.DataKeys(CInt(E.Item.ItemIndex))


myCommand = New OleDBCommand(strUpdateStmt, myConnection)
myConnection.Open()
TRY
myCommand.ExecuteNonQuery()
CATCH DBE as system.data.oledb.oledbexception
lblMessage.Text = "Errore " + dbe.tostring()
END TRY
MyDataGrid2.EditItemIndex = -1
myConnection.close()
BindData()


end sub

Public Sub DataGrid_Edit(Source As Object, _
E As DataGridCommandEventArgs)

MyDataGrid2.EditItemIndex = E.Item.ItemIndex
BindData()
End Sub

Public Sub DataGrid_Update(Source As Object, _
E As DataGridCommandEventArgs)
dim MyConnection as new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=miopath\miodb.mdb")
Dim myCommand As OleDBCommand
Dim sRagioneSociale As string
Dim sIndirizzo As string
Dim sTelefono As string
Dim sReferente As string

sRagioneSociale=request.form.item(3).tostring()
sIndirizzo=request.form.item(4).tostring()
sTelefono=request.form.item(5).tostring()
sReferente=request.form.item(6).tostring()

Dim strUpdateStmt As String

strUpdateStmt = " UPDATE Fornitore SET RagioneSociale = '" & sRagioneSociale & "', " & _
" Indirizzo = '" & sIndirizzo & "', " & _
" Telefono = '" & sTelefono & "', " & _
" Referente = '" & sReferente & "' " & _
" WHERE IDFornitore = " & MyDataGrid2.DataKeys(CInt(E.Item.ItemIndex))

myCommand = New OleDBCommand(strUpdateStmt, myConnection)
myConnection.Open()
TRY
myCommand.ExecuteNonQuery()
CATCH DBE as system.data.oledb.oledbexception
lblMessage.Text = "Errore " + dbe.tostring()
END TRY
MyDataGrid2.EditItemIndex = -1
myConnection.close()
BindData()
End Sub

Public Sub DataGrid_Cancel(Source As Object, _
E As DataGridCommandEventArgs)
MyDataGrid2.EditItemIndex = -1
BindData()
End Sub



:quote: :quote: :quote:

[deedlyt]

grazie^_^

[Ottavio]

[deedlyt]

ho seguito il tuo codice, però mi da un piccolo errore durante l'update...

"Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index "



Sub dgModifica_Edit(ByVal sender As Object, ByVal e As DataGridCommandEventArgs)
dgModifica.EditItemIndex = e.Item.ItemIndex

End Sub

dgModifica.EditItemIndex = 0 ... come mai???

come mai????

[deedlyt]

come faccio a passare ad "e.Item.ItemIndex " il mio INDEX...???

dgModifica.EditItemIndex = e.Item.ItemIndex

nel mio caso è senpre ZERO :-(


HELPPPPPP