首先,需要连接到数据库,可以使用 SqlConnection 类来实现:

string connectionString = 'Data Source=YourServerName;Initial Catalog=YourDatabaseName;Integrated Security=True';
SqlConnection connection = new SqlConnection(connectionString);
connection.Open();

接着,使用 SqlCommand 类来执行查询语句,并使用 ExecuteScalar 方法来返回单个值:

string query = 'SELECT YourColumnName FROM YourTableName WHERE YourCondition';
SqlCommand command = new SqlCommand(query, connection);
object result = command.ExecuteScalar();

最后,关闭数据库连接:

connection.Close();

完整的代码示例如下:

string connectionString = 'Data Source=YourServerName;Initial Catalog=YourDatabaseName;Integrated Security=True';
SqlConnection connection = new SqlConnection(connectionString);
connection.Open();

string query = 'SELECT YourColumnName FROM YourTableName WHERE YourCondition';
SqlCommand command = new SqlCommand(query, connection);
object result = command.ExecuteScalar();

connection.Close();

其中,YourServerName、YourDatabaseName、YourColumnName 和 YourTableName 需要替换成实际的值,YourCondition 是查询条件。

C# 访问数据库读取指定单元格数据 - 教程

原文地址: https://www.cveoy.top/t/topic/mXGW 著作权归作者所有。请勿转载和采集!

免费AI点我,无需注册和登录