清醒时做事,糊涂时读书,大怒时睡觉,无聊时关注为大家准备的精彩内容。下面为大家推荐Add data to the Access database using ADO,无聊中的都看过来。
Add data to the database using ADO
Tools Used :VisualC# .NET
This program shows how to insert data in an access database using ADO andSQLquery. I have anAccess2000 database in projectindebug directory. My database name is mcTest.MDB. You can create your own database and copy in your project's debug directory. I am not attaching database with this code because of size problem.
I have a table 'Developer' in this database which has four columns. I am inserting values into two columns Name and Address in this code.
using System;
using ;
using .OleDb;
namespace ADONETWriteQuery
{
/// summary
/// Summary description for Class1.
/// /summary
class Class1
{
static void Main(string[] args)
{
string strDSN = "Provider=
Source=c:mcTest.MDB";
string strSQL = "INSERT INTO Developer(Name, Address ) VALUES(
'NewName', 'NewAddress')" ;
// create Objects of ADOConnection and ADOCommand
OleDbConnection myConn = new OleDbConnection(strDSN);
OleDbCommand myCmd = new OleDbCommand( strSQL, myConn );
try
{
();
();
}
catch (Exception e)
{
("Oooops. I did it again:{0}", );
}
finally
{
();
}
}
}
}