Confirm message while record save in web c#

Bhavesh Vankar

below is my code for record save in database but when i save record in being save without confirm message. i want to show first validation if any control is empty and when all the fields are filled and press save button confirm message should be fire and ask to save record. kidnly help me to solve this. where is error.

record directly being save without confrm message. i want to fire confirm message using code behind i have used validation control to validate all the fileds. i dont want to use javascrit confirm function. kindly suggest me c# code begind for the web application.

if (IsPostBack)
{
if (Page.IsValid)
{
string image = simagehidden.Value;
if (string.IsNullOrEmpty(image))
{
lblimgerror.Visible = true;
lblimgerror.Text = "*";
lblimgerror.ForeColor = System.Drawing.Color.Red;
}
else
{
var WebClient = new WebClient();
byte[] imgbytes = WebClient.DownloadData(image);
MemoryStream ms = new MemoryStream();
byte[] imgtobinary = new byte[ms.Length];
ms.Position = 0;
ms.Read(imgtobinary, 0, (int)ms.Length);
string _imgpath = Path.Combine(Server.MapPath("~/CroppedImage/" + DateTime.Now.ToString("dd-MM-yy")));
sImage.ImageUrl = _imgpath;
SqlConnection con = new SqlConnection(this.con);
SqlCommand cmd = new SqlCommand("studentrec_test", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@S_ID", TxtAutovID.Text);
cmd.Parameters.AddWithValue("@S_NAMEOFVISITOR", txtfname.Text + " " + txtmname.Text + " " + txtlname.Text);
cmd.Parameters.AddWithValue("@S_ADDRESS", txtaddress.Text);
cmd.Parameters.AddWithValue("@S_CITY", txtcity.Text);
cmd.Parameters.AddWithValue("@S_TALUKA", txttaluka.Text);
cmd.Parameters.AddWithValue("@S_DIST", txtdistric.Text);
cmd.Parameters.AddWithValue("@S_PINCODE", txtpincode.Text);
cmd.Parameters.AddWithValue("@S_GENDER", DDgender.SelectedItem.ToString());
cmd.Parameters.AddWithValue("@S_BIRTHDATE", txtbod.Text);
cmd.Parameters.AddWithValue("@S_IDTYPE", dropidtype.SelectedItem.ToString());
cmd.Parameters.AddWithValue("@S_IDREF", txtidno.Text);
cmd.Parameters.AddWithValue("@S_PHONE", txtphoneno.Text);
cmd.Parameters.AddWithValue("@S_AGE", txtage.Text);
cmd.Parameters.AddWithValue("@S_EMPDEPARTMENT", dropdepartment.SelectedItem.ToString());
cmd.Parameters.AddWithValue("@S_PURPOSE", txtpurpose.Text);
cmd.Parameters.AddWithValue("@S_TOMEET", txtmeet.Text);
cmd.Parameters.AddWithValue("@S_EMPDESIGNATION", dropdesignation.SelectedItem.ToString());
cmd.Parameters.AddWithValue("@S_BLOCKNO", txtblock.Text);
cmd.Parameters.AddWithValue("@S_FLOORNO", txtfloor.Text);
cmd.Parameters.AddWithValue("@S_VEHICLE", checkvehicale.Checked);
cmd.Parameters.AddWithValue("@S_VEHICLENO", txtvehicleno.Text);
cmd.Parameters.AddWithValue("@S_VEHICLETYPE", dropvehicletype.SelectedItem.ToString());
cmd.Parameters.AddWithValue("@S_IMAGE", imgtobinary);
string MainDir = @"~/StudentImage/";
String SubDir = DateTime.Now.ToString("dd-MM-yyyy");
if (!Directory.Exists(Server.MapPath(MainDir + SubDir + "/")))
{
Directory.CreateDirectory(Server.MapPath(MainDir + SubDir + "/"));
}
string imgname = (TxtAutovID.Text + ".jpg");
File.WriteAllBytes(Path.Combine(Server.MapPath(MainDir + SubDir), imgname), imgbytes);
cmd.Parameters.AddWithValue("@V_REMARKS", txtremark.Text);
cmd.Parameters.AddWithValue("@v_username", "user"/* Session["User"].ToString()*/);
cmd.Parameters.AddWithValue("@v_photoflag", true);
cmd.Parameters.AddWithValue("@v_gateno", "5");
ClientScriptManager CSM = Page.ClientScript;
if (ReturnValue())
{
string strconfirm = "";
CSM.RegisterClientScriptBlock(this.GetType(), "Confirm", strconfirm, true);
}
con.Open();
cmd.ExecuteNonQuery();
generateautonumber();
FillListBox();
sImage.ImageUrl = null;
ClearControls();
con.Close();
}
}
}

7 Replies

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

Sachin Singh5y ago
Accepted answer
okk i got your issue now
its very simple to fix it
just use group on validations some thing like
step 1. Add this script in your page
function validateAndConfirm(message){
   var validated = Page_ClientValidate('group1');
   if (validated){
      return confirm(message);
   }
}
step 2.Use Validation group in each validate control like
"TextBox1" runat="server"/>
     "group1"
                                                  ErrorText="Need to Fill in Value!"
                                                  ControlToValidate="TextBox1"
                                                  runat="server"/>

"TextBox2" runat="server"/>
      "group1"
                                                    ErrorText="Need to Fill in Value!"
                                                    ControlToValidate="TextBox2"
                                                    runat="server"/>
step 3. onclient click call the function
"btnSave" runat="server" CssClass="applybuttonstyle"
        Text="Save" onclick="btnSave_Click" ValidationGroup="group1"
        OnClientClick="return validateAndConfirm('Do you really want to save?');"/>
Bhavesh Vankar5y ago
i have one more issue...in my project one page for image capture by webcam. when i capture image and display it on image control. and if i click on ckechbox and select any data from combobox the image is gone. what to do in this case...?
Bhavesh Vankar5y ago
its really working fine.....thanks for your help....
Sachin Singh5y ago
importing windows.forms just for a dialog is obviously not convincing , if you are using more features of windows.Forms library then it is okay, but web application should be independent of such library , idk how messagbox gets converted to html and how browser understand it but asp.net must be doing some rendering when you use windows form's component.
Bhavesh Vankar5y ago
i have used window library and below code to confirm message and its working.....
kindly tell me can this cuase any problem in feature....?
using System.Windows.Forms;
DialogResult result = MessageBox.Show("Do You Want To Save Record.?", "Save Record.?", MessageBoxButtons.YesNo);
                 if (result == DialogResult.Yes)
                 {
                    this.ClientScript.RegisterStartupScript(this.GetType(), "Saved..", "alert('Record Has Been Saved...')", true);
                 }
                 else
                 {
                     return;
                 }
Bhavesh Vankar5y ago
i have used validation control to validate all fileds this code is exicute before validation controls. confirm message should not be appear without validate controls. i dont want to use javascript to validate controls. i this situation what to do....?

its working fine.... but message apear without validation controls.
Sachin Singh5y ago
you can only show alert from code behind and not the confirm , it creates a lot of complication to get the value return from confirm like yes or no.
And in your code you are not utilizing the confirm properly in both condition whether the user clicks on yes or no your ExecuteNonQuery() will always execute , then what is the point of a confirmation message??

seriously you are not utlizing the OnClientClick event , whatever you are doing is very old school way after asp.net 4.0 we really don't need to handle script from client side in most of the cases.

just change your button to
"return confirm('Are you sure, you want to continue?');" runat="server" id="btnTest" onclick="btnSave_Click" text="Click Here" xmlns:asp="#unknown" />
And now your code behind button click will only execute if the user clicks on ok otherwise your code behind code will not run.
what do you want more?