<%@ Page language="C#" %> <%@ Register TagPrefix="mono" TagName="MonoSamplesHeader" src="~/controls/MonoSamplesHeader.ascx" %> <%@ import namespace="System.Data" %> <%@ import namespace="System.Data.SqlClient" %> <%@ import namespace="System.Reflection" %> <%@ Import namespace="System.IO" %> <%@ Register TagPrefix="Mono" Namespace="Mono.Controls" assembly="tabcontrol2" %> More DB testing plus tabcontrol2.dll

Database Error

Sorry, could not connect to a database.

You should set up a database for user 'monotest', password 'monotest' and dbname 'monotest'

Then modify the variables DBProviderAssembly, DBConnectionType and DBConnectionString in server.exe.config file to fit your needs.

The database should have a table called customers created with the following command: 

CREATE TABLE "customers" (
	"id" integer NOT NULL,
	"name" character varying(256) NOT NULL,
	"address" character varying(256) NOT NULL
);

CREATE UNIQUE INDEX id_idx ON customers USING btree (id);

Below, the rows of the table are displayed (if any).


Fill in the data and click the button when done. All fields are mandatory.

ID:

Name:

Address:

Deletes a row by its ID.

ID:


The ID field acts as unique index. The other fields will be modified.
If you fill the ID, you can push "Refresh data" to get name and address from the database.

ID:

Name:

Address: