原代码: Sub confirm100(Sender As Object, E As DataGridCommandEventArgs)
Dim keyValue As String = CStr(DataGrid1.DataKeys(e.Item.ItemIndex))
Dim myConnection As New SqlConnection(ConnectionString)
Dim UpdateCommand As SqlCommand = new SqlCommand()
UpdateCommand.Connection = myConnection
UpdateCommand.CommandText ="UPDATE tbl_JLGZ set memo='Do not need Update' where YG_ID='" & keyValue & '"错误行指向:UpdateCommand.CommandText ="UPDATE tbl_JLGZ set memo='Do not need Update' where YG_ID='" & keyValue & '"
Dim keyValue As String = CStr(DataGrid1.DataKeys(e.Item.ItemIndex))
Dim myConnection As New SqlConnection(ConnectionString)
Dim UpdateCommand As SqlCommand = new SqlCommand()
UpdateCommand.Connection = myConnection
UpdateCommand.CommandText ="UPDATE tbl_JLGZ set memo='Do not need Update' where YG_ID='" & keyValue & '"错误行指向:UpdateCommand.CommandText ="UPDATE tbl_JLGZ set memo='Do not need Update' where YG_ID='" & keyValue & '"
UpdateCommand.CommandText ="UPDATE tbl_JLGZ set memo='Do not need Update' where YG_ID='" & keyValue & "'"