-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: Iamtheoneurwarnedabout
Message 3 in Discussion
Hi Raghavendra,
Are you using ASP.Net..??? You can have a check box infront of each row and
select the check box (which are all the records/rows you want to delete).
You can get the selected values by using the following code: I did the same
for my repeater control, I hope the funda will be same.
//In C#
String strChkdItm;
strCkhdItm = Request.Form.Get("chkbox"); //chkbox is the name of the check
box.
strChkdItm will contain all the selected/checked values separated by
commas.
In your stored proc/database you can use the following code to delete the
selected records.
CREATE PROCEDURE SP_FFMT_DEL_ORDER_ITEM
@strCkhdItm varchar(25)
AS
/*
select @strItemSeq='1,2,3'
select @strOrderID = '''2004_000005'''
*/
Declare @str1 varchar(100)
declare @str2 varchar(200)
select @str1 = 'ITEM_SEQ_NO ' + 'in (' + @strItemSeq + ')'
select @str2 = 'DELETE FROM V_ORDER_ITM WHERE ' + @str1 + 'AND
FULFILMATRL_REQ_ID =' +''''+ @strOrderID +''''+ ''
exec (@str2)
GO
Thats it!! Once you delete the items later refresh/bind the datagrid so
that checked rows are no more existing.
Hope this will help you if not fully matches your requirement
Thanks & Regards,
Arshad
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/BDotNet/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you received
this message by mistake, please click the "Remove" link below. On the pre-addressed
e-mail message that opens, simply click "Send". Your e-mail address will be deleted
from this group's mailing list.
mailto:[EMAIL PROTECTED]
