VB.NET

Datagrid

Please support our VB.NET advertiser: Intel Parallel Studio Home

•

Join Date: Apr 2007

Posts: 2

Reputation: manak chand is an unknown quantity at this point

Solved Threads: 0

manak chand manak chand is offline

Offline

Newbie Poster

Datagrid

Apr 16th, 2007

Hi everyone, can anyone tell me how to store record from datagrid to oracle database at run time. user have to enter one record in datagrid at run time and the record should be saved at button click in the oracle.

manak chand

•

Join Date: Sep 2006

Posts: 4

Reputation: evilfruitsmashe is an unknown quantity at this point

Solved Threads: 0

evilfruitsmashe evilfruitsmashe is offline

Offline

Newbie Poster

Re: Datagrid

Apr 16th, 2007

Edit the following code and put it in the button routine:

 Help with Code Tags 
 VB.NET Syntax (Toggle Plain Text) 
        Dim drRow As DataRow
        Dim intRow As Integer = 0
        If DataSet1.HasChanges Then
            For Each drRow In  DataSet1.Tables("TABLENAME").Rows
                If drRow.RowState = DataRowState.Added Then
                    'add your SQL Statement for INSERT HERE
                ElseIf drRow.RowState = DataRowState.Modified Then
                    ' add your SQL Statement for UPDATE HERE
                ElseIf drRow.RowState = DataRowState.Deleted Then
                    ' add your SQL Statement for DELETE HERE
                End If
                intRow += 1
            Next
        Dim drRow As DataRow
        Dim intRow As Integer = 0
        If DataSet1.HasChanges Then
            For Each drRow In  DataSet1.Tables("TABLENAME").Rows
                If drRow.RowState = DataRowState.Added Then
                    'add your SQL Statement for INSERT HERE
                ElseIf drRow.RowState = DataRowState.Modified Then
                    ' add your SQL Statement for UPDATE HERE
                ElseIf drRow.RowState = DataRowState.Deleted Then
                    ' add your SQL Statement for DELETE HERE
                End If
                intRow += 1
            Next

after this just call your routine to pass the SQL code to the database.