public string executeScaler(string commandText, bool isStoredProcedure, Dictionary <string, object> dictParams = null) { string result = ""; DataTable dt = new DataTable(); SqlConnection con = ConnectionStrings.GetConnection(); SqlCommand cmd = new SqlCommand(commandText, con); if (isStoredProcedure) { cmd.CommandType = CommandType.StoredProcedure; } if (dictParams != null) { foreach (KeyValuePair <string, object> rec in dictParams) { cmd.Parameters.AddWithValue("@" + rec.Key, rec.Value); } } try { result = Convert.ToString(cmd.ExecuteScalar()); } catch (Exception ex) { throw ex; } finally { con.Close(); con.Dispose(); } return(result); }