¹ØÓÚ»ñµÃACCESS£¨mdb£©±íÍ·ÐÅÏ¢ÎÊÌâ
ÇëÎÊ»ñµÃACCESS£¨mdb£©±íÍ·ÐÅÏ¢£¬Èç×Ö¶ÎÃû³Æ£¬×Ö¶ÎÀàÐÍ£¬×ֶδóС£¬ÌرðÊÇ×ֶδóС
Èçͼ£º
Update ¶¥Æð
ÄÄλ×ö¹ý¸øÖ¸µãһϰÉ~~СµÜ²»Ê¤¸Ð¼¤
OleDbConnection.GetOleDbSchemaTable·½·¨
Ó¦ÓÃÁËÖ¸¶¨µÄÏÞÖÆÖ®ºó£¬°´ÕÕ GUID µÄָʾ´ÓÊý¾ÝÔ´·µ»Ø¼Ü¹¹ÐÅÏ¢¡£
C# code:
private void button1_Click(object sender, EventArgs e)
{
string x = @"Provider=Microsoft.Jet.OleDb.4.0;Data Source=e:\db1.mdb;";
this.dataGridView1.DataSource = GetSchemaTable(x);
}
static DataTable GetSchemaTable(string connectionString)
{
using (OleDbConnection connection = new OleDbConnection(connectionString))
{
connection.Open();
DataTable schemaTable = connection.GetOleDbSchemaTable(
OleDbSchemaGuid.Columns, //·µ»ØÁеÄÐÅÏ¢
new object[] { null, null, "SYSADDRESS", null }); //ÏÞÖÆÌõ¼þ£º±íÃûΪSYSADDRESS
return schemaTable;
}
}
}
ÄãÓÃdatagridviewÒ»¿´ÉÏÃæµÄ´úÂë³öÀ´µÄ½á¹û¾ÍÖªµÀÁË£¬×ֶδóСÓÐÒ»¸ö½ÐCharacter_MaximuM_LengthµÄÁÐ
ллÉÏÃæµÄͬ־£¡ÎÒÈ¥ÊÔÊÔ
Ïà¹ØÎÊ´ð£º
ÎÒµÄÊý¾Ý¿âÊǼòÌåsqlserver2000 ,ÎÒÏëÔÚ·±ÌåaccessÏÂÁ¬½Ó,ͨ¹ýodbcÊÇ¿ÉÒÔÁË,µ«ÔÚaccessϳöÏÖ´ò¿ªµÄ±íÈ«ÖÐ"#ÒÑɾ³ý"
²»ÖªµÀÒªÔõô²Ù×÷²Å¿ÉÒÔÓÃACCESS·±ÌåÁ¬½Ó¼òÌåsqlserver2000.лл!!!
´ó¼Ò¶¼ ......
sqlÓï¾ä£º
SELECT top 12 Forum.ID,Forum.topic,Reforum.id,Reforum.username,Reforum.posttime,Reforum.postip,Forum.username from Forum INNER JOIN Reforum ON Forum.ID = Reforum.topicid wher ......
´ó¸ÅÇé¿ö£º
C#дµÄwinformÓ¦ÓóÌÐò£¬ÒªÇó³ÌÐòÕûÌìÔËÐС£Êý¾Ý±íºÍÊý¾ÝÁ¿²¢²»´ó£¬±í×î¶à15¸ö£¬ÐÂÔöÊý¾ÝÿÈÕ×î¶à1000Ìõ£¬¶øÇÒ±íÖÐÖ»±£Áôµ±ÌìÊý¾Ý¡£
ÐèҪעÒâµÄÊdzÌÐò¶Ô±íµÄ²éѯºÍÐ޸ķdz£Æµ·±£¬¶øÇÒÊǶà¸öÏß³ÌÍ¬Ê ......
´úÂëÈçÏ£º
OleDbConnection conn = new OleDbConnection();
conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("~/Ap ......