private bool validateall()
{
RequiredFieldValidator1.Validate();
RequiredFieldValidator2.Validate();
RequiredFieldValidator3.Validate();
RequiredFieldValidator4.Validate();
RequiredFieldValidator5.Validate();
RequiredFieldValidator6.Validate();
RequiredFieldValidator7.Validate();
RequiredFieldValidator8.Validate();
RequiredFieldValidator9.Validate();
RegularExpressionValidator1.Validate();
RegularExpressionValidator2.Validate();
RegularExpressionValidator3.Validate();
RegularExpressionValidator4.Validate();
RegularExpressionValidator5.Validate();
RegularExpressionValidator6.Validate();
RegularExpressionValidator7.Validate();
CompareValidator1.Validate();
CompareValidator2.Validate();
CompareValidator3.Validate();
if (!RequiredFieldValidator1.IsValid || !RequiredFieldValidator2.IsValid || !RequiredFieldValidator3.IsValid || !RequiredFieldValidator4.IsValid || !RequiredFieldValidator5.IsValid || !RequiredFieldValidator6.IsValid || !RequiredFieldValidator7.IsValid || !RequiredFieldValidator8.IsValid || !RequiredFieldValidator9.IsValid ||
!RegularExpressionValidator1.IsValid || !RegularExpressionValidator2.IsValid || !RegularExpressionValidator3.IsValid || !RegularExpressionValidator4.IsValid || !RegularExpressionValidator5.IsValid || !RegularExpressionValidator6.IsValid || !RegularExpressionValidator7.IsValid || !CompareValidator1.IsValid || !CompareValidator2.IsValid || !CompareValidator3.IsValid)
{
return(false);
}
return(true);
}
protected void TextBox2_TextChanged(object sender, EventArgs e)
{
RegularExpressionValidator7.Validate(); //유효성검사
if (RegularExpressionValidator7.IsValid) //텍스트박스 내용이 바뀔시 유효성 검사
{
string connectionString = @"server=(local)\SQLExpress;Integrated Security=true;database=db_user"; //서버에 연결
SqlConnection Con = new SqlConnection(connectionString);
// SPQ 선언
// SQL COMMAND OBJECT를 만들고 SQL COMMAND 넣기
SqlCommand Cmd = new SqlCommand();
Cmd.Connection = Con;
try
{
// SQL COMMAND 수행하기
Con.Open();
// ExecuteNonQuery()문은 CREATE, ALTER, DROP, INSERT, UPDATE, DELETE 문을 수행할때 사용
Cmd.CommandText = "SELECT id FROM db_user WHERE id = \'" + TextBox2.Text + "\'";
SqlDataReader reader = Cmd.ExecuteReader(); //select 한 값을 호출
if (reader.Read()) //Reader가 Read되면 들어감
{
Label1.Text = "중복 아이디가 존재합니다.";
}
else
{
Label1.Text = "";
}
Con.Close();
}
catch
{
}
}
else
{
}
}