ÈçºÎÁ¬½Óaccess database £¿

ÎÒ»áʹÓÃsql server2005
µ«ÊÇÎÒ²»»áʹÓÃaccess...

VB.NET code:

Imports Microsoft.VisualBasic
Imports System.Data.SqlClient



Public Class cls_conn
Dim conn As New SqlConnection


Sub New()
conn.ConnectionString = "data source=.\sqlexpress;initial catalog=fif;integrated security=true"

End Sub


Õâ¸öÊÇʹÓÃsql serverµÄ
ÄÇôaccessµÄÒªÈçºÎʹÓÃÄØ£¿
лл

---

C# code:
ºÍÁ¬½Ósql2005²î²»¶à,Ö»ÐèÒª¸ÃÁ¬½Ó×Ö·û´®¼´¿É.

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.OleDb;
using System.Data.SqlClient;

namespace TestAccess
{
class Program
{
static void Main(string[] args)
{
#region Access 2007
Console.WriteLine("Access 2007");
string strConnection = "Provider=Microsoft.ACE.OLEDB.12.0;";
strConnection += @"Data Source=C:\Documents and Settings\v-changl\My Documents\Database1.accdb;";
strConnection += "Persist Security Info=False";
using (OleDbConnection objConnection = new OleDbConnection(strConnection))