sqldataadapter在powershell中不起作用

Add-Type -Path "C:\path\to\System.Data.dll"

# 设置数据库连接字符串
$connectionString = "Data Source=server_name;Initial Catalog=database_name;User ID=user_id;Password=password"

# 创建SqlConnection对象
$connection = New-Object System.Data.SqlClient.SqlConnection($connectionString)

# 打开数据库连接
$connection.Open()

# 创建SqlCommand对象
$command = $connection.CreateCommand()

# 设置SQL查询语句
$command.CommandText = "SELECT * FROM table_name"

# 创建SqlDataAdapter对象
$adapter = New-Object System.Data.SqlClient.SqlDataAdapter($command)

# 创建DataSet对象
$dataSet = New-Object System.Data.DataSet

# 使用DataAdapter填充DataSet
$adapter.Fill($dataSet)

# 关闭数据库连接
$connection.Close()

# 输出查询结果
$dataSet.Tables[0]