Ciao a tutti ormai sto diventando un assiduo frequentatore del forum!Ho preso dati da un db (sql servere 2005 express) con questa query che parte all'apertura del form:
Private Sub permessirisorse_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
objDataAdapter.SelectCommand =
New SqlCommand()
objDataAdapter.SelectCommand.Connection = objConnection
objDataAdapter.SelectCommand.CommandText =
" SELECT User_id,PSW,Creazione,Controllo FROM Utenti "
objDataAdapter.SelectCommand.CommandType = CommandType.Text
objConnection.Open()
objDataAdapter.Fill(objDataSet,
"Utenti")
objConnection.Close()
grdUtenti.AutoGenerateColumns =
True
grdUtenti.DataSource = objDataSet
grdUtenti.DataMember =
"Utenti"
Dim objAlignRightCellStyle As New DataGridViewCellStyle
objAlignRightCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight
Dim objAlternatingCellstyle As New DataGridViewCellStyle()
objAlternatingCellstyle.BackColor = Color.LightBlue
grdUtenti.AlternatingRowsDefaultCellStyle = objAlternatingCellstyle
Dim objCurrencyCellStyle As New DataGridViewCellStyle
objCurrencyCellStyle.Format =
"c"
objCurrencyCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight
objAlignRightCellStyle =
Nothing
objAlternatingCellstyle =
Nothing
objCurrencyCellStyle =
Nothing
objDataAdapter =
Nothing
objConnection =
Nothing
End Sub
ora una volta modificati i dati nel datagrid view vorrei modificarli nel db. Come posso fare?
Grazie