.NET 数据库入门

首先需要url 设置

string url="Provider=SQLOLEDB;user id=**;password=***;initial catalog=****;server=**;connect timeout=60"

    Provider 指定数据库的 OLE DB 提供程序。例如，下面分别是 Access、SQL Server 和 Oracle 数据库的常用 OLE DB 提供程 序的参数：
    Provider=Microsoft.Jet.OLEDB.4.0;...
    Provider=SQLOLEDB;...

    Provider=OraOLEDB;...
    id为服务器登录名
    password为服务器登录密码
    catalog为数据库名字
    server服务器地址

OleDbConnection Connection = new OleDbConnection(url);

Connection.Open();

string sqlstr="SELECT * FROM TB_MeasurePoint";
OleDbDataAdapter oleDbAdapter = new OleDbDataAdapter(sqlstr, Connection);
OleDbCommandBuilder oleDbBuilder = new OleDbCommandBuilder(oleDbAdapter);
DataSet ds = new DataSet();
oleDbAdapter.Fill(ds);
Connection.Close();

OleDbConnection 类表示与数据源的开放连接。
OleDbCommand 类表示要对数据源执行的 SQL 语句或存储过程。
OleDbDataAdapter表示用于填充 DataSet 和更新数据源的一组数据命令和一个数据库连接

OleDbCommandBuilder 类自动生成用于协调所做的更改的单表命令 DataSet 与关联的数据库。 此类不能被继承

public static DataSet UpdateRows(string connectionString,
    string queryString, string tableName)
{
    DataSet dataSet = new DataSet();
    using (OleDbConnection connection = new OleDbConnection(connectionString))
    {
        OleDbDataAdapter adapter = new OleDbDataAdapter();
        adapter.SelectCommand = new OleDbCommand(queryString, connection);
        OleDbCommandBuilder cb = new OleDbCommandBuilder(adapter);

        connection.Open();

        adapter.Fill(dataSet, tableName);

        //code to modify data in DataSet here

        cb.GetDeleteCommand();
        //Without the OleDbCommandBuilder this line would fail
        adapter.Update(dataSet, tableName);

        connection.Close();
    }
    return dataSet;
}

public void ReadMyData(string connectionString)
{
    string queryString = "SELECT OrderID, CustomerID FROM Orders";
    using (OleDbConnection connection = new OleDbConnection(connectionString))
    {
        OleDbCommand command = new OleDbCommand(queryString, connection);
        connection.Open();
        OleDbDataReader reader = command.ExecuteReader();

        while (reader.Read())
        {
            Console.WriteLine(reader.GetInt32(0) + ", " + reader.GetString(1));
        }
        // always call Close when done reading.
        reader.Close();
    }
}

OleDbDataReader 类提供从数据源读取数据行的只进流的方法。

public static void ReadData(string connectionString, string queryString)
{
    using (OleDbConnection connection = new OleDbConnection(connectionString))
    {
        OleDbCommand command = new OleDbCommand(queryString, connection);

        connection.Open();
        OleDbDataReader reader = command.ExecuteReader();

        while (reader.Read())
        {
            Console.WriteLine(reader[0].ToString());
        }
        reader.Close();
    }
}