data saving while validation is occur

string image = vimagehidden.Value;
//if (!string.IsNullOrEmpty(image))
if (image !="")
{
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")));
vImage.ImageUrl = _imgpath;
SqlConnection con = new SqlConnection(this.con);
SqlCommand cmd = new SqlCommand("student_test", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@S_ID", TxtAutovID.Text);
cmd.Parameters.AddWithValue("@S_NAMEOFSTUDENT", 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 = (DateTime.Now.ToString("dd-MM-yy HH-mm") + ".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");
con.Open();
cmd.ExecuteNonQuery();
generateautonumber();
FillListBox();
vImage.ImageUrl = null;
image = "";
ClearControls();
//Response.Write("

9 Replies

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

Sachin Singh5y ago
Accepted answer
yes
it is very clear that you are not using page.IsValid property before saving the record so how the validation will work.
+2
Bhavesh Vankar5y ago
1. string image = vimagehidden.Value;
2. //if (!string.IsNullOrEmpty(image))
3. if (image !="")
4. {
5. var WebClient = new WebClient();
6. byte[] imgbytes = WebClient.DownloadData(image);
7. MemoryStream ms = new MemoryStream();
8. byte[] imgtobinary = new byte[ms.Length];
9. ms.Position = 0;
10. ms.Read(imgtobinary, 0, (int)ms.Length);
12. string _imgpath = Path.Combine(Server.MapPath("~/CroppedImage/" + DateTime.Now.ToString("dd-MM-yy")));
13. vImage.ImageUrl = _imgpath;
14. SqlConnection con = new SqlConnection(this.con);
15. SqlCommand cmd = new SqlCommand("student_test", con);
16. cmd.CommandType = CommandType.StoredProcedure;
17. cmd.Parameters.AddWithValue("@S_ID", TxtAutovID.Text);
18. cmd.Parameters.AddWithValue("@S_NAMEOFSTUDENT", txtfname.Text + " " + txtmname.Text + " " + txtlname.Text);
19. cmd.Parameters.AddWithValue("@S_ADDRESS", txtaddress.Text);
20. cmd.Parameters.AddWithValue("@S_CITY", txtcity.Text);
21. cmd.Parameters.AddWithValue("@S_TALUKA", txttaluka.Text);
22. cmd.Parameters.AddWithValue("@S_DIST", txtdistric.Text);
23. cmd.Parameters.AddWithValue("@S_PINCODE", txtpincode.Text);
24. cmd.Parameters.AddWithValue("@S_GENDER", DDgender.SelectedItem.ToString());
25. cmd.Parameters.AddWithValue("@S_BIRTHDATE", txtbod.Text);
26. cmd.Parameters.AddWithValue("@S_IDTYPE", dropidtype.SelectedItem.ToString());
27. cmd.Parameters.AddWithValue("@S_IDREF", txtidno.Text);
28. cmd.Parameters.AddWithValue("@S_PHONE", txtphoneno.Text);
29. cmd.Parameters.AddWithValue("@S_AGE", txtage.Text);
30. cmd.Parameters.AddWithValue("@S_EMPDEPARTMENT", dropdepartment.SelectedItem.ToString());
31. cmd.Parameters.AddWithValue("@S_PURPOSE", txtpurpose.Text);
32. cmd.Parameters.AddWithValue("@S_TOMEET", txtmeet.Text);
33. cmd.Parameters.AddWithValue("@S_EMPDESIGNATION", dropdesignation.SelectedItem.ToString());
34. cmd.Parameters.AddWithValue("@S_BLOCKNO", txtblock.Text);
35. cmd.Parameters.AddWithValue("@S_FLOORNO", txtfloor.Text);
36. cmd.Parameters.AddWithValue("@S_VEHICLE", checkvehicale.Checked);
37. cmd.Parameters.AddWithValue("@S_VEHICLENO", txtvehicleno.Text);
38. cmd.Parameters.AddWithValue("@S_VEHICLETYPE", dropvehicletype.SelectedItem.ToString());
39. cmd.Parameters.AddWithValue("@S_IMAGE", imgtobinary);
41. string MainDir = @"~/STUDENTIMAGE/";
42. String SubDir = DateTime.Now.ToString("dd-MM-yyyy");
44. if (!Directory.Exists(Server.MapPath(MainDir + SubDir + "/")))
45. {
46. Directory.CreateDirectory(Server.MapPath(MainDir + SubDir + "/"));
47. }
48. string imgname = (DateTime.Now.ToString("dd-MM-yy HH-mm") + ".jpg");
49. File.WriteAllBytes(Path.Combine(Server.MapPath(MainDir + SubDir), imgname), imgbytes);
51. cmd.Parameters.AddWithValue("@V_REMARKS", txtremark.Text);
52. cmd.Parameters.AddWithValue("@v_username", "user"/* Session["User"].ToString()*/);
53. cmd.Parameters.AddWithValue("@v_photoflag", true);
54. cmd.Parameters.AddWithValue("@v_gateno", "5");
55. con.Open();
56. cmd.ExecuteNonQuery();
57. generateautonumber();
58. FillListBox();
59. vImage.ImageUrl = null;
60. image = "";
61. ClearControls();
62. //Response.Write("