HighTechTalks DotNet Forums  

Stored Proc to delete from gridview

Dotnet Scripting microsoft.public.dotnet.scripting


Discuss Stored Proc to delete from gridview in the Dotnet Scripting forum.



Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old   
sparty1022
 
Posts: n/a

Default Stored Proc to delete from gridview - 07-27-2006 , 12:19 PM






I have a stored procedure that I pass a parameter to, to delete a record.

What I haven't found is how to identify the parameter to the delete call.
The parameter that should be passed is the "datasourcekey field" of
gridview1.

This is the code:
DeleteCommand="sp_LOI_Delete_NewProgram" DeleteCommandType="StoredProcedure"

<DeleteParameters>
<asp:ControlParameter ControlID="GridView1" Name="NewProg_ID"
PropertyName="DataKeys" Type="Int64" />
</DeleteParameters>

Reply With Quote
  #2  
Old   
Kris
 
Posts: n/a

Default Re: Stored Proc to delete from gridview - 08-15-2006 , 10:19 AM






Check the below link to find the answer
http://www.codeproject.com/aspnet/Gr...firmDelete.asp


sparty1022 wrote:
Quote:
I have a stored procedure that I pass a parameter to, to delete a record.

What I haven't found is how to identify the parameter to the delete call.
The parameter that should be passed is the "datasourcekey field" of
gridview1.

This is the code:
DeleteCommand="sp_LOI_Delete_NewProgram" DeleteCommandType="StoredProcedure"

DeleteParameters
asp:ControlParameter ControlID="GridView1" Name="NewProg_ID"
PropertyName="DataKeys" Type="Int64" /
/DeleteParameters


Reply With Quote
Reply




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.