how to do this?

  • Thread starter Thread starter Ben
  • Start date Start date
B

Ben

Hi,

I need the values of the fields of the record that has been selected for
updating in a gridview.
In the
"Protected Sub GridView1_RowEditing(ByVal sender As Object, ByVal e As
System.Web.UI.WebControls.GridViewEditEventArgs) Handles
GridView1.RowEditing",

i couldn't find those values ..

Is this possible, and if yes, how?
Thanks for help
Ben
 
Ok, here part of the code:

1) aspx file:
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConflictDetection="CompareAllValues"
ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\my.mdb"
SelectCommand="SELECT * FROM [lokaal]"
UpdateCommand="UPDATE
SET [field1] = ?, [field2 = WHERE [field1
= ?">
<UpdateParameters>
<asp:Parameter Name="field1 Type="String" />
<asp:Parameter Name="field2" Type="String" />

<asp:Parameter Name="original_field1" Type="string" />
<asp:Parameter Name="original_field2" Type="String" />

</UpdateParameters>
</asp:SqlDataSource>

<asp:GridView ID="GridView1" runat="server"
DataKeyNames="field1" DataSourceID="SqlDataSource1" />
<Columns>
<asp:CommandField ShowEditButton="True" >
<asp:BoundField DataField="field1" />
<asp:BoundField DataField="field2" />
</Columns>
</asp:GridView>

2) code-behind:
Protected Sub GridView1_RowEditing(ByVal sender As Object, ByVal e As
System.Web.UI.WebControls.GridViewEditEventArgs) Handles
GridView1.RowEditing
' I want here the code for fetching the original values of the two
fields ('field1', 'field2') of that record (before updating)
End Sub
 
Back
Top