Custom Search

Ado.net

Coding in Asp.net MVC

Jul 3rd

Posted by julbx in ASP.net MVC

No comments

Its been more than 6 months now, I haven’t touch anything about C# MVC, I’ve been following asp.net mvc for 5 months, and I had created some web apps in my local drive, I have digested the concept of model-view-controller and transitioning to Zend Framework which is one of my current weapons right now is fast. Right now I have an Idea of a web application system that can give solution to project workflows and I want to deploy it in the cloud. I’ve done some UI design already and we are using it right now, although not automated since I just to the thing first in MS exel, but I want to deploy this system to the cloud because I find out that we have generated a very effective project management system here for project collaboration, even better than basecamp.

Well…. I still have a lot of projects to finish, I am targeting to finish my android game before the year ends, And still I haven’t find any resource that can be my reference on how to optimize java codes to run super fast in the Android Platfrom. The codes that I am using is super basic, and it cannot handle my game requirements, especially for animations.

I am very hungry already… have to go back home ASAP…. !!!!

, , ,

Sample Code for DataBaseHelper Class… Asp.net/C#

Nov 17th

Posted by julbx in ASP.net Framework

No comments

public class DataBaseHelper : DataAccessBase
    {
 
        private SqlParameter[ ] _parameters;
        public DataBaseHelper( string storedprocedurename )
        {
           
            StoredProcedureName = storedprocedurename;
        }
       
        public void Run( SqlTransaction transaction )
        {
            SqlHelper.ExecuteNonQuery( transaction , CommandType.StoredProcedure , StoredProcedureName , Parameters );
        }

        public void Run( SqlTransaction transaction , SqlParameter[] parameters )
        {
            SqlHelper.ExecuteNonQuery( transaction , CommandType.StoredProcedure , StoredProcedureName , parameters );
        }
   
        public DataSet Run( string connectionstring , SqlParameter[] parameters )
        {
            DataSet ds;
            ds = SqlHelper.ExecuteDataset( connectionstring ,StoredProcedureName , parameters );
            return ds;
        }
       
        public object RunScalar( string connectionstring , SqlParameter[] parameters )
        {
            object obj;
            obj = SqlHelper.ExecuteScalar( connectionstring ,
            StoredProcedureName , parameters );
            return obj;
        }
       
        public object RunScalar( SqlTransaction transaction , SqlParameter[] parameters )
        {
            object obj;
            obj = SqlHelper.ExecuteScalar( transaction , StoredProcedureName ,parameters );
            return obj;
        }
       
        public DataSet Run( string connectionstring )
        {
            DataSet ds;
            ds = SqlHelper.ExecuteDataset( connectionstring , CommandType.StoredProcedure , StoredProcedureName );
            return ds;
        }
       
        public void Run()
        {
            SqlHelper.ExecuteNonQuery( base.ConnectionString ,
            CommandType.StoredProcedure ,
            StoredProcedureName , Parameters );
        }
       
        public SqlDataReader Run( SqlParameter[] parameters )
        {
            SqlDataReader dr;
            dr = SqlHelper.ExecuteReader( base.ConnectionString , CommandType.StoredProcedure , StoredProcedureName , parameters );
            return dr;
        }
       
        public SqlParameter[] Parameters
        {
            get { return _parameters; }
            set { _parameters = value; }
        }
   
    }