lvl3hdi
یک شنبه 04 بهمن 1394, 20:03 عصر
سلام
ممنون میشم این کد رو برام اررورشو بگین
button کار نمیکنه و با F10 می خوای بری پیدا نمیکنه و تو کش هم نمیره
try
{
if (CmbUseres.SelectedItem == "دانشجو")
{
if (connect.State == ConnectionState.Closed || connect.State == ConnectionState.Broken)
connect.Open();
SqlCommand scmd = new SqlCommand("select Password from [user] where Type= @type and UserName= @uName ", connect);
scmd.Parameters.AddWithValue("@uName", txtUser.Text);
scmd.Parameters.AddWithValue("@type", CmbUseres.Text);
int result = ((int)scmd.ExecuteScalar());
int pas = Convert.ToInt32(TxtPassword.Text);
if (pas == result)
{
FrmEducation frm = new FrmEducation();
frm.BtnSabtSTD.Enabled = false;
this.Hide();
MessageBox.Show("لطفا نام کاربری و رمز عبور معتبر را وارد کنید", "ERROR");
//frm.ShowDialog();
this.Close();
return;
}
else
{
TxtPassword.Clear();
MessageBox.Show(" صحیح نمیباشد Password ");
}
connect.Close();
}
else if (CmbUseres.SelectedItem == "استاد")
{
if (connect.State == ConnectionState.Closed || connect.State == ConnectionState.Broken)
connect.Open();
SqlCommand scmd = new SqlCommand("select Password from [user] where Type= @type and UserName= @uName ", connect);
scmd.Parameters.AddWithValue("@uName", txtUser.Text);
scmd.Parameters.AddWithValue("@type", CmbUseres.Text);
int result = ((int)scmd.ExecuteScalar());
int pas = Convert.ToInt32(TxtPassword.Text);
if (pas == result)
{
FrmEducation frm = new FrmEducation();
frm.ShowDialog();
}
else
{
TxtPassword.Clear();
MessageBox.Show(" صحیح نمیباشد Password ");
}
connect.Close();
}
else if (CmbUseres.SelectedItem == "آموزش")
{
if (connect.State == ConnectionState.Closed || connect.State == ConnectionState.Broken)
connect.Open();
SqlCommand scmd = new SqlCommand("select Password from [user] where Type= @type and UserName= @uName ", connect);
scmd.Parameters.AddWithValue("@uName", txtUser.Text);
scmd.Parameters.AddWithValue("@type", CmbUseres.Text);
int result = ((int)scmd.ExecuteScalar());
int pas = Convert.ToInt32(TxtPassword.Text);
if (pas == result)
{
FrmEducation frm = new FrmEducation();
frm.ShowDialog();
}
else
{
TxtPassword.Clear();
MessageBox.Show(" صحیح نمیباشد Password ");
}
connect.Close();
}
else if (CmbUseres.SelectedItem == "ریاست")
{
if (connect.State == ConnectionState.Closed || connect.State == ConnectionState.Broken)
connect.Open();
SqlCommand scmd = new SqlCommand("select Password from [user] where Type= @type and UserName= @uName ", connect);
scmd.Parameters.AddWithValue("@uName", txtUser.Text);
scmd.Parameters.AddWithValue("@type", CmbUseres.Text);
int result = ((int)scmd.ExecuteScalar());
int pas = Convert.ToInt32(TxtPassword.Text);
if (pas == result)
{
FrmEducation frm = new FrmEducation();
frm.ShowDialog();
}
else
{
TxtPassword.Clear();
MessageBox.Show(" صحیح نمیباشد Password ");
}
connect.Close();
}
}
catch (Exception exp)
{
MessageBox.Show(exp.Message.ToString());
txtUser.Clear();
TxtPassword.Clear();
MessageBox.Show("وارده اشتباه هستند UserName و Password ");
}
ممنون میشم این کد رو برام اررورشو بگین
button کار نمیکنه و با F10 می خوای بری پیدا نمیکنه و تو کش هم نمیره
try
{
if (CmbUseres.SelectedItem == "دانشجو")
{
if (connect.State == ConnectionState.Closed || connect.State == ConnectionState.Broken)
connect.Open();
SqlCommand scmd = new SqlCommand("select Password from [user] where Type= @type and UserName= @uName ", connect);
scmd.Parameters.AddWithValue("@uName", txtUser.Text);
scmd.Parameters.AddWithValue("@type", CmbUseres.Text);
int result = ((int)scmd.ExecuteScalar());
int pas = Convert.ToInt32(TxtPassword.Text);
if (pas == result)
{
FrmEducation frm = new FrmEducation();
frm.BtnSabtSTD.Enabled = false;
this.Hide();
MessageBox.Show("لطفا نام کاربری و رمز عبور معتبر را وارد کنید", "ERROR");
//frm.ShowDialog();
this.Close();
return;
}
else
{
TxtPassword.Clear();
MessageBox.Show(" صحیح نمیباشد Password ");
}
connect.Close();
}
else if (CmbUseres.SelectedItem == "استاد")
{
if (connect.State == ConnectionState.Closed || connect.State == ConnectionState.Broken)
connect.Open();
SqlCommand scmd = new SqlCommand("select Password from [user] where Type= @type and UserName= @uName ", connect);
scmd.Parameters.AddWithValue("@uName", txtUser.Text);
scmd.Parameters.AddWithValue("@type", CmbUseres.Text);
int result = ((int)scmd.ExecuteScalar());
int pas = Convert.ToInt32(TxtPassword.Text);
if (pas == result)
{
FrmEducation frm = new FrmEducation();
frm.ShowDialog();
}
else
{
TxtPassword.Clear();
MessageBox.Show(" صحیح نمیباشد Password ");
}
connect.Close();
}
else if (CmbUseres.SelectedItem == "آموزش")
{
if (connect.State == ConnectionState.Closed || connect.State == ConnectionState.Broken)
connect.Open();
SqlCommand scmd = new SqlCommand("select Password from [user] where Type= @type and UserName= @uName ", connect);
scmd.Parameters.AddWithValue("@uName", txtUser.Text);
scmd.Parameters.AddWithValue("@type", CmbUseres.Text);
int result = ((int)scmd.ExecuteScalar());
int pas = Convert.ToInt32(TxtPassword.Text);
if (pas == result)
{
FrmEducation frm = new FrmEducation();
frm.ShowDialog();
}
else
{
TxtPassword.Clear();
MessageBox.Show(" صحیح نمیباشد Password ");
}
connect.Close();
}
else if (CmbUseres.SelectedItem == "ریاست")
{
if (connect.State == ConnectionState.Closed || connect.State == ConnectionState.Broken)
connect.Open();
SqlCommand scmd = new SqlCommand("select Password from [user] where Type= @type and UserName= @uName ", connect);
scmd.Parameters.AddWithValue("@uName", txtUser.Text);
scmd.Parameters.AddWithValue("@type", CmbUseres.Text);
int result = ((int)scmd.ExecuteScalar());
int pas = Convert.ToInt32(TxtPassword.Text);
if (pas == result)
{
FrmEducation frm = new FrmEducation();
frm.ShowDialog();
}
else
{
TxtPassword.Clear();
MessageBox.Show(" صحیح نمیباشد Password ");
}
connect.Close();
}
}
catch (Exception exp)
{
MessageBox.Show(exp.Message.ToString());
txtUser.Clear();
TxtPassword.Clear();
MessageBox.Show("وارده اشتباه هستند UserName و Password ");
}