SQL SERVERÓëC#µÄÊý¾ÝÀàÐͶÔÓ¦±í
ÐòºÅ
Àà±ð
SQLServer
C Sharp
±¸×¢
1
ÕûÊý
bit
Boolean
Trueת»»Îª1Falseת»»Îª0
2
tinyint
Byte
C Sharp Êý¾ÝÀàÐͶ¼Î»ÓÚSystemÃüÃû¿Õ¼ä
3
smallint
Int16
4
int
Int32
5
bigint
Int64
6
smallmoney
Decimal
7
money
Decimal
8
numeric
Decimal
9
decimal
Decimal
10
¸¡µãÊý
float
Double
11
real
Single
12
ÈÕÆÚºÍʱ¼ä
smalldatetime
DateTime
13
datetime
DateTime
14
timestamp
DateTime
15
×Ö·û´®
char
String
16
text
String
17
varchar
String
18
nchar
String
19
ntext
String
20
nvarchar
String
21
¶þ½øÖÆÊý¾Ý
¡¡
¡¡
binary
Byte[]
22
varbinary
Byte[]
23
image
Byte[]
24
ÆäËû
uniqueidentifier
Guid
25
Variant
Object
PS.±¾À´´òËã×ªÔØTrackback: http://tb.blog.csdn.net/TrackBack.aspx?PostId=95675(SQL SERVERÓëC#ÖÐÊý¾ÝÀàÐ͵ĶÔÓ¦¹ØÏµ) ,µ«¾õµÃ×÷ÕßÒÔ´úÂëµÄ·½Ê½Ð´³öÀ´,¿´ÆðÀ´²»ÊÇÄÇôֱ¹Û,²éÕÒÒ²²»·½±ã.ËùÒԲο¼ÁË×÷ÕßµÄÎÄÕºÍSQLServer05µÄ°ïÖúÎĵµÖÆ×÷ÁËÒÔÉÏÕâ¸ö±í¸ñ.
Trackback: http://tb.blog.csdn.net/TrackBack.aspx?PostId=1288946
/// <summary>
/// Êý¾Ý¿âÖÐÓëc#ÖеÄÊý¾ÝÀàÐͶÔÕÕ
/// </summary>
/// <param name="type"></param>
/// <returns></returns>
private string changetocsharptype(string type)
{
string reval=string.empty;
switch(type.tolower())
{
case "int":
reval= "int32";
break;
case "text":
reval= "string";
break;
case "bigint":
reval= "int64";
break;
case "binary":
reval= "system.byte[]";
break;
case "bit":
reval= "boolean";
break;
case "char":
reval= "string";
b
Ïà¹ØÎĵµ£º
ÓõÄÊÇÒ»Öֺܱ¿µÄ·½·¨£¬µ«¿ÉÒÔ°ïÖú³õѧÕßÁ˽â·ÃÎÊXML½ÚµãµÄ¹ý³Ì¡£
ÒÑÖªÓÐÒ»¸öXMLÎļþ£¨bookstore.xml£©ÈçÏÂ:
<?xml version="1.0" encoding="gb2312"?>
<bookstore>
<book genre="fantasy" ISBN="2-3631-4">
<title>Oberon's Legacy</title>
&n ......
C#Á¬½ÓMySQLÊý¾Ý¿â·½·¨
1¡¢ÓÃMySQLDriverCSÁ¬½ÓMySQLÊý¾Ý¿âÏÈÏÂÔØºÍ°²×°MySQLDriverCS£¬µØÖ·£º
http://sourceforge.net/projects/mysqldrivercs
ÔÚ°²×°Îļþ¼ÐÏÂÃæÕÒµ½MySQLDriver.dll£¬È»ºó½«MySQLDriver.dllÌí¼ÓÒýÓõ½ÏîÄ¿ÖÐ
×¢£ºÎÒÏÂÔØµÄÊǰ汾ÊÇ MySQLDriverCS-n-EasyQueryTools-4.0.1-DotNet2.0.exe
using System; ......
ÔÚдsqlÓï¾äʱ£¬Ò»°ã¶¼ÊÇÒ»¾ä½â¾ö£¬´ÓÀ´Ã»Ïë¹ý˵£¬°ÑsqlÓï¾ä²ð¿ªÀ´Ð´¡£
ÀýÈçÏÂÃæÕâ¾ä£º string readstring = "select * from ʵÀý where ʵÀýID='"+eid+"'";
È»ºóÖ´ÐÐ Myconnection();
DataSet ds = new DataSet();
OleD ......
ÓÃÁËADO.NET 2.0 SQLite Data Provider ÕâÑù¿ÉÒÔÖ±½ÓÀûÓÃËüÀ´´´½¨Ò»¸ö¼ÓÃܵÄsqliteÊý¾Ý¿â¡£
ÓйØc#´úÂëÈçÏ£º
1¡¢´´½¨¿ÕµÄsqliteÊý¾Ý¿â¡£
//Êý¾Ý¿âÃûµÄºó׺Äã¿ÉÒÔÖ±½ÓÖ¸¶¨£¬ÉõÖÁûÓкó׺¶¼¿ÉÒÔ
//·½·¨Ò»£º´´½¨Ò»¸ö¿ÕsqliteÊý¾Ý¿â£¬ÓÃIOµÄ·½Ê½
FileStream fs = File.Create(“c:\\test.db“);
//·½·¨¶þ£ºÓ ......