?? myconnection.cs
字號:
?using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.OleDb;
namespace 第四次實驗
{
class myClass
{
public OleDbConnection getConnect()
{
string MySqlCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\\Visual Studio 2005\\Projects\\C#\\第四次實驗\\第四次實驗\\database\\學生信息.mdb";
OleDbConnection myCon = new OleDbConnection(MySqlCon);
return myCon;
}
public void getCommon(string sqlLanguage)
{
OleDbConnection con = this.getConnect();
con.Open();
OleDbCommand cmd = new OleDbCommand(sqlLanguage, con);
cmd.ExecuteNonQuery();
cmd.Dispose();
con.Close();
con.Dispose();
}
public DataSet getDS(string sqlLanguage, string tableName)
{
OleDbConnection con = this.getConnect();
OleDbDataAdapter da = new OleDbDataAdapter(sqlLanguage, con);
DataSet myds = new DataSet();
da.Fill(myds, tableName);
return myds;
}
public OleDbDataReader getRead(string sqlLanguage)
{
OleDbConnection con = this.getConnect();
OleDbCommand cmd = new OleDbCommand(sqlLanguage, con);
con.Open();
OleDbDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
return dr;
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -