alen332
یک شنبه 07 شهریور 1389, 11:38 صبح
با سلام و ادب ؛ من يك مشكل دارم . فرم اوليه من صفحه LOGIN هست مي خوام وقتي درست LOGIN كردم (User ,Password) فرم مذكور بسته بشه و فرم ديگري باز بشه كد زير رو هم براش نوشتم ولي فرم اوليه (فرم login) بسته نمي شه يعني شرط if هول تو برنامه اجرا نمي شه
using System;
using System.Data;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data.SqlClient;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.IO;
using System.Data.OleDb;
namespace WindowsApplication1
{
public partial class Pass1 : Form
{
private const string _ConnectionString =
"Data Source=221-603107764\\SQLEXPRESS;Initial Catalog=pubs;Integrated Security=True";
public Pass1()
{
InitializeComponent();
}
public bool ValidateUserNamePassword(string _username, string _password)
{
SqlConnection objConnection;
objConnection = new SqlConnection(_ConnectionString);
SqlCommand cmd = new SqlCommand();
cmd.Connection = objConnection;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "reptq3";
SqlParameterCollection sqlParams = cmd.Parameters;
sqlParams.AddWithValue("@UserName", _username);
sqlParams.AddWithValue("@Password", _password);
objConnection.Open();
SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.SingleRow);
if (dr.Read())
{
// // this will return true if a row matching the username and password is found.
// // this means that the user's input is valid
return true;
}
else
{
return false;
}
dr.Close();
objConnection.Close();
}
private void button1_Click(object sender, EventArgs e)
{
string username = textBox1.Text;
string password = textBox2.Text;
if (ValidateUserNamePassword(username, password))
{
Pass1 pass = new Pass1();
pass.Close();
}
if (ValidateUserNamePassword(username, password))
{
Form1 f1 = new Form1();
f1.Show();
}
else
{
MessageBox.Show(" نام كاربر و يا كلمه عبور اشتباه است ", "خطاي ورود");
return;
}
}
private void button2_Click(object sender, EventArgs e)
{
this.Close();
}
}
}
using System;
using System.Data;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data.SqlClient;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.IO;
using System.Data.OleDb;
namespace WindowsApplication1
{
public partial class Pass1 : Form
{
private const string _ConnectionString =
"Data Source=221-603107764\\SQLEXPRESS;Initial Catalog=pubs;Integrated Security=True";
public Pass1()
{
InitializeComponent();
}
public bool ValidateUserNamePassword(string _username, string _password)
{
SqlConnection objConnection;
objConnection = new SqlConnection(_ConnectionString);
SqlCommand cmd = new SqlCommand();
cmd.Connection = objConnection;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "reptq3";
SqlParameterCollection sqlParams = cmd.Parameters;
sqlParams.AddWithValue("@UserName", _username);
sqlParams.AddWithValue("@Password", _password);
objConnection.Open();
SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.SingleRow);
if (dr.Read())
{
// // this will return true if a row matching the username and password is found.
// // this means that the user's input is valid
return true;
}
else
{
return false;
}
dr.Close();
objConnection.Close();
}
private void button1_Click(object sender, EventArgs e)
{
string username = textBox1.Text;
string password = textBox2.Text;
if (ValidateUserNamePassword(username, password))
{
Pass1 pass = new Pass1();
pass.Close();
}
if (ValidateUserNamePassword(username, password))
{
Form1 f1 = new Form1();
f1.Show();
}
else
{
MessageBox.Show(" نام كاربر و يا كلمه عبور اشتباه است ", "خطاي ورود");
return;
}
}
private void button2_Click(object sender, EventArgs e)
{
this.Close();
}
}
}