未使用vb和ms-access为命令对象设置命令文本

using System;
using System.Data;
using System.Data.SqlClient;

public class Program
{
    public static void Main()
    {
        // 创建命令对象
        SqlCommand command = new SqlCommand();

        // 设置连接字符串
        string connectionString = "Data Source=serverName;Initial Catalog=databaseName;User ID=userName;Password=password";

        // 创建数据库连接对象
        SqlConnection connection = new SqlConnection(connectionString);

        try
        {
            // 关联命令对象和连接对象
            command.Connection = connection;

            // 设置命令文本
            command.CommandText = "SELECT * FROM TableName";

            // 执行命令并处理结果
            connection.Open();
            SqlDataReader reader = command.ExecuteReader();
            while (reader.Read())
            {
                // 处理查询结果
            }
        }
        catch (Exception ex)
        {
            // 处理异常
        }
        finally
        {
            // 关闭连接
            connection.Close();
        }
    }
}