Method for C to query the SqlServer database and return a single value

This article illustrates how C # queries an SqlServer database and returns a single value. Share it for your reference. The specific implementation method is as follows:

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)
      if (reader.Read()) {
        result = reader.GetString(0);
      }
  }
  return result;
}

I hope this article is helpful to everyone's C # programming.