- 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;
- }
- //该片段来自于http://www.codesnippet.cn/detail/130620133996.html
来源: http://www.codesnippet.cn/detail/130620133996.html