The correspondence between SQL Server and C # data types in C #

xiaoxiao2021-03-06  65

? /// ?? /// Database in the data type control in the C # ?? /// ?? /// ?? ///

?? private string chantocsharptype (string type) ?? {??? string revAL = string.empty; ??? switch (type.tolower ()) ??? {???? case "int": ???? REVAL = "int32"; ????? Break; ???? case "text": ????? Reval = "string"; ????? breaf; ???? case "bigint": ????? Reval = "int64"; ????? breaf; ???? case "binary": ????? revAL = "system.byte []"; ????? Break;? ??? Case "bit": ????? revAL = "boolean"; ????? Break; ???? case "char": ????? Reval = "string"; ???? ? Break; ???? case "datetime": ????? revAL = "system.datetime"; ????? breaf; ???? case "decimal": ????? reval = system .DECIMAL "; ????? breaf; ???? case" float ": ????? revAL =" system.double "; ????? Break; ???? case" image ":? ???? revAL = "system.byte []"; ????? Break; ???? case "money": ????? Reval = "system.decimal"; ????? Break; ???? case "nchar": ????? revAL = "string"; ????? breaf; ???? case "ntext": ????? Reval = "string";??? ?? Break; ???? case "Numeric": ????? Reval = "system.decimal"; ????? Break; ???? case "nvarchar": ????? Reval = " "; ????? breAk; ???? case" real ": ????? revAL =" system.single "; ????? Break; ???? case" smalldatetime ": ?? ??? revAL = "SYST Em.datetime "; ????? Break; ???? case" smallint ": ????? Reval =" int16 "; ????? breaf; ???? case" smallmoney ": ?? ??? Reval = "system.decimal"; ????? breaf; ???? case "timestamp": ????? revAL = "system.datetime"; ????? breaf;??? Case "tinyint": ????? Reval = "system.byte"; ????? Break; ???? case "uniqueidentifier": ????? revAL = "

转载请注明原文地址:https://www.9cbs.com/read-119869.html

New Post(0)