gridview row deletion using 3 conditions in where statement in asp.net

sathish kumar

14y3.9k.NET

hi friends...i want to delete particular row in gridview using three conditions in where statement .

Below is my source code. I used with DatakeyNames and deleted . But i want to give 2 more conditions . Based on those three conditions only i have to delete that particular row.

Below is mu source code.

Its urgent pls help me.....

CellPadding="4" ForeColor="#333333"

GridLines="None" onrowcommand="gvPO_RowCommand" EmptyDataText="No Items Added"

onrowdatabound="gvPO_RowDataBound" DataSourceID="SqlPurchaseBill"

Width="907px" Height="167px" OnRowDeleting="gvPO_RowDeleting"

ShowFooter="True">

CommandName="Delete" runat="server" OnClientClick="javascript:return confirm('Do you really want to \ndelete the item?');">

Delete

SortExpression="ITEMDESCRIPTION" />

SortExpression="BatchNo" />

HeaderText="ExpiryDate" HtmlEncode="false" SortExpression="ExpiryDate" />

SortExpression="TaxType" />

SortExpression="TaxScheme" />

Text='<%# Eval("VatPercentage")%>'>

SortExpression="VatOptions" />

ConnectionString="<%$ ConnectionStrings:CMC %>"

SelectCommand="SELECT ITEMCODE,ITEMDESCRIPTION,BatchNo,ExpiryDate,QTY,PackQTY,FreeQTY,StockQTY,TaxType,PURCHASERATE,MRP,TaxScheme,ITEMRATE,MRPRATE,DiscPer,DiscTotal,VATOn,VatPercentage,VatTotal,FreeVatAmt,MrpAbate,TotalAmount,VatOptions from [Temp_PurchaseBill] ORDER BY [ITEMDESCRIPTION]"

DeleteCommand="DELETE FROM [Temp_PurchaseBill] WHERE BatchNo=@BatchNo "

Above code is working . As i said earlier i want to give 3 conditions in that like below

DeleteCommand="DELETE FROM [Temp_PurchaseBill] WHERE BatchNo=@BatchNo " and ITEMDESCRIPTION=@ITEMDESCRIPTION" IPAddress=@IPAddress"

Its not working.....Help me pls

9 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sukesh Marla14y ago
Accepted answer
Please find attached sample i just created and testd and dont forget to check this is corect answer
Sukesh Marla14y ago
Its my pleasure dear, you cant use both words at the same time Brother and thank you.:)
sathish kumar14y ago
Hi brother...i gone through ur project...i got t idea...its working fine....thanks alot....thank u so much......

Thanks for ur support.....

Keep rocking...

May god bless you................
Sukesh Marla14y ago
2 things bro
1.i cant see any file attached
2.did u gone through the sample i attached.\

Check this is correct answer if it helped.
sathish kumar14y ago
hi brother ...i have attached my project with source code and database.....In PurchaseBill form i have to do that correction....help me please...its urgent
sathish kumar14y ago
that form and corresponding table is enough to send u???
Sukesh Marla14y ago
Just upload you source code with database and i will make corrected that step.
sathish kumar14y ago
could u pls send the exact code ??
Sukesh Marla14y ago
Please find the below code
SelectCommand="SELECT ITEMCODE,ITEMDESCRIPTION,BatchNo,ExpiryDate,QTY,PackQTY,FreeQTY,StockQTY,TaxType,PURCHASERATE,MRP,TaxScheme,ITEMRATE,MRPRATE,DiscPer,DiscTotal,VATOn,VatPercentage,VatTotal,FreeVatAmt,MrpAbate,TotalAmount,VatOptions from [Temp_PurchaseBill] ORDER BY [ITEMDESCRIPTION]"
DeleteCommand="DELETE FROM [Temp_PurchaseBill] WHERE BatchNo=@BatchNo ">

And in code behind you can simply use SqlPurchaseBill.Parameters.add mwthod to add parameters.

Check this is correct answer if it helped.