Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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


Ïà¹ØÎĵµ£º

ASP.NET C# ÑéÖ¤Âë Ö§³ÖÖÐÎÄ Ôëµã ÍäÇú

/// <summary>
        /// ¸ù¾ÝÖ¸¶¨²ÎÊý·µ»ØBitMap¶ÔÏó
        /// ÒýÓÃÈçÏ£º
        /// using System.Drawing;
        /// µ÷ÓÃÀý×ÓÈçÏ£º
   ......

VBÓëC#»¥×ª¹¤¾ß

http://www.carlosag.net/Tools/CodeTranslator/ Õâ¸öÒ²Ðíѧ¼ÆËã»úµÄ¸ç¸ç½ã½ãÃÇ»áÓõõ½£¬£¬¾ÍתÁËÏ£Íû¶à¶àÖ§³ÖŶ Î÷Î÷  Óõõ½¾Í¶¥Å¶
²îµãÍüÁËŶ    £¬Åº»¹ÓÐÒ»¸ösqlµÄ²å¼þºÜºÃÓõÄѽ¡£¡£¡£¡£ÓÐÏëÒªµÄ¾ÍÁôÑÔÏÂÒª¿©¡£¡£¡£¡£¡£ ......

apss asp.net C# web ¶¨Ê±Ö´ÐгÌÐò

using System;
using System.Collections;
using System.ComponentModel;
using System.Web;
using System.Web.SessionState;
using System.Timers;
using System.Data;
using System.Data.SqlClient;
namespace SMS_joke
{
/// <summary>
/// Global µÄժҪ˵Ã÷¡£
/// </summary>
public class ......

C#Á¬½ÓsqlserverÊý¾Ý¿â


       µ±ÔÚC#ÓïÑÔÖУ¬Á¬½ÓsqlÊý¾Ý¿âµÄʱºò£¬³£Óõ½sqlconnection½¨Á¢ÓëÊý¾Ý¿âµÄÁ¬½Ó¡£ Óï·¨ÈçÏ£º
       String sqlcon = "***";//ÕâÀïÊÇÒ»¸ö×Ö·û´®£¬¾ßÌå¸úÊý¾Ý¿âµÄÑéÖ¤·½Ê½Óйء£
//sql server Éí·ÝÑéÖ¤ Á¬½Ó×Ö·û´®
private string ConnstrSqlServer = "server=·þÎñÆ÷Ãû³ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ