Hello!

I don't know how much you know about databases, and how much I should
explain, but here is a simple example with MS Access and J#.

A good staring point could be a "ADO.NET" book, if you want in depth
knowledge.

1. Open ACCESS
2. File + New + "Blank database"
3. Name : "testDB" + "Create"
4. "Create table in Design View"
5. Filed Name -> "numb". DataType -> "Number"
6. Field name -> "val", DataType -> "Text"
7. File + Save -> Table Name "testTable"
8. "Yes" for a primary key

9. Open Visual Studio
10. New a new J# project (Windows Forms application):

In the "Server explorer", "Add connection" (right click) + "Provider" tab
11. Choose a "Microsoft JET 4.0 OLE DB Provider" + "Next"
12. Find the "testDB" file in the "Select or enter a database name".
13, Click the "test connection" button to see if the connection was ok. +
"OK"

14. Drag "ACCESS,c:\testDB.mdb.Admin" onto the design view in Visual Studio
15. choose "include password".

16. Write the SQL code. See below for example:

package Access_J;

import System.Drawing.*;
import System.Collections.*;
import System.ComponentModel.*;
import System.Windows.Forms.*;
import System.Data.*;

/**
* Summary description for Form1.
*/
public class Form1 extends System.Windows.Forms.Form
{
private System.Windows.Forms.TextBox textBox1;
private System.Windows.Forms.Button button1;
private System.Windows.Forms.Label label1;
private System.Windows.Forms.Button button2;
private System.Windows.Forms.ListView listView1;
private System.Data.OleDb.OleDbConnection oleDbConnection1;
/**
 * Required designer variable.
 */
private System.ComponentModel.Container components = null;

public Form1()
{
 //
 // Required for Windows Form Designer support
 //
 InitializeComponent();

 //
 // TODO: Add any constructor code after InitializeComponent call
 //
}

/**
 * Clean up any resources being used.
 */
protected void Dispose(boolean disposing)
{
 if (disposing)
 {
  if (components != null)
  {
   components.Dispose();
  }
 }
 super.Dispose(disposing);
}

#region Windows Form Designer generated code
/**
 * Required method for Designer support - do not modify
 * the contents of this method with the code editor.
 */
private void InitializeComponent()
{
 this.textBox1 = new System.Windows.Forms.TextBox();
 this.button1 = new System.Windows.Forms.Button();
 this.label1 = new System.Windows.Forms.Label();
 this.button2 = new System.Windows.Forms.Button();
 this.listView1 = new System.Windows.Forms.ListView();
 this.oleDbConnection1 = new System.Data.OleDb.OleDbConnection();
 this.SuspendLayout();
 //
 // textBox1
 //
 this.textBox1.set_Location(new System.Drawing.Point(24, 32));
 this.textBox1.set_Name("textBox1");
 this.textBox1.set_Size(new System.Drawing.Size(248, 20));
 this.textBox1.set_TabIndex(0);
 this.textBox1.set_Text("textBox1");
 //
 // button1
 //
 this.button1.set_Location(new System.Drawing.Point(24, 64));
 this.button1.set_Name("button1");
 this.button1.set_TabIndex(1);
 this.button1.set_Text("insert data");
 this.button1.add_Click( new System.EventHandler(this.button1_Click) );
 //
 // label1
 //
 this.label1.set_Location(new System.Drawing.Point(24, 0));
 this.label1.set_Name("label1");
 this.label1.set_TabIndex(2);
 this.label1.set_Text("Insert Value");
 //
 // button2
 //
 this.button2.set_Location(new System.Drawing.Point(24, 152));
 this.button2.set_Name("button2");
 this.button2.set_TabIndex(3);
 this.button2.set_Text("get data");
 this.button2.add_Click( new System.EventHandler(this.button2_Click) );
 //
 // listView1
 //
 this.listView1.set_Location(new System.Drawing.Point(24, 184));
 this.listView1.set_Name("listView1");
 this.listView1.set_Size(new System.Drawing.Size(248, 97));
 this.listView1.set_TabIndex(4);
 //
 // oleDbConnection1
 //
 this.oleDbConnection1.set_ConnectionString("Jet OLEDB:Global Partial Bulk
Ops=2;Jet OLEDB:Registry Path=;Jet OLEDB:Database L" +
  "ocking Mode=1;Jet OLEDB:Database Password=;Data
Source=\"F:\\testDB.mdb\";Password=" +
  ";Jet OLEDB:Engine Type=5;Jet OLEDB:Global Bulk
Transactions=1;Provider=\"Microsof" +
  "t.Jet.OLEDB.4.0\";Jet OLEDB:System database=;Jet
OLEDB:SFP=False;Extended Propert" +
  "ies=;Mode=Share Deny None;Jet OLEDB:New Database Password=;Jet
OLEDB:Create Syst" +
  "em Database=False;Jet OLEDB:Don\'t Copy Locale on Compact=False;Jet
OLEDB:Compact" +
  " Without Replica Repair=False;User ID=Admin;Jet OLEDB:Encrypt
Database=False");
 //
 // Form1
 //
 this.set_AutoScaleBaseSize(new System.Drawing.Size(5, 13));
 this.set_ClientSize(new System.Drawing.Size(292, 294));
 this.get_Controls().Add(this.listView1);
 this.get_Controls().Add(this.button2);
 this.get_Controls().Add(this.label1);
 this.get_Controls().Add(this.button1);
 this.get_Controls().Add(this.textBox1);
 this.set_Name("Form1");
 this.set_Text("Form1");
 this.ResumeLayout(false);

}
#endregion

/**
 * The main entry point for the application.
 */
/** @attribute System.STAThread() */
public static void main(String[] args)
{
 Application.Run(new Form1());
}

// Insert data
private void button1_Click (Object sender, System.EventArgs e)
{
 int number = 1;
 String sql = "INSERT INTO testTable (numb, val) VALUES ("+number+",
'"+this.textBox1.get_Text()+"')";

 System.Data.OleDb.OleDbCommand command =
  new System.Data.OleDb.OleDbCommand( sql, this.oleDbConnection1 );

 this.oleDbConnection1.Open();
 command.ExecuteScalar();
 this.oleDbConnection1.Close();
}

// Gets all data from the DB
private void button2_Click (Object sender, System.EventArgs e)
{
 String sql = "SELECT * FROM testTable";
 System.Data.OleDb.OleDbDataAdapter dataAdaper = new
System.Data.OleDb.OleDbDataAdapter( sql, this.oleDbConnection1 );

 System.Data.DataTable _dt = new System.Data.DataTable();
 dataAdaper.Fill( _dt );

 for( int rowCounter = 0; rowCounter < _dt.get_Rows().get_Count();
rowCounter++)
 {
  System.Data.DataRow _dr = _dt.get_Rows().get_Item(rowCounter);

  System.Windows.Forms.ListViewItem _lvi = new
System.Windows.Forms.ListViewItem();
  _lvi.set_Text( _dr.get_Item("val").toString() );
  this.listView1.get_Items().Add( _lvi );
 }

}
}

Regards,
Lars-Inge T?nnessen