SQL SELECT Statement
The select command is used to retrieve data from the tables.
Consider the following table:
Users:
SQL Syntax
SQL is not syntax strict like JavaScript which mean to say that in SQL uppercases and lowercases don’t matter as long as you have spelled them correctly.
For example:
SQL intro
SQL is an acronym for Structure Query Language, it is a language which helps program to communicate with the databases, regardless of the type of the database, the SQL syntax is almost the same except for extended commands which certain DBMS support or do not support or simply have its own versions or dialects.
Flash Card Addition
let's Play!!! Heeheh.. ahm..just lyk my 2nd post... khapon ko lng din to gnwa.. COMMENT po kung anu msasabi nyo.. SOLOMOT.. ^__^
Simple Blackboard(Looks Like Paint)
ahahahha..good day guyz... ive just created this program yesterday... wala kc mgawa so naisipan kong gwin toh.. wla lng..share ko lng BAKIT??? heheh..... Try nyo masaya toh,,,, Comment if anu msasabi nyo..hehe :)
PAGINATION USING LINQ (not a stone age technology)
PROGRAMMER: WINSTON L. GUBANTES REFERENCES: VISUAL C# PROGRAMMING BY: BARBARA DOYLE VISUAL BASIC .NET HOW TO PROGRAM BY: DEITEL & TIM R. NIETO PURPOSE: USE PRIMARILY FOR MANIPULATING PAGINATION IN C# LANGUAGE: C# .NET
Weekly Sales Report using Crystal Reports
The following source code will teach you on how to create a “Weekly Sales Report” using Crystal Reports. The most important part of this project is the use of SQL Statement. Here’s the statement that create a weekly sales report. SELECT TOP (100) PERCENT CONVERT(Varchar, DATEADD(WEEK, DATEDIFF(WEEK, CONVERT(DATETIME, '1900-01-01 00:00:00', 102), Date), CONVERT(DATETIME,
How to Change Connection String of VB.NET Project at Design Time
One of the problems that a beginner encounter when there is a project uploaded here, is they do not know on how to change the connection string that points to the correct database location. This is true with MS Access and even with SQL Server. Some programmers don’t add a code that will automatically change the location of the database just in case it will be ported in other machine.
Library System in Visual Basic .NET 2008 and SQL Server 2008
Here’s the full source code of the sample project, Visual Basic .NET 2008 Tutorial, I created this in addition with the tutorial that I've made several months ago. It is advised that you will follow the tutorial closely to understand how I created this project. There’s nothing so much information about this project for certainly, this project is not intended for advance programmer, thus it is
Login Form without Database using Visual C#.NET 2005
This is a sample application for beginners to login and view other forms. It has been build in MS Visual Studio 2005. Hope this will help the beginners. Thanx to Mithun Paul, Deitholhoutuo Hama, L. Hopong Chang, KT Soneh, Shyreahun Tep & Sentitula Ao.