Databases | Category

A database is an organized set of related tables that are used to store data permanently. This category with free code for web programming against databases includes code for inserts into and selects from databases for instance.

Calculations in a SELECT from a SQL database (C#, VB and ASP.NET) | Free code

Here you can download free code (C# and VB) for calculations in a SQL SELECT statement to add, subtract, divide, multiply and sum values for instance.

Connect to MySQL or MS SQL database (C#, VB and ASP.NET) | Free code

Here you can download free code (C# and VB) to connect a website to a MySQL or MS SQL database so that data can be stored in, retrieved from and updated in a database through SQL statements.

DELETE in a MS SQL database (C#, VB and ASP.NET) | Free code

Here you can download free code (C# and VB) for the SQL DELETE statement so that you or a user on your website can remove one or more records in a Microsoft SQL database.

DELETE in a MySQL database (C#, VB and ASP.NET) | Free code

Here you can download free code (C# and VB) for the SQL DELETE statement so that you or a user on your website can remove one or more records in a MySQL database.

INNER JOIN in SELECT from SQL database (C#, VB and ASP.NET) | Free code

Here you can download free code (C# and VB) for INNER JOIN in a SQL SELECT statement in order to combine data from multiple related tables in one database retrieval.

INSERT a DataTable with SqlDataAdapter and SqlBulkCopy (C#, VB and ASP.NET) | Free code

Here you can download free code (C# and VB) to insert many rows of data simultaneously in an INSERT into a SQL database, using a DataTable and SqlDataAdapter or SqlBulkCopy.

INSERT INTO a MS SQL database (C#, VB and ASP.NET) | Free code

Here you can download free code (C# and VB) to save data from a web form into (INSERT INTO) a table in a Microsoft SQL database.

INSERT INTO a MySQL database (C#, VB and ASP.NET) | Free code

Here you can download free code (C# and VB) to save data from a web form into (INSERT INTO) a table in a MySQL database.

OUTER JOIN in SELECT from a SQL database (C#, VB and ASP.NET) | Free code

Here you can download free code (C# and VB) for OUTER JOIN in a SQL SELECT statement in order to combine data from multiple related tables in one database retrieval.

Partition an InnoDB table in MySQL (C#, VB and ASP.NET) | Free template

Here you can download a free template with instructions and code (C# and VB) to partition a table (InnoDB) in a MySQL database in order to divide a large table into several smaller parts.