tag:blogger.com,1999:blog-30338652870712697332024-03-04T22:43:50.623-08:00Maxybyte TechnologiesCodes that solve algorithmic programming problemsUnknownnoreply@blogger.comBlogger38125tag:blogger.com,1999:blog-3033865287071269733.post-68145664506729948422023-02-23T09:27:00.005-08:002023-09-11T09:06:51.818-07:00New style string formatting in PythonIn this section, you will learn the usage of the new style formatting.Learn more here.Python 3 introduced a new way to do string formatting that was also later back-ported to Python 2.7. This “new style” string formatting gets rid of the modulo-operator special syntax and makes the syntax for string formatting more regular.Formatting is now handled by calling .format() on a string object.YouUnknownnoreply@blogger.com0tag:blogger.com,1999:blog-3033865287071269733.post-59820520268835706372021-08-22T06:22:00.016-07:002023-09-11T09:09:29.956-07:00Create Store proceduresStore procedure has some similarities with views in the sense that it allows encapsulation. i.e. to retrieve for further, later use a series of commands, like the select command.Learn Python here.With store procedure, it is possible to branch. It means you can get different statements to run based on specific requirements.The begin and the end is compulsory in store procedure as it Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-3033865287071269733.post-20129716333761495782021-08-17T03:51:00.010-07:002022-04-17T01:38:25.082-07:00How to use IsNull in T-SQLEnjoy the ongoing promo:Python Intermediate Features Course On UdemyThe IsNull method is a built-in function that takes two parameters.
The first parameter is the expression or variable that the IsNull method checks and returns true if the variable contains Null.
The second parameter is the replacement value that the IsNull method returns if the expression is Null.Below is an instance of a tableUnknownnoreply@blogger.com0tag:blogger.com,1999:blog-3033865287071269733.post-90576479683840092422021-08-08T10:16:00.019-07:002021-08-09T06:08:52.351-07:00Creating an AFTER triggerTo understand what the trigger is, see it as automation. It fires whenever an event occurs.A good example is an automated email that is sent out whenever someone submitted a form or registered to a website.Trigger in SQL server act the same way. It is activated based on certain conditions.We will use the table tblStudent below to explain the trigger.You can read how to create this table Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-3033865287071269733.post-50418209686665297462021-08-04T02:16:00.018-07:002021-08-25T07:35:01.837-07:00Difference between Delete and TruncateDeleteRemoves the records and remember the last primary key of the removed records.This will allow the next records that will be inserted to start from the next number of the last deleted record.For instance, if you create a table tblStudent with two columns:Step 1Create table tblStudent(StudentNumber int Constraint PK_tblStudent PRIMARY KEY IDENTITY(1,1),StudentName nvarchar(20))StudentNumber - Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-3033865287071269733.post-48763886004419383492021-07-26T02:42:00.009-07:002021-07-27T09:06:01.184-07:00TSQL-Working With Date And TimeHere you will learn how to work with the date and time in SQL Server.select GETDATE() as dateNowThis returns the current date and time.select CURRENT_TIMESTAMP as dateNowThis also return the current date and time.select SYSDATETIME() as dateNowThis return the current date and its more accurate. select datename(WEEKDAY, GETDATE()) as weekDayThis return the current weekday from the Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-3033865287071269733.post-5901386725375061842021-07-20T09:29:00.009-07:002021-07-23T09:58:00.509-07:00TSQL- How to remove a character from a stringA string is a group of characters in a specified order, called sequence of characters.This sequences are zero-indexed.To remove a character from a string in TSQL use SUBSTRING.The substring is a built-in function that takes, expression, starting point and length of the expression.Based on those three parameters, it decides on what string to returnTo remove the last character, what do you have to Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-3033865287071269733.post-38243003216807477402021-07-15T02:00:00.005-07:002021-07-15T02:00:36.845-07:00CONCAT String With TSQLJoining strings togetherWe will declare three variables and set their values, then the various select statement will be use for joining the string and print the outcome.declare @firstname as nvarchar(20)declare @middlename as nvarchar(20)declare @lastname as nvarchar(20)set @firstname = 'Maxybyte'set @middlename ='Technologies'set @lastname = 'Program'select @firstname + ' ' @middlename + 'Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-3033865287071269733.post-52671219758295983382021-06-18T02:59:00.001-07:002021-06-18T02:59:06.601-07:00Python Testcases and Testsuite in 38 minutes
In this video we are going to dive in quickly into something that mostly confuse some people that are just learning software testing.
What are testcases and what are the purpose of testsuites?
How are they use together? e.t.c.
Find out in this video by watching it.
Enjoy learning!
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-3033865287071269733.post-17969032661270240112020-06-11T07:25:00.004-07:002021-02-25T02:12:25.515-08:00How to use Interactive Console to store data into database
In this tutorial, I will briefly write on how to use the Interactive Console in PyCharm to add data into a database.
Let us use the models below and populate data into the language field using the interactive console in PyCharm :
from django.db import models
# Create your models here.
class Language(models.Model):
language_name = models.CharField(max_length=264, unique=True)
def Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-3033865287071269733.post-27834646099705005242019-04-12T10:15:00.003-07:002023-09-11T09:13:15.033-07:00Create table in MS Access
HOW TO CREATE TABLE IN MS ACCESS
I will show how to create tables base on the following diagram and it's textual specification.Learn Python here.You can do this same process by using MS Access.In order to create a database that contains these two tables, let's use the following code after this diagram.
Description of database tables created by using Enterprise Architect CASE tool
Unknownnoreply@blogger.com0Gunnison, CO 81230, USA38.616870656821312 -107.4902347500000113.094836156821312 -148.79882875 64.138905156821309 -66.181640750000014tag:blogger.com,1999:blog-3033865287071269733.post-59078478285577268572018-07-29T08:12:00.003-07:002023-09-11T09:22:19.122-07:00Recursion in C#
Recursion
Recursion is one of the most useful aspects of subroutines; that is the ability of the procedure or subroutine to call itself.
Learn Python here.
Download: Application to calculate your days on Earth
This article will use a rather ancient puzzle known as the Tower of Hanoi originated from Hindu.
Diagram Tower of Hanoi
The rules of this Unknownnoreply@blogger.com5tag:blogger.com,1999:blog-3033865287071269733.post-18510026900991846672018-07-18T04:08:00.008-07:002023-09-11T09:23:59.234-07:00Database with Maintenance-Driven Approach
Building Database with MDA
A maintenance-driven approach is better than tools-driven approach; although with the tools-driven approach, it's easy to get the work done once you know how to make use of the tools also tools-driven approach is good for departmental application development.
Learn Python here. In a nutshell, many applications are more scope beyond that of Unknownnoreply@blogger.com17tag:blogger.com,1999:blog-3033865287071269733.post-73118831515836070002018-06-09T04:02:00.001-07:002019-01-26T14:30:24.583-08:00Migrate SQL database to Azure SQL database
How to Migrate SQL database to Azure
Of course, it is very easy to build applications ruining on local computers and accessing stored database directly also on the local database should be very easy. One out of the reasons we build an application is to make it accessible worldwide, and we could get this possibility through the help of the internet.
Download: Gift game application
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-3033865287071269733.post-41888932140571014862018-06-09T00:29:00.001-07:002019-01-26T13:26:40.166-08:00 Create slide advertisement with XML that have URL navigator
How to create default pictures slide advertisement
Have you come across a web site where there are images moving on a slide? that might probably be ruining an advertisement for the web page. This article will show how to implement such in a simple way.
I will show simple 2 steps to get this done:
Download: Calculator
Step 1: Create .Xml file name it whatever you want, e.g Unknownnoreply@blogger.com11tag:blogger.com,1999:blog-3033865287071269733.post-56361609005586467722018-02-03T07:01:00.000-08:002019-01-25T03:32:11.547-08:00How to gain Access to ASP.NET Web Site Administration Tool
Accessing ASP.NET Web Site Administration Tool
Since the Membership Provider or ASP.NET Web Site Administration Tool that is used along with the SQL Server Membership Database is no longer available in VS 2015. It's possible to get the Website Administration Tool, up and running using a command window or set it up in IIS. This article covers the IIS through the commandUnknownnoreply@blogger.com3tag:blogger.com,1999:blog-3033865287071269733.post-53858241998871053892017-12-20T18:13:00.000-08:002019-01-26T13:28:16.964-08:00Creating a GridView Comand Button in ASP.NET
How to Create Gridview Comand Button
There are ways to make the Grid View more interactive by placing buttons in and pass in a method that will do some tasks by extracting information on each row within the Grid View Rows.
Download: Maxybyte Calculator
Doing this will make our application more dynamic and easy to interact with.
We can also change the order of what each column Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-3033865287071269733.post-40870547104085287792017-11-10T23:42:00.001-08:002019-01-26T13:30:00.654-08:00 DbSet Result displaying in ASP.NET Grid-Like Format
How to Display Data in Grid-Like Format
In the previous article, we had seen how to iterate through a database object in code and retrieve its values. This is possible with the "mapping" established by the Entity Framework, where an Object-Relational Mapper is served up as an intermediary which maps our data from the database and turn it to class and objects that allows it to work with it in Unknownnoreply@blogger.com1tag:blogger.com,1999:blog-3033865287071269733.post-6166531852721311302017-11-10T05:37:00.000-08:002019-01-26T13:31:30.361-08:00Understanding Entity Data Model and EDMX file
ENTITY DATA MODEL AND EDMX FILE
Entity Framework is an API within the .Net Framework that serves up an "Object-Relational Mapper". It's a subset of the entire ADO.NET application programming interface. What this API does is that it allows to access or update Data via C# Code.
From the lesson on how to create Database with MsVs, there I created a database ruining on a localUnknownnoreply@blogger.com0tag:blogger.com,1999:blog-3033865287071269733.post-85212687480186122322017-11-09T23:38:00.000-08:002019-01-26T13:33:35.420-08:00Enumeration
Create an Enum
An enumeration or rather Enum, allows you to restrict your set of options into values that are relevant.
Why use an Enum?
In a situation where we need to create a departmental application, e.g a Software Organization with Developers from different fields: Such as .Net developer, Java Developer, Ruby Developer, etc, In this case, it would be better to use an Enum (and not a Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-3033865287071269733.post-30300652147028645322017-10-27T05:32:00.000-07:002019-01-26T13:37:02.708-08:00How To Create a Database With MsVs
Create a Database With Visual studio
Within the principle of separation of concerns, there are 3 important layers that's needed to be followed while programming. They are:
Domain layer
Presentation layer
Persistence layer
Domain layer could basically refer to as the layer that manages the basic logic of the application, while Presentation layer is the one Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-3033865287071269733.post-31209876074894514672017-10-18T13:36:00.002-07:002019-01-26T13:43:20.521-08:00Simple Explanation of Foreach Iterarion
Foreach iteration
Let consider below Example for this article;Using "foreach iteration" on array's variables that consist 4 and 13 values for each variable, to generate 52 Cards rather than using collection initializer that could cause mistype and errors.Creating an application that stimulate the playing of war card game: This application would involve the use of List &Unknownnoreply@blogger.com2tag:blogger.com,1999:blog-3033865287071269733.post-15625804810869003862017-09-03T06:22:00.002-07:002019-01-24T09:18:40.476-08:00List as a Type in .Net Framework, Constructor Initializer and Object Initializer.
What is a List< T >
A list is a type in .Net framework that holds generic types. Therefore List could store multiple items just like an array. The < T > angled bracket means the List is generic and could store any data type given to it. One of the unique characteristics of List < T > is it ability to identify the data type(either string, int, or a class we defined) Unknownnoreply@blogger.com1tag:blogger.com,1999:blog-3033865287071269733.post-46751212902408588032017-08-24T11:56:00.000-07:002019-07-14T10:34:15.349-07:00Class and Object (Object-Oriented Programming)
Class and Object
Object-Oriented Programming is easy when you understand the basis on how objects talk to each other to solve a given task.
A class work with an object instance although there are static methods and properties in which we could access inside a class directly without using an instance of the class to access then. Even the easiest way to distinguish static from Unknownnoreply@blogger.com2tag:blogger.com,1999:blog-3033865287071269733.post-28937648759994715402017-08-17T15:57:00.000-07:002019-01-24T04:16:57.842-08:00String in C#
Understand String Manipulation
String is an array of individual letters that we can loop through the string variable by accessing each individual element in that array and print it out.
String as an array of Char:
Here I will write about String, Manipulating String, Looping from Left -to-Right(smallest to largest) and Looping from Right-to-Left(Largest to smallest).
I will start with Unknownnoreply@blogger.com1