c#ÓïÑÔ²Ù×÷AccessÊý¾Ý¿â
±¾ÎĽ«c#ÓïÑÔ²Ù×÷AccessÊý¾Ý¿âµÄ·½·¨¼ÓÒÔ×ܽᣬÖ÷Òª½â¾öµÄÎÊÌâÈçÏ£º
´´½¨mdb
´´½¨table
¶ÁÈ¡tableÄÚÈÝ
²é
ѯtableÖеÄÄÚÈÝ
ÏòtableÖвåÈëÊý¾Ý
ɾ³ýtableÖеļǼ
ÏòtableÖвåÈëÕÕƬ
¶ÁÈ¡tableÖеÄÕÕƬµÈ¡£
ÎÄ
½éÉÜC#
·ÃÎʲÙ×÷AccessÊý¾Ý¿âµÄ»ù´¡ÖªÊ¶£¬²¢Ìá
¹©Ò»¸öÏà¹ØµÄÀý³Ì¡£C#µÄADO.NET»¹²»ÄÜͨ¹ý±à³Ì·½Ê½´´½¨È«ÐµÄACCESS(MDB)Êý¾Ý¿â£¬ËùÒÔ»¹Ö»ÄÜʹÓÃADOXÕâ¸öÀ´×ÔCOMµÄÁ´½Ó¿âÀ´²Ù
×÷¡£
Ö÷Ҫ֪ʶµãÈçÏ£º
using System.Data.OleDb;
using System.Data;
Á¬½Ó×Ö·û
´®£ºString connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=product.mdb";
½¨Á¢Á¬½Ó£ºOleDbConnection connection = new
OleDbConnection(connectionString);
ʹÓÃOleDbCommandÀàÀ´Ö´ÐÐSqlÓï¾ä£º
OleDbCommand
cmd = new OleDbCommand(sql, connection);
connection.Open();
cmd.ExecuteNonQuery();
1.´´½¨mdb¿â£¬Àý³ÌÈçÏ£º
ÐèҪעÒâµÄÊÇ£º²ÎÊýmdbPathÊÇmdbµÄÍêÕû·¾¶£¨²»°üº¬±íµÄÃû³Æ£©¡£ÀýÈ磺D:\\test.mdb
//´´½¨mdb
public static bool
CreateMDBDataBase(string mdbPath)
{
try
{
ADOX.CatalogClass cat = new ADOX.CatalogClass();
cat.Create("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + mdbPath +
";");
cat = null;
return true;
}
catch { return false; }
}
2.´´½¨¾ßÌåµÄ±í£¬À
Ïà¹ØÎĵµ£º
SQL:
using System.Data.SqlClient;
string sql = "server=.;uid=sa;pwd=;database=tablename;";
ACCESS:
using System.Data.OleDb;
string sql = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source=" + HttpRuntime.AppDomainAppPath + "//App_Data//db.mdb";
HttpRuntime.AppDomainAppPath Ϊ¸ùĿ¼
......
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ViewState["BackUrl"] = Request.UrlReferrer.ToString();
}
}
/// <summary>
/// ·µ»Ø°´Å¥µã»÷ʼþ
/// </summary& ......
1¡¢Ìí¼ÓADODC1µ½´°Ìå
2¡¢×¼±¸ºÃÒ»¸öACCESSн¨µÄ¿ÕÊý¾Ý¿â66.mdb
Private Sub Form_Load()
With Adodc1
.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
"C:\Documents and Settings\Administrator\" & _
"My Docume ......
Ê×ÏÈÅäÖÃSQLSERVER2005£º
´ò¿ª”Microsoft SQL Server Management Studio“ Ö±½ÓÓÃWindows Óû§Á¬½Ó½øÈ룬ÔÙÔÚ“°²È«ÐÔ”ÖеēµÇ¼Ãû”Äڵēн¨µÇ¼Ãû”£¬Äã¾Í¶ÔÓ¦µÄÌíºÃ“È·¶¨”¾Í¿ÉÒÔÁË¡£
ÔÙÔÚÄã¶ÔÓ¦µÄ“Êý¾Ý¿â”Àï“°²È«ÐÔ” ......