如何在C#中设置ADODB连接属性

using ADODB;

Connection connection = new Connection();

string connectionString = "Provider=SQLOLEDB;Data Source=服务器地址;Initial Catalog=数据库名称;User ID=用户名;Password=密码;";

connection.Properties["Timeout"].Value = 30; // 设置连接超时时间为30秒
connection.Properties["Mode"].Value = 1; // 设置连接模式为读写模式
connection.Properties["CursorLocation"].Value = CursorLocationEnum.adUseClient; // 设置游标位置为客户端

connection.Open(connectionString);

using ADODB;

class Program
{
    static void Main()
    {
        Connection connection = new Connection();
        string connectionString = "Provider=SQLOLEDB;Data Source=服务器地址;Initial Catalog=数据库名称;User ID=用户名;Password=密码;";

        connection.Properties["Timeout"].Value = 30;
        connection.Properties["Mode"].Value = 1;
        connection.Properties["CursorLocation"].Value = CursorLocationEnum.adUseClient;

        connection.Open(connectionString);

        // 连接已打开，可以执行数据库操作

        connection.Close();
    }
}