469,317 Members | 1,970 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,317 developers. It's quick & easy.

How do I add a record to an MS Access database

Hi,

I am using VS.NET 2003 and I have made a connection to a MS Access database
using the Server Explorer. Is this connection permanent, meaning that it
will be there every time I reopen my program. Furthermore, how do I add,
delete, find, update a record?

TIA
Roy
Nov 17 '05 #1
1 2503
Here is my code, btw:

//Copyright (C) 2000 Microsoft Corporation. All rights reserved.

// OleDbSample.cs

// compile with: /r:system.dll /r:system.data.dll /r:system.xml.dll

// To build this sample from the command line, use the command:

// csc /r:system.dll /r:system.data.dll /r:system.xml.dll oledbsample.cs

using System;

using System.Data;

using System.Data.OleDb;

using System.Xml.Serialization;

public class MainClass {

public static void Main ()

{

// Set Access connection and select strings.

// The path to BugTypes.MDB must be changed if you build the sample

// from the command line:

#if USINGPROJECTSYSTEM

string strAccessConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=..\\..\\BugTypes.MDB";

#else

string strAccessConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=BugTypes.MDB";

#endif

string strAccessSelect = "SELECT * FROM Categories";

// Create the dataset and add the Categories table to it:

DataSet myDataSet = new DataSet();

myDataSet.Tables.Add("Categories");
// Create Access objects:

OleDbConnection myAccessConn = new OleDbConnection(strAccessConn);

OleDbCommand myAccessCommand = new
OleDbCommand(strAccessSelect,myAccessConn);

OleDbDataAdapter myDataAdapter = new OleDbDataAdapter(myAccessCommand);

myAccessConn.Open();

try

{

myDataAdapter.Fill(myDataSet,"Categories");

}

finally

{

myAccessConn.Close();

}

try

{

// A dataset can contain multiple tables, so let's get them all

// into an array:

DataTableCollection dta = myDataSet.Tables;

foreach (DataTable dt in dta)

{

Console.WriteLine("Found data table {0}", dt.TableName);

}
// The next two lines show two different ways you can get the

// count of tables in a dataset:

Console.WriteLine("{0} tables in data set", myDataSet.Tables.Count);

Console.WriteLine("{0} tables in data set", dta.Count);

// The next several lines show how to get information on a

// specific table by name from the dataset:

Console.WriteLine("{0} rows in Categories table",
myDataSet.Tables["Categories"].Rows.Count);

// The column info is automatically fetched from the database, so

// we can read it here:

Console.WriteLine("{0} columns in Categories table",
myDataSet.Tables["Categories"].Columns.Count);

DataColumnCollection drc = myDataSet.Tables["Categories"].Columns;

int i = 0;

foreach (DataColumn dc in drc)

{

// Print the column subscript, then the column's name and its

// data type:

Console.WriteLine("Column name[{0}] is {1}, of type {2}",i++ ,
dc.ColumnName, dc.DataType);

}

DataRowCollection dra = myDataSet.Tables["Categories"].Rows;

foreach (DataRow dr in dra)

{

// Print the CategoryID as a subscript, then the CategoryName:

Console.WriteLine("CategoryName[{0}] is {1}", dr[0], dr[1]);

}

}

catch (Exception e)

{

Console.WriteLine("Oooops. Caught an exception:\n{0}", e.Message);

}

}

}

"Roy Gourgi" <ro***@videotron.ca> wrote in message
news:Aw*********************@weber.videotron.net.. .
Hi,

I am using VS.NET 2003 and I have made a connection to a MS Access
database using the Server Explorer. Is this connection permanent, meaning
that it will be there every time I reopen my program. Furthermore, how do
I add, delete, find, update a record?

TIA
Roy

Nov 17 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by DebbieG | last post: by
25 posts views Thread by tekctrl | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by harlem98 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.