Hello I have to delete the records in a SQL server. For that please refer to my code. You will understand what I am doing. When I hit img. It gives me confirm message. Do you want to delete. I say no. It doesnot delete when I say yes. The values in text boxes remains unchanged. Can you please modify the code? Thanks your reponse will be appreciated.
  <%if Request.Form("txtMode")="A" then
     strGrid =strGrid+ " <TD><INPUT type=""text"" size=15 id=AtxtdateFrom name=AtxtdateFrom ></TD>"
     strGrid =strGrid+ " <TD><INPUT type=""text"" size=15 id=AtxtdateUntil name=AtxtdateUntil ></TD>"
     strGrid =strGrid+ " <TD><INPUT type=""text"" size=15 id=AtxtHourlyRate name=AtxtHourlyRate ></TD>"
     strGrid =strGrid+ " <TD ><img type =""button"" name=btnDelete src ='../images/xDel1.gif' onclick=""javascript:deleteConfirm();""></TD></TR>"
 end if

Do while not objHistoryRate.EOF

    dateFrom =cstr(convNull (objHistoryRate("dtRateFrom")))
    dateUntil=cstr(convNull (objHistoryRate("dtRateTo")))
    HourlyRate=cstr(convNull(objHistoryRate("decHourly Rate")))

    strGrid =strGrid+ " <TD><INPUT type=""text"" size=15 id=txtdateFrom name=txtdateFrom value='"+ dateFrom +" ' ></TD>"
    strGrid =strGrid+ " <TD><INPUT type=""text"" size=15 id=txtdateUntil name=txtdateUntil value='"+ dateUntil+" '></TD>"
    strGrid =strGrid+ " <TD><INPUT type=""text"" size=15 id=txtHourlyRate name=txtHourlyRate value='"+HourlyRate+" '></TD>"
    strGrid =strGrid+ " <TD ><img type =""button"" name=btnDelete src ='../images/xDel1.gif' onclick=""javascript:deleteConfirm();""></TD></TR>"
    objHistoryRate.MoveNext()

loop
strGrid = strGrid + "</Tr></TABLE>"
Response.Write(strGrid)
%>
<script language = javascript>
    function deleteConfirm() {
      if (confirm("You are about to " +
           "delete a record into the database." +
           "Click ok to continue or Cancel to abort.")){
             return true; }
      else {
             alert("Record not deleted")
              return false;}

          document.thisForm.submit();
     }
     </script>

Why is that you are using INPUT boxes when you want to delete records? By doing that you are complicating the operation.

Also I don't see you execute DELETE statement anywhere in your code.

Cheers!

_________________________
- Vijay G
Strive for Perfection

How will I modify the code?

Hi Shoakat,

Not sure, if I can give you the entire code. But I can show you how to go about that. You can try to code with this logic. Always you can come back here for help if you are stuck up somewhere with some error.

Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection

I dont have to use the check Box. I have to use an arrow corresponding to each row that when i click asks the user whether he should delete the corresponding row. If yes it should delete the corresponding row.
I believe arrays are required to solve this problem. If you can see my code. You will realize where to modify

Hi Shoakat,

This way as you mentioned in your previous post, you could let the user delete just one row at a time, suppose if the user wishes to delete 5 consecutive rows, he has to click 5 times on each of those ARROW which you provide for delete. Instead in the other post which I had posted the logic, it would let you select multiple rows at a time per page and on one click it would delete all the selected rows. Not decision is yours, to go with whichever you prefer. And you can code it to that effect. You can try coding on that, and post here always to get any help if you are stuck up in the middle with some errors.

Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection

Actually in my assignment. I have to limit the user to delete a single row at a time. My update also
doesnot work. When the user changes number. In data base there is no update. Suppose the user
updates the record in the middle.In database it only gives the value of the last text box. I I change the
value of the last text box. It update all the text box to that value. Please help me as I assignment
is due tomorrow

Hi,

You will have to provide backend details for the same, like what is the primary key field on that table. Does it submit the form details onclick of any delete button? If not it should. I still don't see any necessity for using INPUT boxes, when you have to delete the records. Is that you are using the same page for Insert/Update/Delete operations?

Cheers!

_________________________
- Vijay G
Strive for Perfection

Yes I am using the same page for update,delete,and add. Try to look at the code. You will
understand what am I doing. As I told you earlier, my assignment is due today. I will appreciate
your reply earnest.

But you haven't mentioned about the table structure and primary key field if any.

_________________________
- Vijay G
Strive for Perfection