扫一扫
分享文章到微信
扫一扫
关注官方公众号
至顶头条
在本页阅读全文(共2页)
namespace IndiaStudyChannel.Utils
{
/**//// <summary>
/// Summary description for DataManager. /// </summary> /// 由 liudao 翻译整理
/// 该源码下载自www.51aspx.com(５１ａｓｐｘ．ｃｏｍ) public class DataManager { public DataManager() { } public static DataTable ExecuteQuery(string query) { string connectionString = System.Configuration.ConfigurationSettings.AppSettings["connectionString"]; SqlConnection connection = new SqlConnection(connectionString); connection.Open(); try { SqlDataAdapter adapter = new SqlDataAdapter(query, connection); DataSet ds = new DataSet(); adapter.Fill(ds); return ds.Tables[0]; } finally { if ( connection.State == ConnectionState.Open ) connection.Close(); } } public static void ExecuteNonQuery(string query) { string connectionString = System.Configuration.ConfigurationSettings.AppSettings["connectionString"]; SqlConnection connection = new SqlConnection(connectionString); connection.Open(); try { SqlCommand cmd = new SqlCommand(); cmd = connection.CreateCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = query; cmd.ExecuteNonQuery(); } finally { if ( connection.State == ConnectionState.Open ) connection.Close(); } } public static object ExecuteScalar(string query) { string connectionString = System.Configuration.ConfigurationSettings.AppSettings["connectionString"]; SqlConnection connection = new SqlConnection(connectionString); connection.Open(); //www.51aspx.com try { SqlCommand cmd = new SqlCommand(); cmd = connection.CreateCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = query; return cmd.ExecuteScalar(); } finally { if ( connection.State == ConnectionState.Open ) connection.Close(); } } }
}如果您非常迫切的想了解IT领域最新产品与技术信息，那么订阅至顶网技术邮件将是您的最佳途径之一。
京公网安备 11010802021500号