C#Á¬½ÓAccessºÍSQL ServerÊý¾Ý¿â
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Data.OleDb;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace Str
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
/*
* connect to Sql Server
*/
string strConnection = "Data Source=ZRQ-PC;";
strConnection+="Initial Catalog=master;Integrated Security=True";
SqlConnection objConnection = new SqlConnection(strConnection);
objConnection.Open();
objConnection.Close();
/**************************************************************/
/*
* connect to access table
*/
//string strConnection = "Provider=Microsoft.Jet.OleDb.4.0;";
//strConnection += @"Data Source=C:\Users\ZRQ\Documents\STU.accdb";
//OleDbConnection objConnection = new OleDbConnection(strConnection);
//objConnection.Open();
//objConnection.Close();
/**************************************************************/
/*
*as for connect to Oracle or MySql µÈÎÒѧÁËÔÙ˵°É……(*^__^*)
*/
}
}
}
ÆäÖеļòÒ×°ì·¨£º
ÔÚ“·þÎñÆ÷×ÊÔ´¹ÜÀíÆ÷”ÖÐÑ¡ÔñÒªÁ¬½ÓµÄÊý¾Ý£¬then¿´ËüµÄÊôÐÔÖÐName£¬copy to strConnection ¼´¿É~
Ïà¹ØÎĵµ£º
ÔÚ¼¤ÁÒµÄÊг¡¾ºÕù»·¾³Ï£¬ÉÌÈ˶ÔÊг¡»·¾³µÄ°ÑÎպ;ö²ßÖ±½Ó¹ØÏµµ½Êг¡µÄÇ÷ÊÆºÍ»úÓö£¬¶Ô¿Í»§ÐèÇóµÄ¿ìËÙÏàÓ¦Äܹ»Õ¼¾¡Êг¡µÄÏÈ»ú¡£ÔÚµ±½ñÉç»áµÄÈÕ³£ÉÌÎñ»î¶¯ÖУ¬ÒÔÍù»ýÀÛµÄÏà¹ØÉÌÒµÊý¾ÝÄܹ»ÎªºóÐøµÄÒµÎñ»î¶¯ÌṩÁ¼ºÃµÄ²Î¿¼ºÍÏòµ¼¡£ÔçÔÚ10ÓàÄêǰ£¬ÉÌÒµÖÇÄÜ£¨Business Intelligence£¬Ï³ÆBI£©³§É̾ÍÒѾ ......
±¾ÎÄÀ´×Ô£ºhttp://zhidao.baidu.com/question/27978123.html?si=1
ÕâЩÊÇ SQL-92 ÉèÖÃÓï¾ä£¬Ê¹ SQL Server 2000/2005 ×ñ´Ó SQL-92 ¹æÔò¡£
µ± SET QUOTED_IDENTIFIER Ϊ ON ʱ£¬±êʶ·û¿ÉÒÔÓÉË«ÒýºÅ·Ö¸ô£¬¶øÎÄ×Ö±ØÐëÓɵ¥ÒýºÅ·Ö¸ô¡£µ± SET QUOTED_IDENTIFIER Ϊ OFF ʱ£¬±êʶ·û²»¿É¼ÓÒýºÅ£¬ÇÒ±ØÐë·ûºÏËùÓÐ Transact-SQL ±êÊ ......
Êý¾ÝÀàÐÍ:
Ò»¡¢ ÕûÊýÊý¾ÝÀàÐÍ
INT(INTEGER) 4
SMALLINT 2
TINYINT 1
BIGINT & ......
a £½ “Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\Êý¾Ý¿â.mdb;Password=¹ÜÀíÔ±ÃÜÂë;User ID=¹ÜÀíÔ±ÕʺÅ;Jet OLEDB:Database Password=Êý¾Ý¿âÃÜÂë;Jet OLEDB:System database=d:\system.MDW;” ' ´Ë´¦Óû§ÕÊ»§±ØÐë¾ßÓйÜÀíԱȨÏÞ²ÅÐÐ,´Ë´¦ÊÇÖ¸Á¬½ÓÐèҪѹËõµÄÊý¾Ý¿âµÄÁ¬½Ó´úÂë.
b £½ &ldq ......
×ö±ÏÒµÉè¼Æ£¬×î³õ¿¼Âǵ½·½±ãÐÔ£¬ÔÚÑ¡ÔñÊý¾Ý¿âʱ¾ÍÓÃÁËAccess£¨¿ÉÒÆÖ²ÐÔ̫ǿÁË£©£¬ÔÚ²âÊÔʱÅ׳öÁËÕâÑùµÄ´íÎó£º
System.Data.OleDb.OleDbException: INSERT INTO Óï¾äµÄÓï·¨´íÎóÒì³£
±éÑ°ÍøÉϸßÈË£¬Ëµ·¨¶¼¸÷²»Ò»Ñù£¬²»¹ý×îºó»¹ÊÇÕÒµ½ÁËÎÊÌâËùÔÚ£ºAccess±£Áô×Ö£¡
ÒòΪÔÚÊý¾Ý¿âÉè¼ÆÊ±Ã»Óп¼Âǵ½ÁÐÃû»áÓëAccess±£Áô×ÖÖØ¸´£¬Ëì ......