aliramazani
جمعه 26 فروردین 1390, 14:51 عصر
یه فرمی درست کردم که از دیتابیس یوزرنیم و ÷سورد را چک کنه و اگه درست بود پیغام خوش آمد بگه
کار نمی کنه اشکالش چیه؟
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace lab
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
////////////////////////////////////////
private bool CompareStrings(string string1, string string2)
{
return String.Compare(string1, string2, true, System.Globalization.CultureInfo.InvariantCulture) == 0 ? true : false;
}
////////////////////////////////////////
private void button1_Click(object sender, EventArgs e)
{
SqlConnection UGIcon = new SqlConnection();
UGIcon.ConnectionString = "Server=.\\SQLEXPRESS; Database=lab; User Id=; password=";
UGIcon.Open();
SqlCommand cmd = new SqlCommand("SELECT ISNULL(username, '') AS username, ISNULL(password,'') AS password, ISNULL(role,'') AS role FROM users WHERE username='" + textBox1.Text + "' and password='" + textBox2.Text + "'", UGIcon);
SqlDataReader dr = cmd.ExecuteReader();
string userText = textBox1.Text;
string passText = textBox2.Text;
string role = "admin";
while (dr.Read())
{
if (this.CompareStrings(dr["username"].ToString(), userText) &&
this.CompareStrings(dr["password"].ToString(), passText) &&
this.CompareStrings(dr["role"].ToString(), role))
{
MessageBox.Show("OK");
}
else
{
MessageBox.Show("Error");
}
}
dr.Close();
UGIcon.Close();
}
catch(Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
کار نمی کنه اشکالش چیه؟
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace lab
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
////////////////////////////////////////
private bool CompareStrings(string string1, string string2)
{
return String.Compare(string1, string2, true, System.Globalization.CultureInfo.InvariantCulture) == 0 ? true : false;
}
////////////////////////////////////////
private void button1_Click(object sender, EventArgs e)
{
SqlConnection UGIcon = new SqlConnection();
UGIcon.ConnectionString = "Server=.\\SQLEXPRESS; Database=lab; User Id=; password=";
UGIcon.Open();
SqlCommand cmd = new SqlCommand("SELECT ISNULL(username, '') AS username, ISNULL(password,'') AS password, ISNULL(role,'') AS role FROM users WHERE username='" + textBox1.Text + "' and password='" + textBox2.Text + "'", UGIcon);
SqlDataReader dr = cmd.ExecuteReader();
string userText = textBox1.Text;
string passText = textBox2.Text;
string role = "admin";
while (dr.Read())
{
if (this.CompareStrings(dr["username"].ToString(), userText) &&
this.CompareStrings(dr["password"].ToString(), passText) &&
this.CompareStrings(dr["role"].ToString(), role))
{
MessageBox.Show("OK");
}
else
{
MessageBox.Show("Error");
}
}
dr.Close();
UGIcon.Close();
}
catch(Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}