Asp.net button field not working as required

Question

1.00/5 (1 vote)

See more:

//I have this button of get owner's name in my form , but i'm unable to get it instead it gives the validation error messages , like i have used regular expression validation and so on.....//
//Problem is in Button3//

.aspxPage

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="add_fmember.aspx.cs" Inherits="housing1.WebForm5" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<style type="text/css">

.auto-style9 {
width: 341px;
text-align: center;
}
.auto-style31 {
width: 128px;
}
.auto-style10 {
width: 341px;
height: 26px;
text-align: center;
}
.auto-style32 {
height: 26px;
width: 128px;
}
.auto-style11 {
height: 26px;
}
.auto-style24 {
color: #FF0000;
}
.auto-style16 {
width: 341px;
text-align: center;
height: 23px;
}
.auto-style33 {
width: 128px;
height: 23px;
}
.auto-style13 {
height: 23px;
}

.auto-style8 {
width: 100%;
background-color: #CCFFFF;
}
.auto-style34 {
width: 182px;
}
</style>

<script type="text/javascript">

function myFunction() {

alert("You have exceeded the members entered");

}

</script>

<script>
function setAge1(d) {
var age1 = moment().diff(d, 'years');
$('#TextBoxA1').val(age1);
}

$(function () {
$('.manual1').change(function () {
setAge1(moment($(this).val()));
});
});
</script>
</head>
<body>
<form id="form1" runat="server">

Flat No

<asp:TextBox ID="TextBoxFN" runat="server" >

<asp:RequiredFieldValidator ID="RequiredFieldValidator21" runat="server" ControlToValidate="TextBoxFN" ErrorMessage="Flat No is Required" ForeColor="Red">

Primary Member Name	<asp:TextBox ID="TextBoxPMN" runat="server" >	<asp:Button ID="Button3" runat="server" OnClick="Button3_Click" Text="Get Owner's Name" />
First_Name	<asp:TextBox ID="TextBoxFN1" runat="server">	<asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ControlToValidate="TextBoxFN1" ErrorMessage="Name is Required" ForeColor="Red">
Middle_Name	<asp:TextBox ID="TextBoxMN1" runat="server">
Last_Name	<asp:TextBox ID="TextBoxLN1" runat="server">	<asp:RequiredFieldValidator ID="RequiredFieldValidator9" runat="server" ControlToValidate="TextBoxLN1" ErrorMessage="Last Name is Required" ForeColor="Red">
Mobile Number	<asp:TextBox ID="TextBoxMO1" runat="server">	<asp:RequiredFieldValidator ID="RequiredFieldValidator10" runat="server" ControlToValidate="TextBoxMO1" ErrorMessage="Mobile Number is Required" ForeColor="Red">
Email	<asp:TextBox ID="TextBoxE1" runat="server">	<asp:RegularExpressionValidator ID="RegularExpressionValidator2" runat="server" ControlToValidate="TextBoxE1" ErrorMessage="Invalid Email" ForeColor="Red" ValidationExpression="\w+([-+.']\w+)@\w+([-.]\w+)\.\w+([-.]\w+)*">
Date Of Birth	<asp:TextBox ID="TextBoxDOB1" runat="server" Class="manual1">	(dd/mm/yyyy)
Age	<asp:TextBox ID="TextBoxA1" runat="server">	<asp:RequiredFieldValidator ID="RequiredFieldValidator12" runat="server" ControlToValidate="TextBoxA1" ErrorMessage="Age is required" ForeColor="Red">
Educational Qualification	<asp:TextBox ID="TextBoxEQ1" runat="server">
Office Address	<asp:TextBox ID="TextBoxOA1" runat="server" TextMode="MultiLine">
Native Address	<asp:TextBox ID="TextBoxNA1" runat="server">	<asp:RequiredFieldValidator ID="RequiredFieldValidator17" runat="server" ControlToValidate="TextBoxNA1" ErrorMessage="Native Address is required" ForeColor="Red">
PAN Card Number	<asp:TextBox ID="TextBoxPCN1" runat="server">	<asp:RequiredFieldValidator ID="RequiredFieldValidator18" runat="server" ControlToValidate="TextBoxPCN1" ErrorMessage="PAN Card No Is Required" ForeColor="Red">
Aadhar Card Number	<asp:TextBox ID="TextBoxACN1" runat="server">	<asp:RequiredFieldValidator ID="RequiredFieldValidator19" runat="server" ControlToValidate="TextBoxACN1" ErrorMessage="Aadhar number is Required" ForeColor="Red">
Religion	<asp:TextBox ID="TextBoxR1" runat="server">	<asp:RequiredFieldValidator ID="RequiredFieldValidator20" runat="server" ControlToValidate="TextBoxR1" ErrorMessage="Religion is Mandatory" ForeColor="Red">
Business/Job	<asp:RadioButtonList ID="RadioButtonListBJ1" runat="server" RepeatDirection="Horizontal"> <asp:ListItem Value="Business">Business <asp:ListItem Value="Job">Job
Married/UnMarried	<asp:RadioButtonList ID="RadioButtonListMU1" runat="server" RepeatDirection="Horizontal" Width="171px"> <asp:ListItem Value="Married">Married <asp:ListItem Value="Unmarried">Unmarried
<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="ADD" />	<asp:Button ID="Button2" runat="server" OnClick="Button2_Click" Text="BACK" />

<asp:HyperLink ID="HyperLink1" runat="server" NavigateUrl="~/webform1.aspx">Go To Menu

</form>
</body>
</html>

.aspx.cs page

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Configuration;
using System.Data.SqlClient;
using System.Data;

namespace housing1
{
public partial class WebForm5 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

}

protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["HousingConnectionString"].ConnectionString);
conn.Open();
String select = "Select count(Primary_Name) from Family_Member where Flat='" + TextBoxFN.Text + "'";
SqlCommand com1 = new SqlCommand(select, conn);
String select1 = "Select No_Of_Members from Primary_Member where Flat='" + TextBoxFN.Text + "'";
SqlCommand com2 = new SqlCommand(select1, conn);
int b = Convert.ToInt32(com1.ExecuteScalar());
int a = Convert.ToInt32(com2.ExecuteScalar());
if (b == a)
{
//Response.Write(a);

ScriptManager.RegisterStartupScript(this, GetType(), "myFunction", "myFunction();", true);
}

else
{

try
{

String insertQuery1 = "insert into Family_Member ( Primary_Name , Flat ,First_Name , Middle_Name , Last_Name , Mobile_No , Email, DOB , Age , Education , Office_Add , Native_Add , PAN_Card , Aadhar_Card , Business_Job , Married_Unmarried) values( @prname , @flat , @fname , @mname , @lname , @mobile , @email , @dob , @age , @edu , @office_add , @native_add , @PAN , @Aadhar , @BJ , @MUm )";
SqlCommand com = new SqlCommand(insertQuery1, conn);
com.Parameters.AddWithValue("@prname", TextBoxPMN.Text);
com.Parameters.AddWithValue("@flat", TextBoxFN.Text);
com.Parameters.AddWithValue("@fname", TextBoxFN1.Text);
com.Parameters.AddWithValue("@mname", TextBoxMN1.Text);
com.Parameters.AddWithValue("@lname", TextBoxLN1.Text);
com.Parameters.AddWithValue("@mobile", TextBoxMO1.Text);
com.Parameters.AddWithValue("@email", TextBoxE1.Text);
com.Parameters.AddWithValue("@dob", TextBoxDOB1.Text);
com.Parameters.AddWithValue("@age", TextBoxA1.Text);
com.Parameters.AddWithValue("@edu", TextBoxEQ1.Text);
com.Parameters.AddWithValue("@office_add", TextBoxOA1.Text);
com.Parameters.AddWithValue("@native_add", TextBoxNA1.Text);
com.Parameters.AddWithValue("@PAN", TextBoxPCN1.Text);
com.Parameters.AddWithValue("@Aadhar", TextBoxACN1.Text);
com.Parameters.AddWithValue("@BJ", RadioButtonListBJ1.SelectedValue);
com.Parameters.AddWithValue("@MUm", RadioButtonListMU1.SelectedValue);

com.ExecuteNonQuery();
//ScriptManager.RegisterStartupScript(this, GetType(), "myFunction1", "myFunction()1;", true);

Response.Write("Data Updated Successfully");
// Response.Redirect("webform1.aspx?nom=" + TextBoxNOM.Text);

conn.Close();
}

catch (Exception ex)
{
Response.Write("Error" + ex.ToString());

}
}
}

protected void Button2_Click(object sender, EventArgs e)
{
TextBoxFN.Text = "";
TextBoxPMN.Text = "";
TextBoxFN1.Text = "";
TextBoxMN1.Text = "";
TextBoxLN1.Text = "";
TextBoxMO1.Text = "";
TextBoxE1.Text = "";
TextBoxDOB1.Text = "";
TextBoxA1.Text = "";
TextBoxE1.Text = "";
TextBoxOA1.Text = "";
TextBoxNA1.Text = "";
TextBoxPCN1.Text = "";
TextBoxACN1.Text = "";
TextBoxEQ1.Text = "";
TextBoxR1.Text = "";
RadioButtonListBJ1.SelectedIndex = -1;
RadioButtonListMU1.SelectedIndex = -1;
}

protected void Button3_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["HousingConnectionString"].ConnectionString);
conn.Open();

String str = "select First_Name from Primary_Member where Flat='" + TextBoxFN.Text.Trim() + "'";
SqlCommand comm = new SqlCommand(str, conn);
SqlDataReader reader = comm.ExecuteReader();
if (reader.Read())
{
TextBoxPMN.Text = reader["First_Name"].ToString();
reader.Close();
}

}
}
}

Posted 18-Oct-15 22:08pm

Member 12049271

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

$*Developer - Vaibhav*$ · Answer 1 · 2015-10-18T22:38:00

Solution 1

You need define validation group

validationgroup=""

Ref
https://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.button.validationgroup(v=vs.110).aspx[^]

https://msdn.microsoft.com/en-us/library/ms227424.aspx[^]

Posted 18-Oct-15 22:38pm

$*Developer - Vaibhav*$

Updated 18-Oct-15 22:42pm

v2