How to associate confirmation box with two radio buttons ??

D Dasawari

9y2.8k.NET

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.

10 Replies

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

Amar Srivastava9y ago
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 id,name,email,address 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=@text1,record2=@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("passyouruniqueid",RecordId);
            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 Dasawari9y ago
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 Srivastava9y ago

Update IX Status

CommandName="Select" Text="Submit">

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 Dasawari9y ago
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 Srivastava9y ago
Can you please giv me the html..

I will be good to explain this..

you can use this like
D Dasawari9y ago
i dont have idea about how to call it through selector as new one to programing field. Plz eleborate.
Amar Srivastava9y ago
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 Srivastava9y ago
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 Dasawari9y ago
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.
Amar Srivastava9y ago
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

/// 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..
   }
}