How to associate confirmation box with two radio buttons ??

Question

please have a look attachment. One submit link button event is associated with two radio buttons named as Update IX and Replace IX. My query is based on only Replace IX. When I check the Replace IX button and followed by clicking on submit link button for replacing earlier history  new confirmation message box should come out like with text details as Are you sure to delete earlier history ?? and there should be Yes  No and cancle option on message box . If I click on yes button then sql delete command should be executed and nothing should not be done with NO and Cancle option. Please provide the sql query command for deleting data from only specific columns from two table as I mean not whole rows should be deleted. Please provide the solution for whole concept which is given.

Amar Srivastava · Answer

Hi I would start this answer with an simple example like //these line of code to be written on the server side.. including you script tag code with jquery cdn function checkToDelete(){ var checkstr = confirm('are you sure you want to delete this?'); if(checkstr == true){ $('#hdnWantDelete').val(true); return true; }else{ return false; } }); /// these below line of code to be write on the .cs page public void btn_Submit(Object sender EventArgs e) { var val = hdnWantDelete.Text; if(val == true) { //do your work.. } }

Amar Srivastava · Answer

As far as the deleting is concern you can not delete the few of the record of a row you can update them like if idnameemailaddress is there you want to delete the address just update the record with the update query to the database. protected void btnSubmit_Click(object sender EventArgs e) { var wantReplace = hdnWantDelete.Text; if(wantReplace == true) { //Call younewly created update for the Replace IX ReplaceSpecificRecord() } else { //do your work of the Update IX } } public void ReplaceSpecificRecord() { Try { conn.Open(); string SID = lblSID.Text; MySqlCommand cmd = new MySqlCommand(update tablename Set record1=@text1record2=@text2 record3=@text3 where id=@passyouruniqueid conn); cmd.Parameters.AddWithValue(@text1 textbox1.text); cmd.Parameters.AddWithValue(@text2 textbox2.text); cmd.Parameters.AddWithValue(@text3 textbox3.text); cmd.Parameters.AddWithValue(passyouruniqueidRecordId); cmd.ExecuteNonQuery(); cmd.Dispose(); ShowMessage(Data update Successfully......!); GridViewStudent.EditIndex = -1; BindGridView(); //Bind your grid view again here.. } catch (MySqlException ex) { ShowMessage(ex.Message); } Finally { conn.Close(); } } First modify the HTML as I have given and then modify the update method and submit method of the .cs page accrding to your need..

D Dasawari · Answer

What are the changes to be done in C# code for forwarding it to next step for deletion ?? Making the complete changes in given source codes as per my requirement then provide the same as attached file if possible. Thanks so much..

Amar Srivastava · Answer

Update IX Status CommandName=Select Text=Submit> $(#RadioButton4).click(function () { var checkstr = confirm('are you sure you want to delete this?'); debugger; if (checkstr == true) { $(#hdnWantDelete).val(true); return true; } else { return false; } }); function Confirm() { } If you have any query or want this popup on the submit please let me know I will try make this more clear for you will change the code accordingly

D Dasawari · Answer

Hi I am attaching code to make neccessary change for implementing same concept and also provide code to delete data from particular columns from both tables in sql server.

Amar Srivastava · Answer

Can you please giv me the html.. I will be good to explain this.. you can use this like $(#radioButtonId).click(function({ //call the function });)

D Dasawari · Answer

i dont have idea about how to call it through selector as new one to programing field. Plz eleborate.

Amar Srivastava · Answer

Simply remove the OnClientClick=checkToDelete() from the Submit button and paste this code in the radio button Replace IX which must be an server side control if not a server side control simple call this function using selector...

Amar Srivastava · Answer

Right D-Dasawari currently this is associated with the submit button you can simple change this by moving the code of OnClientClick=checkToDelete() to the Radio button Replace IX if the radio button is server side control else simple calling this function CheckToDelete by using the selector. Hope this will help

D Dasawari · Answer

If I add this delete confirmation event with submit button  confirmation will be associated with both radio button named as Update IX and Replace IX if m right. But I do not want any confirmation box with Update IX radio button. Project requirement is to associate confirmation box only with Replace IX radio. Plx provide code for same.