static public string GetSqlAsString(string sqlText,
SqlParameter[] sqlParameters,
string databaseConnectionString) {
string result = "";
SqlDataReader reader;
SqlConnection connection = new SqlConnection(databaseConnectionString);
using (connection) {
SqlCommand sqlcommand = connection.CreateCommand();
sqlcommand.CommandText = sqlText;
if (sqlParameters != null) {
sqlcommand.Parameters.AddRange(sqlParameters);
}
connection.Open();
reader = sqlcommand.ExecuteReader();
if (reader != null)
将开发过程较好的代码片段备份一次,如下资料是关于C#查询SqlServer数据库并返回单个值的代码,应该对各位朋友也有用。