首先,需要连接到数据库,可以使用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/bt5J 著作权归作者所有。请勿转载和采集!

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