C# 访问数据库读取指定单元格数据 - 教程
首先,需要连接到数据库,可以使用 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 是查询条件。
原文地址: https://www.cveoy.top/t/topic/mXGW 著作权归作者所有。请勿转载和采集!