- 声明变量ConnetionString和 QueryString,并代入初始值。
- try(CN.open())
- 用new实例化各系统类
- 用DA直接Fill到DataTable(*也可以到Dataset)
- if条件比较+执行语句
- catch (Exception ex)
- finally(CN.close(),以防中途报错而无法重载)
例(登录界面用户名密码确认):
using System.Windows.Forms;
using System.Data.SqlClient;
public static String LoginID, LoginPW, pass;
public string CNString, QString;
DataRow DR;
private void Button1_Click(object sender, EventArgs e)
{
LoginID = textBox1.Text;
LoginPW = textBox2.Text;
SqlConnection CN = new SqlConnection(CNString);
CNString = "Data Source=...;Initial Catalog=...;Integrated Security=True";
QString = "Select * from dbo.staffs where Emailaddress = '" + LoginID + "'or Telnumber ='" + LoginID + "' or ID='" + LoginID + "' union " + "Select * from dbo.users where Emailaddress = '" + LoginID + "'or Telnumber ='" + LoginID + "' or ID='" + LoginID + "';";
try
{
CN.Open();
DataSet DS = new DataSet();
SqlCommand CM = new SqlCommand(QString, CN);
SqlDataAdapter DA = new SqlDataAdapter(CM);
DataTable DT = new DataTable();
DA.Fill(DT);
DataRow[] DR = DT.Select();
var pass = DR[0]["Mypassword"].ToString();
if (LoginPW == pass)
{
MessageBox.Show("ログインできました");
this.Hide();
Mainpage frm = new Mainpage();
frm.Show();
}
else
{
MessageBox.Show("ログインIDもしくはパスワードは正しくありません");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
if (CN.State == ConnectionState.Open)
{
CN.Close();
}
}
}
}
}