newbie gridview question - how to autoupdate a field

This is a multi-part message in MIME format.

------=_NextPart_000_000F_01C85DCB.7F9DEE60
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

I have a newbie question. I am showing the grid control bound to my =
database, but I want to automatically update a "last changed by" field =
whenever someone updates a record. I tried adding =
onrowupdated=3D"GridView_RowUpdated" to the gridview definition and then =
the following code but it just returns an error.=20




I also tried adding in the change to the "UpdateCommand" as:
UpdateCommand=3D"Update RefInfo SET=20
ServerTypeDesc=3D@ServerTypeDesc,
LastChangeID=3DChangerID,
WHERE ServerType=3D@ServerType">

but that just gives me an error as well. Can someone point out the =
proper way to do this?
Mark




Base code:

<%@ page language=3D"VB" %>
<%@ Import Namespace=3D"System.Data" %>
<%@ Import Namespace=3D"System.Data.SqlClient" %>





<%
dim ChangerID
ChangerID =3D Request.ServerVariables("LOGON_USER")
%>

ConnectionString=3D"<%$ ConnectionStrings:RWSqlConnectionString %>"
SelectCommand=3D"SELECT * FROM REFINFO"
UpdateCommand=3D"Update RefInfo SET=20
ServerTypeDesc=3D@ServerTypeDesc,
WHERE ServerType=3D@ServerType">

RE: newbie gridview question - how to autoupdate a field

Hi Mark,

Could you please let me know where this ChangeID coming from because you can
select any of the option for the ChangeID parameter where it is coming from
like control, Querystring and all.

Regards,
Manish
www.ComponentOne.com

"Mark" wrote:

> I have a newbie question. I am showing the grid control bound to my
> database, but I want to automatically update a "last changed by" field
> whenever someone updates a record. I tried adding
> onrowupdated="GridView_RowUpdated" to the gridview definition and then the
> following code but it just returns an error.
>
>
>
>
> I also tried adding in the change to the "UpdateCommand" as:
> UpdateCommand="Update RefInfo SET
> ServerTypeDesc=@ServerTypeDesc,
> LastChangeID=ChangerID,
> WHERE ServerType=@ServerType">
>
> but that just gives me an error as well. Can someone point out the proper
> way to do this?
> Mark
>
>
>
>
> Base code:
>
> <%@ page language="VB" %>
> <%@ Import Namespace="System.Data" %>
> <%@ Import Namespace="System.Data.SqlClient" %>
>
>
>
>
>
> <%
> dim ChangerID
> ChangerID = Request.ServerVariables("LOGON_USER")
> %>
>
> > ConnectionString="<%$ ConnectionStrings:RWSqlConnectionString %>"
> SelectCommand="SELECT * FROM REFINFO"
> UpdateCommand="Update RefInfo SET
> ServerTypeDesc=@ServerTypeDesc,
> WHERE ServerType=@ServerType">
>
>
>

Re: newbie gridview question - how to autoupdate a field

Manish,
I am just writing code in notepad to do all of this.
The variable ChangerID is the logon credentials of the person visiting the
website. It is extracted at the top of the code via the ASP code:
ChangerID = Request.ServerVariables("LOGON_USER")

essentially I want to put into the database the id of whoever made the
change but I can't figure out how to code the GridView so that when someone
updates something it not only updates the data table with the changes made
via the gridview but also the variable.

any help would be greatly appreciated!
Mark




"Manish" wrote in message
news:C531893F-08D2-46F6-9BD5-C1E4EBD908C6@microsoft.com...
> Hi Mark,
>
> Could you please let me know where this ChangeID coming from because you
> can
> select any of the option for the ChangeID parameter where it is coming
> from
> like control, Querystring and all.
>
> Regards,
> Manish
> www.ComponentOne.com
>
> "Mark" wrote:
>
>> I have a newbie question. I am showing the grid control bound to my
>> database, but I want to automatically update a "last changed by" field
>> whenever someone updates a record. I tried adding
>> onrowupdated="GridView_RowUpdated" to the gridview definition and then
>> the
>> following code but it just returns an error.
>>
>>
>>
>>
>> I also tried adding in the change to the "UpdateCommand" as:
>> UpdateCommand="Update RefInfo SET
>> ServerTypeDesc=@ServerTypeDesc,
>> LastChangeID=ChangerID,
>> WHERE ServerType=@ServerType">
>>
>> but that just gives me an error as well. Can someone point out the proper
>> way to do this?
>> Mark
>>
>>
>>
>>
>> Base code:
>>
>> <%@ page language="VB" %>
>> <%@ Import Namespace="System.Data" %>
>> <%@ Import Namespace="System.Data.SqlClient" %>
>>
>>
>>
>>
>>
>> <%
>> dim ChangerID
>> ChangerID = Request.ServerVariables("LOGON_USER")
>> %>
>>
>> >> ConnectionString="<%$ ConnectionStrings:RWSqlConnectionString %>"
>> SelectCommand="SELECT * FROM REFINFO"
>> UpdateCommand="Update RefInfo SET
>> ServerTypeDesc=@ServerTypeDesc,
>> WHERE ServerType=@ServerType">
>>
>>
>>