Onrowupdating in gridview

New Edit Index ' Execute Non Query("Update tbl Work Order Item Set Note='' Where Work Order Item ID=" & Convert. Close() Bind_Data() End Using Catch ex As Exception End Try End Sub Protected Sub Grid View1_Row Canceling Edit(sender As Object, e As Grid View Cancel Edit Event Args) Handles Grid View1. Edit Index = -1 End Sub Protected Sub Grid View1_Row Updating(sender As Object, e As Grid View Update Event Args) Handles Grid View1. Edit Index = -1 Dim str Note As String = Direct Cast(Grid View1.

Note='" & str Note & "' Where Work Order Item ID=" & Convert.

I expect to do some checking by 'On Row Updating' so I have this event below in the code-behind. Data Format String="" Could the web master pls transfer this to Oracle sub-forum?

Text = "Unable To Find Date." End If If Not Is DBNull(Session("Due Date")) Then lbl Date Due. Text = "Due Date Not Found." End If Bind_Data() End Sub Private Sub Bind_Data() Using con As New Ole Db Connection(Configuration Manager. Connection String) Dim cmd As New Ole Db Command("SELECT [tbl Work Order Item]. Note FROM (tbl Work Order Item INNER JOIN tbl Work Order ON tbl Work Order Item. Parameters Dim my Param As Ole Db Parameter = my Param Collection. Text = Session("Country") Else lbl Company Country. Text = "No Country Found." End If If Not Is DBNull(Session("Start Date")) Then lbl Date Created. To Int16(Session("ID")) Dim select Results As New Data Set() Dim ole_DBAdapter As New Ole Db Data Adapter(cmd) ole_DBAdapter. Trim() & "'", Conn) ' where cinvnum='" & grv Sample. Edit Index = -1 Dim SSQL = "select * from pass_details" Dim ds As New Data Set("GET_HIS") Dim adp As New Sql Data Adapter(SSQL, Conn) adp.

You can also manipulate the Keys, Old Values, and New Values collections, if necessary, before the values are passed to the data source.