PAGING/ PAGINATION IN VB.NET
simple paging/pagination Note: if you want source code for VB 6.0, J#.net and C#.net... Please Dont hesitate to inform me, or comment on this link... thanks....
PAGING/ PAGINATION IN C#.NET
I made this simple paging/ pagination for all the programmers who seek and search some codes.....
Password Generator Application
PasswordGenerator generates/translates your chosen password into an alphanumeric words. It doesn't use any algorithms or any encryptions but for future versions, I may include it. Additional: It also includes the java.awt.datatransfer package to copy the generated password into the system clipboard.
SQL AND / OR Operator
The AND/OR can be used to make a complex or multiple condition for the WHERE clause while selecting, updating or deleting some data.
The AND works as follows
Condition 1 AND condition 2 AND……… condition N
We can use as many conditions as we want with the AND. This condition’s result will only come out to be true if all the conditions are specifies, just like the and truth table
SQL DISTINCT Clause
The SQL DISTINCT clause is also used in the SELECT statement, it is used to get the data and display the unique values, and the values will be shown no matter how many times they appear in the table.
DISTINCT Syntax
SELECT DISTINCT columnname FROM tablename
Users:
SQL ORDER BY Clause
The ORDER BY clause is used in the SQL SELECT statement to order the data in ascending or descending order, this may help us get a better look when analyzing data, the ORDER BY clause can sort numeric as well as alphabetical data in both ascending and descending order.
SQL ORDER BY Clause Syntax
SQL GROUP BY Clause
In the SQL SELECT Statement we can also group data upon certain conditions, the GROUP BY condition can only be applied if we have redundant values in at least one column upon which we can group things.
If every column of each row has unique value then the GROUP BY clause will not group any thing together and will not give proper results.
The GROUP BY clause also requires the use of an aggregate function, which does some mathematical calculations upon the grouped data.
Using OLEDB in Connecting Database to MS Access(with Database Password)
Hello Guys.. i uploaded this code to help other programmers to saved more space in codings.. when it comes in connecting the database.. For me,this kind of coding is more easy way than others,b'coz, you can call the connection in evry form load event with a single line code,ohhh.. i mean two words only like this "Call dbconnection" That's it.. Enjoy!!! ^__^
POS and Inventory System
This is a pos and inventory system in visual foxpro using postgresql as database.... I guess this combination is something unusual....(^ ^,) If you want to try this system: please use 8.3 or higher version of postgresql...
SQL WHERE Clause
Whenever you want to retrieve data from your table, there are times that you don’t want to pull all the information. You can retrieve data from the database by using the WHERE clause to filter data based on your criteria.
The WHERE clause in SQL is used to filter out data or to simply select specific data to perform the desired operation.
The WHERE clause can be used in SELECT, UPDATE, and DELETE statement. It is needed to filter what data to select, update, or delete.