GridView + timestamp

victorsj · August 29th, 2006, 10:41 AM

I have a follow store provedure whit a type data(timestamp):

ALTER PROCEDURE [dbo].[ProveedoresUpd]

(

@ProveedorId int,

@Nombre varchar(150),

@Borrado bit,

@Version timestamp

)

AS

SET NOCOUNT OFF;

UPDATE [ActivosFijos].[Proveedores] SET [Nombre] = @Nombre, [Borrado] = @Borrado

WHERE (([ProveedorId] = @ProveedorId) AND ([Version] = @Version));

In Asp.Net I have a gridview with a sql datasource, this is te code:

<%@ Page Language="VB" AutoEventWireup="false" CodeFile="prov.aspx.vb" Inherits="prov" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >

<head runat="server">

<title>P gina sin tÂ¡tulo</title>

</head>

<body>

<form id="form1" runat="server">

<div>

<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True"

AutoGenerateColumns="False" DataKeyNames="ProveedorId" DataSourceID="SqlDataSource1">

<Columns>

<asp:CommandField ShowEditButton="True" ShowSelectButton="True" />

<asp:BoundField DataField="ProveedorId" HeaderText="ProveedorId" InsertVisible="False"

ReadOnly="True" SortExpression="ProveedorId" />

<asp:BoundField DataField="Nombre" HeaderText="Nombre" SortExpression="Nombre" />

<asp:CheckBoxField DataField="Borrado" HeaderText="Borrado" SortExpression="Borrado" />

</Columns>

</asp:GridView>

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:SiovConnectionString %>"

DeleteCommand="ProveedoresDel" DeleteCommandType="StoredProcedure" InsertCommand="ProveedoresIns"

InsertCommandType="StoredProcedure" SelectCommand="ProveedoresSel" SelectCommandType="StoredProcedure"

UpdateCommand="ProveedoresUpd" UpdateCommandType="StoredProcedure">

<DeleteParameters>

<asp:Parameter Name="Original_ProveedorId" Type="Int32" />

<asp:Parameter Name="Original_Version" Type="Object" />

</DeleteParameters>

<UpdateParameters>

<asp:Parameter Name="ProveedorId" Type="Int32" />

<asp:Parameter Name="Nombre" Type="String" />

<asp:Parameter Name="Borrado" Type="Boolean" />

<asp:Parameter Name="Version" Type="DateTime" />

</UpdateParameters>

<InsertParameters>

<asp:Parameter Name="Nombre" Type="String" />

<asp:Parameter Name="Borrado" Type="Boolean" />

</InsertParameters>

</asp:SqlDataSource>

</div>

</form>

</body>

</html>

But, I need update a row the colum Version is nothing or null, so What I can do?