This is a migrated thread and some comments may be shown as answers.

Prevent add new rows

0 Answers 66 Views
GridView
This is a migrated thread and some comments may be shown as answers.
Hengky
Top achievements
Rank 1
Veteran
Hengky asked on 22 May 2017, 04:41 AM

Hello All.... 

i have this code .. 

    Private Sub GridBarang_CellEndEdit(sender As Object, e As Telerik.WinControls.UI.GridViewCellEventArgs) Handles GridBarang.CellEndEdit
        If e.ColumnIndex = 0 Then
            If GridBarang.CurrentCell.Value = Nothing Then
                MsgBox("test")
            Else
                Dim strSQL As String
                strSQL = Nothing
                strSQL = "SELECT KodeBarang, NamaBarang FROM MstBarang WHERE KodeBarang='" & GridBarang.CurrentRow.Cells(0).Value.ToString & "' ORDER BY KodeBarang"

                Using conn As New OleDbConnection(str)
                    conn.Open()
                    cmd = New OleDbCommand(strSQL, conn)
                    rd = cmd.ExecuteReader
                    rd.Read()

                    If Not rd.HasRows Then
                        MsgBox("Tidak ada kode tersebut ")

                    Else
                        With GridBarang
                            .CurrentCell.Value = rd.GetString(0)
                            .CurrentRow.Cells(1).Value = rd.GetString(1)
                        End With
                    End If

                    rd.Close()
                    conn.Close()
                End Using
            End If
        End If
    End Sub

How to prevent add new row when after inserting new data ... and go to column(3) after edited column(0)  

Thanks before.... 

 

No answers yet. Maybe you can help?

Tags
GridView
Asked by
Hengky
Top achievements
Rank 1
Veteran
Share this question
or