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[]
Ïà¹ØÎĵµ£º
ÏÈÀ´Ð´Ò»¸ö¼òµ¥µÄAjax³ÌÐò£¬Ê¹Ó÷Çͬ²½µÄ·½Ê½Ïò·þÎñÆ÷¶ËÈ¡µÃTXTÎļþÖеÄÄÚÈÝ£¬²¢¼ÓÒÔÏÔʾ¡£Ê×ÏÈ£¬Çë×¼±¸Ò»¸öHelloAjax.aspx(HTMLÒ²¿É)£º
*HelloAjax.aspx
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="HelloAjax.aspx.cs" Inherits="HelloAjax._Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD ......
Ê®Ììѧ»áASP.net֮ʵսϵÁУ¨C#ºÍVb.netË«°æ±¾£©
µÚÒ»Ìì
ÎÒÈÏΪASP.NET±ÈASPÄѺܶ࣬ϣÍû´ó¼Ò×öºÃ×¼±¸¡£ÄÑÄÑÔÚʵÏÖͬһ¸öЧ¹ûÓкܶ෽·¨£¬´ó¼Ò»òÐí»áÒÉ»ó¡£Ê®Ììѧ»áϵÁн̳̻áÇåÎúµÄд³ö¸÷ÖÖ·½·¨£¬Èôó¼ÒÄÜÉÙÒ»µã¿²¿À¡£ÔÚASPÀïÃæ£¬´ó¼Ò¼¸ºõ¶¼ÊÇʹÓÃVB£¬Êý¾Ý¿âÂҲÎÞ·ÇÊÇSQLºÍACCESS¡£ÔÚASP.NETÀïÃæ£¬Êý¾Ý¿â»¹ÊÇÕ ......
'´´½¨Êý¾Ý¿â
Private Sub Create(ByVal mdbPath As String)
If File.Exists(mdbPath) Then
Throw New Exception("Ä¿±êÊý¾Ý¿âÒѾ´æÔÚ£¬ÎÞ·¨´´½¨")
......
protected void Button1_Click(object sender, EventArgs e)
{
/*=============²âÊÔͨ¹ý===============*/
OleDbConnection con = new
OleDbConnection("Provider=Microsoft.Jet.OleDb.4.0;Data
Sou ......
C# SQLÊý¾Ý¿â²Ù×÷ͨÓÃÀà
using System;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Collections;
namespace Framework.DataBase
{
///
/// ͨÓÃÊý¾Ý¿âÀà
///
public class DataBase
{
private string ConnStr = null;
public DataBase()
{
&nb ......