Categories
Tags → Using Update In Sql

Simple csv to MySQL tool

This code will take a csv file and create or, insert or update, the data into a MySQL database. It assumes the first line contains the field names and uses that to build the SQL query for the following data lines. There''s a download button fo...
DETAILS

Using Stored Procedures with MSSQL and ASP.NET 2.0

If you haven''t used MSSQL stored procedures before with SQL Server and in your ASP.NET 2.0 pages then you need to read this article. In this article I will list down basic questions like the following :what is a stored procedure? How can I crea...
DETAILS

SQLite GUI

SQLite GUI is a simple GUI to work with SQLite dB. You can create, delete and update tables a database. All the available tables in the database is shown. The records of various types including BLOB are displayed in the DataGridView. And the data ...
DETAILS

CodeGen - Code Generator

This is a multi-level project. Since languages today, such as PHP, use HTML a front-end and an SQL as a rear-end, we need a higher level language that defines our goals. With this language we can define simple scripts in very few lines of code. Then,...
DETAILS

Class: Easy MySQL class

This class is a simple wrapper to access MySQL databases. It can establish connections to a given MySQL server and execute SQL queries in a single call. The query result resource handle, columns names, number of returned rows and last ins...
DETAILS

BuilderEditor

BuilderEditor is a powerful and easy to use ASP.NET RAD component for maintaining a datasource (e.g. SQL database, dataset). It allows you to add, edit, delete and display data from a data source. It generates the data entry forms used to insert and ...
DETAILS

VB.NET 2005 Tutorials: Access and Manipulate SQL Server data

VB.NET 2005 Tutorials: Access and Manipulate SQL Server data - Using Ad Hoc Queries - In this tutorial you will learn about Consuming and Manipulating Data Viz. Access and Manipulate SQL Server data - Using Ad Hoc Queries; Running Queries, The SELECT...
DETAILS
©2003-2019 jCay.com