AbleCommerce Shopping Cart Software

Code: Select all

System.Data.Common.DbCommand dbCommand = Token.Instance.Database.GetStoredProcCommand("NameOfYourStoredProceedure");
        Token.Instance.Database.AddInParameter(dbCommand, "@value1", System.Data.DbType.Int32, 2331);
        
        //For Insert/Update/Delte you can use execute non-query like
        int affectedRows = Token.Instance.Database.ExecuteNonQuery(dbCommand);
        
        //For Query that returns only a single value
        Object returnedValue = Token.Instance.Database.ExecuteScalar(dbCommand);
        
        //For query that returns a tabular structure
        System.Data.DataSet resultSet = Token.Instance.Database.ExecuteDataSet(dbCommand);
        
        //For quer where you want a connected read only reqader
        using (System.Data.IDataReader dr = Token.Instance.Database.ExecuteReader(dbCommand))
        {
            while (dr.Read())
            { 
                //You can access every row of your returned data here
                int name = AlwaysConvert.ToString(dr["Name"]);
            }
            dr.Close();
        }