c# 数据库连接
来源:百度知道 编辑:UC知道 时间:2024/05/10 05:23:08
连接数据库一般都写在Page_Load()事件中,这样有利于重用。当然在其他的事件比如form_load,Button_Onclick()都可以写,这要看具体的情况。不过,一般还是建议写在Page_load()事件中会比较好。
OleDbConnection MyConn;
string MyConnString = "Provider=SQLOLEDB; Data Source=localhost; Initial Catalog=work; User ID=sa; Password= ;";
MyConn = new OleDbConnection(MyConnString);
MyConn.Open();
string conn = "select * from staff where user_name='" + username.Text + "'";
OleDbCommand dbComm = new OleDbCommand(conn, MyConn);
OleDbDataReader dr = dbComm.ExecuteReader();
//string susername,spassword = null;
// susername = this.username.Text;
// spassword = this.password.Text; // ----------- 获取值 -----------
//string myusername, mypassword = null;
// myusername = dr["user_name"].ToString();
// mypassword = dr["pass