C#

using System;<br />
using System.Data;<br />
using System.Data.OleDb;<br />
using System.IO;<br />
namespace FrameworkExamples<br />
{<br />
//HOW TO: use ADO.NET to execute sql against an MS Access DB<br />
class SampleADONETExecSQLAccess<br />
{<br />
static void Main()<br />
{<br />
OleDbConnection db;<br />
OleDbCommand dbcmd;<br />
string connstring;<br />
int recsaffected;<br />
StringWriter sql;<br />
//create the connection string to an access db<br />
connstring = "Provider=Microsoft.Jet.OLEDB.4.0;";<br />
connstring += @"Data Source=C:\Documents and Settings\Administrator\Desktop\db1.mdb;";<br />
//create a connection to an access db<br />
db = new OleDbConnection(connstring);<br />
//open access db<br />
db.Open();<br />
//create some sql to run<br />
sql = new StringWriter();<br />
sql.WriteLine("create table tbl1");<br />
sql.WriteLine("(");<br />
sql.WriteLine("id int identity(1, 1) not null primary key,");<br />
sql.WriteLine("field1 varchar(255) null,");<br />
sql.WriteLine("field2 bit null");<br />
sql.WriteLine(")");<br />
sql.Flush();<br />
//create a command object to run sql<br />
dbcmd = new OleDbCommand();<br />
//set type to text<br />
dbcmd.CommandType=CommandType.Text;<br />
//timeout of 30 seconds<br />
dbcmd.CommandTimeout=30;<br />
//the sql that was created above<br />
dbcmd.CommandText=sql.ToString();<br />
//set to the current OleDbConnection instance<br />
dbcmd.Connection=db;<br />
//execute sql that doesn't return rows<br />
recsaffected = dbcmd.ExecuteNonQuery();<br />
//close access database<br />
db.Close();<br />
//cleanup<br />
dbcmd = null;<br />
db = null;<br />
sql = null;<br />
}<br />
}<br />
}

My: Blog | Photos
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More