程序師世界是廣大編程愛好者互助、分享、學習的平台,程序師世界有你更精彩!
首頁
編程語言
C語言|JAVA編程
Python編程
網頁編程
ASP編程|PHP編程
JSP編程
數據庫知識
MYSQL數據庫|SqlServer數據庫
Oracle數據庫|DB2數據庫
 程式師世界 >> 編程語言 >> 更多編程語言 >> 更多關於編程 >> winform-數據庫連接

winform-數據庫連接

編輯:更多關於編程

       1.啟動服務:sql server 配置

      2.windows驗證進入sql server-安全-sa-改密碼;

      3.新建數據庫booksystem;

      4.public partial class Form1 : Form

      {

      SqlConnection conn;

      public Form1()

      {

      InitializeComponent();

      }

      private void btnLogin_Click(object sender, EventArgs e)

      {

      try

      {

      conn.Open();

      MessageBox.Show(conn.State.ToString());

      }

      catch (Exception ex)

      {

      //友好提示

      MessageBox.Show(ex.Message);

      //throw ex;

      }

      finally {

      conn.Close();

      MessageBox.Show(conn.State.ToString());

      }

      }

      private void Form1_Load(object sender, EventArgs e)

      {

      conn = new SqlConnection("server=.;database=booksystem;uid=sa;pwd=sa");

      }

      }

      5.sql

      //String sqlStr = "select * from admin where admName='lyc' and admPwd='123'";

      //Trim()去掉兩邊的空格

      String sqlStr = @"select * from admin

      where admName='" + this.txtName.Text.Trim() + "' and admPwd='" + this.txtPwd.Text.Trim() + "'";

      cmd = new SqlCommand(sqlStr, conn);

      conn.Open();

      //object obj=cmd.ExecuteScalar();

      try

      {

      //

      Int32 count = (Int32)cmd.ExecuteScalar();

      //int count = (int)cmd.ExecuteScalar();

      MessageBox.Show("正確");

      }

      catch (Exception ex)

      {

      MessageBox.Show("用戶名密碼不正確");

      //throw ex;

      }

      finally {

      conn.Close();

      }

    1. 上一頁:
    2. 下一頁:
    Copyright © 程式師世界 All Rights Reserved