how to pass a username to updateCommand 1

eirikr · Sep 29, 2009

in webform.aspx has

<body>
<% String vdUser = Request.ServerVariables["AUTH_USER"]; %>
...

<asp:SqlDataSource ID="dg_vendorTrk" runat="server"
ConnectionString="<%$ ConnectionStrings:conn_vendor_server %>"
...
UpdateCommand="UPDATE table1 SET vdLogAs=@vdUser WHERE (vdId=@vdId)" >
<UpdateParameters>
<asp:QueryStringParameter Name="vdUser" DefaultValue="<%= Request.ServerVariables["AUTH_USER"] %>" />
</UpdateParameters>
</asp:SqlDataSource>

Please HELP, how can i pass a vdUser to either UpdateCommand or UpdateParameters

vicvirk · Sep 29, 2009

Depending on the language you are using, check:

(C#):

http://tek-tips.com/threadminder.cfm?pid=732

or
(VB):

http://tek-tips.com/threadminder.cfm?pid=796

This forum is for Classic ASP, not ASP.NET (which is what you need)

--------
GOOGLE is a great resource to find answers to questions like "how do i..."

If you don't know exaclty what you want to do or what to search on, try Google Suggest:

http://www.google.com/webhp?complete=1&hl=en

--------
I have recently been semi-converted to ensuring all my code (well most of it) works in both javascript and non-javasc

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

how to pass a username to updateCommand 1

eirikr

Programmer

vicvirk

Programmer

Similar threads

Part and Inventory Search

Sponsor