Learn how to add records with an SQL statement instead of a Recordset. Here are two examples. One will use a query string and the other gets the info from a form. Both examples include an example of a DSN-LESS connection.
This article is helpful for the database administrators which gives them solution for accessing the date and time of SQL server using GetDate function in an SQL statement. Syntax for this function has been given to test on their web page.
Learn how to delete records with an SQL instead of a Recordset. Here are two examples. One will use a query string and the other gets the info from a form. Both examples include an example of a DSN-LESS connection.
Counting Records in an SQL Table is an helpful tutorial for the .NET programmers to know about how to display the count of the database records. This tutorial explains it cleary with an example code. The example code is useful for the programmers...
SQLMonitor is an SQL statement tester software for local databases like Paradox, FoxPro or DBase.
How To Retrieve and Display Records from an Access Database by Using ASP.NET, ADO.NET, and Visual C# .NET is an article that explains step-by-step process of fetching records from the Access database and bind it to the datagrid control using...
I wrote this game after My Little Word Puzzles, which due to its complexity contained quite a few bugs. After downloading the scripts, you'll have to edit db.php and create the table using the sql statement inside the text box.
Use Erik Stok search dialogs to easily create powerful search functionality in your application by simply building an SQL statement and visualy configuring how your user may search on the query result. Use multiple search criteria, case...
This tutorial is helpful for every SQL server administrators and its developers which explains them about the usage of apostrophe in a SQL statement. It clearly explains the users how to avoid apostrophe errors. Its an easy to follow tutorial for...
DragonDB - MVB Edition is an SQL database engine and software development toolkit for creating Microsoft Pocket PC and Smartphone database applications using AppForge MobileVB (version 3.2 or later). DragonDB is built upon SQLite3 so its... |