Solved

Write to an AccessData base

Posted on 2009-05-03
4
196 Views
Last Modified: 2012-05-06
How is this done?

I have the following code that opens the database but how do I write to it?

The database Customer has three colums
name, phone, adress
con = new System.Data.OleDb.OleDbConnection();
        ds1 = new DataSet();
        con.ConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source= C:\\Documents and Settings\\MFL\\Dokumenter\\Visual Studio 2005\\WebSites\\WebSite\\WebSite\\Nwind.mdb";
        con.Open();
 
 
 
        con.Close();
        con.Dispose();
}

Open in new window

0
Comment
Question by:Mickeys
  • 2
  • 2
4 Comments
 
LVL 4

Expert Comment

by:cauos
ID: 24289134
this is an example how you can insert new row to access database
also check this link for more info:
http://msdn.microsoft.com/en-us/library/system.data.oledb(VS.71).aspx
public void InsertRow(string myConnectionString) 
{
   // If the connection string is null, use a default.
   if(myConnectionString == "") 
   {
      myConnectionString = "Provider=SQLOLEDB;Data Source=localhost;Initial Catalog=Northwind;" + 
      "Integrated Security=SSPI;";
   }
   OleDbConnection myConnection = new OleDbConnection(myConnectionString);
   string myInsertQuery = "INSERT INTO Customers (CustomerID, CompanyName) Values('NWIND', 'Northwind Traders')";
   OleDbCommand myCommand = new OleDbCommand(myInsertQuery);
   myCommand.Connection = myConnection;
   myConnection.Open();
   myCommand.ExecuteNonQuery();
   myCommand.Connection.Close();
}

Open in new window

0
 

Author Comment

by:Mickeys
ID: 24289171
you say it should have a public void InsertRow(string myConnectionString)

what is myConnectonString?

I got this:
            private System.Data.OleDb.OleDbConnection con;
        private DataSet ds1;
        private System.Data.OleDb.OleDbDataAdapter da;
        con = new System.Data.OleDb.OleDbConnection();
        ds1 = new DataSet();
        con.ConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source= C:\\Documents and Settings\\MFL\\Dokumenter\\Visual Studio 2005\\WebSites\\WebSite\\WebSite\\Nwind.mdb";
        con.Open();
0
 
LVL 4

Accepted Solution

by:
cauos earned 500 total points
ID: 24289238
this example for insert record into database;
the link above contains what you are looking for in details.
con = new System.Data.OleDb.OleDbConnection();
        ds1 = new DataSet();
        con.ConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source= C:\\Documents and Settings\\MFL\\Dokumenter\\Visual Studio 2005\\WebSites\\WebSite\\WebSite\\Nwind.mdb";
        con.Open();
 
  string myInsertQuery = "INSERT INTO Customers (CustomerID, CompanyName) Values('NWIND', 'Northwind Traders')";
   OleDbCommand myCommand = new OleDbCommand(myInsertQuery);
   myCommand.Connection = myConnection;
   myConnection.Open();
   myCommand.ExecuteNonQuery();
   myCommand.Connection.Close();
 
 
        con.Close();
        con.Dispose();
}

Open in new window

0
 

Author Closing Comment

by:Mickeys
ID: 31577296
Great thx
0

Featured Post

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

'Between' is such a common word we rarely think about it but in SQL it has a very specific definition we should be aware of. While most database vendors will have their own unique phrases to describe it (see references at end) the concept in common …
Exception Handling is in the core of any application that is able to dignify its name. In this article, I'll guide you through the process of writing a DRY (Don't Repeat Yourself) Exception Handling mechanism, using Aspect Oriented Programming.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question