|
Subject:
|
GridView + timestamp
|
|
Posted By:
|
victorsj
|
Post Date:
|
8/29/2006 10:41:29 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?
|
|
