请问下大家有好的WEB开发的C#.net的一些对数据库操作常用的代码吗?

Question

比如对sql的增,删,改,查的语句和有关基存储过程的代码
还有就是针对一般aspx新闻系统的常用代码,谢谢高手了,学习了!

Answer 1

请高手帮忙啊,我的邮箱是443205231@com谢谢高手了!

Answer 2

那关于aspx新闻系统的常用代码呢,是怎么弄的啊?有好的代码吗?谢谢啦

Answer 3

//DbAccess 
public static DataSet FillDataSet(string sql, SqlConnection dbConn)
        {            
            DataSet result = new DataSet();
            SqlCommand cmd = new SqlCommand(sql, dbConn);
            SqlDataAdapter adapter = new SqlDataAdapter(cmd);
            try
            {
                DataBaseConn.OpenConn(dbConn);
                adapter.Fill(result);
                DataBaseConn.CloseConn(dbConn);
            }
            catch(Exception ex)
            {
                ExceptionUtil.DoException(sql + ex.Message + ex.StackTrace);
            }            
            return result;
        }        public static object ExecuteScalar(string sql, SqlConnection dbConn)
        {
            SqlCommand cmd = new SqlCommand(sql, dbConn);
            object result = null;
            DataBaseConn.OpenConn(dbConn);
            try
            {                
                result = cmd.ExecuteScalar();
            }
            catch (Exception ex)
            {
                ExceptionUtil.DoException(ex);
            }
            DataBaseConn.CloseConn(dbConn);
            return result;
        }        public static int ExecuteNonQuery(string sql, SqlConnection dbConn)
        {
            SqlCommand cmd = new SqlCommand(sql, dbConn);
            int result = 0;
            DataBaseConn.OpenConn(dbConn);
            try
            {                result = cmd.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
                ExceptionUtil.DoException(ex);
            }
            DataBaseConn.CloseConn(dbConn);
            return result;
        }        public static SqlDataReader ExecuteReader(string sql, SqlConnection dbConn)
        {
            SqlCommand cmd = new SqlCommand(sql, dbConn);
            SqlDataReader result = null;
            DataBaseConn.OpenConn(dbConn);
            try
            {
                result = cmd.ExecuteReader();
            }
            catch (Exception ex)
            {
                ExceptionUtil.DoException(ex);
            }
            DataBaseConn.CloseConn(dbConn);
            return result;
        }//DbConnection#region CreateConn
        public static SqlConnection CreateConn(string connStr)
        {
            SqlConnection conn;
            try
            {
                 conn = new SqlConnection(connStr);
            }
            catch (Exception ex)
            {
                conn = null;
                ExceptionUtil.DoException(ex);                
            }
            return conn;
        }        //public static SqlConnection CreateConn()
        //{
        //    return CreateConn(Global.ConnStr);
        //}
        #endregion        #region OpenConn
        public static void OpenConn(SqlConnection conn)
        {
            try
            {
                if (conn.State == ConnectionState.Closed)
                {
                    conn.Open();
                }
            }
            catch (Exception ex)
            {
                conn = null;
                ExceptionUtil.DoException(ex);
            }
        }        //public static void OpenConn()
        //{
        //    OpenConn(Global.DbConn);
        //}
        #endregion        #region CloseConn
        public static void CloseConn(SqlConnection conn)
        {
            try
            {
                if (conn.State == ConnectionState.Open)
                {
                    conn.Close();
                    //conn.Dispose();
                }
            }
            catch (Exception ex)
            {
                ExceptionUtil.DoException(ex);
            }
        }        //public static void CloseConn()
        //{
        //    CloseConn(Global.DbConn);
        //}
        #endregion