C#¶ÁÈ¡access±í£¬²¢°ÑÊý¾ÝÏÔʾÔÚgridcontrolÖÐ
//¶ÁÈ¡±ê×¼Áбí
private void setModelList()
{
OleDbConnection Connection = null;
string tableName = "";
try
{
string strMdb = this.textBox5.Text;//mdb·¾¶
Connection = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strMdb + "");
Connection.Open();
DataTable schemaTable = Connection.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });
foreach (DataRow dr in schemaTable.Rows)
{
//±íÃû
tableName = dr["TABLE_NAME"].ToString();
//×Ö¶ÎÃû
//DataTable columnTable = Connection.GetOleDbSchemaTable(OleDbSchemaGuid.Columns, new object[]
Ïà¹ØÎĵµ£º
´ò¿ª OpenDataAccessPage:ÔÚÒ³ÊÓͼ»òÉè¼ÆÊÓͼÖдò¿ªÊý¾Ý·ÃÎÊÒ³
OpenForm:ÔÚ´°ÌåÊÓͼ¡¢´°ÌåÉè¼ÆÊÓͼ¡¢´òÓ¡Ô¤ÀÀ»òÊý¾Ý±íÊÓͼÖдò¿ª´°Ìå
OpenModule:ÔÚÖ¸¶¨¹ý³ÌµÄÉè¼ÆÊÓͼÖдò¿ªÖ¸¶¨µÄÄ£¿é
OpenQuery:´ò¿ªÑ¡Ôñ²éѯ»ò½»²æ±í²éѯ
OpenReport:ÔÚÉè¼ÆÊÓͼ»ò´òÓ¡Ô¤ÀÀÊÓͼÖдò¿ª±¨±í»òÁ¢¼´´òÓ¡¸Ã±¨±í ......
//ÏòÊý¾Ý¿âÖÐдÈë
private void button1_Click(object sender, EventArgs e)
{
oracleConnection1.Open();
& ......
Ê®Ììѧ»áASP.net֮ʵսϵÁУ¨C#ºÍVb.netË«°æ±¾£©
µÚÒ»Ìì
ÎÒÈÏΪASP.NET±ÈASPÄѺܶ࣬ϣÍû´ó¼Ò×öºÃ×¼±¸¡£ÄÑÄÑÔÚʵÏÖͬһ¸öЧ¹ûÓкܶ෽·¨£¬´ó¼Ò»òÐí»áÒÉ»ó¡£Ê®Ììѧ»áϵÁн̳̻áÇåÎúµÄд³ö¸÷ÖÖ·½·¨£¬Èôó¼ÒÄÜÉÙÒ»µã¿²¿À¡£ÔÚASPÀïÃæ£¬´ó¼Ò¼¸ºõ¶¼ÊÇʹÓÃVB£¬Êý¾Ý¿âÂҲÎÞ·ÇÊÇSQLºÍACCESS¡£ÔÚASP.NETÀïÃæ£¬Êý¾Ý¿â»¹ÊÇÕ ......
ÎÒÃÇ»¹¿ÉÒÔ²ÉÓÃÒ»ÖÖ¸ü¼Ó¼ò±ãµÄ·½
·¨À´ÊµÏÖÉÏÊö³ÌÐòµÄ¹¦ÄÜ¡£Õâ¾ÍÊǽ«SqlConnection¶ÔÏó°üº¬µ½usingÇø¿éÖУ¬ÕâÑù³ÌÐò»á×Ô¶¯µ÷ÓÃDispose()·½·¨ÊÍ·Å
SqlConnection¶ÔÏóËùÕ¼ÓõÄϵͳ×ÊÔ´£¬ÎÞÐèÔÙʹÓÃSqlConnection¶ÔÏóµÄClose()·½·¨¡£
·¶Àý³ÌÐò´úÂëÈçÏ£º
public partial class _Default : System.Web.UI.Page
{
......
×¢Òâ:
ÔÚʹÓÃFindControlʱ,Ò»¶¨ÒªÔÚ×îÌù½ü²éÕÒ¶ÔÏóµÄÍâ±ß¼ÓÉϸöÈÝÆ÷,Èç¹ûÄãÖ±½ÓÓÃthis.FindControl,»òPage.FindControlÄÇô¾Í»á¾³£³öÏÖ佫¶ÔÏóÉèÖõ½ÊµÀý
µÄ´íÎó,ËùÒÔ×îºÃ¼ÓÒ»¸öÈÝÆ÷,ÄÇôÕâÀï¼ÓµÄDIV¾ÍÊÇÒ»¸öÈÝÆ÷,ΪÁËÈÃFindControlÔÚIDΪ"TextBoxs"µÄDIVÄÚÈ¥ÕÒÃûΪcom1,com2,com3µÄTextBOx;
<div ......