/C#/Vbnet programatically convert type to db type

Vbnet programatically convert type to db type

using Microsoft.SqlServer.Server; // SqlDataRecord and SqlMetaData
using System;
using System.Collections; // IEnumerator and IEnumerable
using System.Collections.Generic; // general IEnumerable and IEnumerator
using System.Data; // DataTable and SqlDataType
using System.Data.SqlClient; // SqlConnection, SqlCommand, and SqlParameter
using System.Web.UI.WebControls; // for Parameters.Convert... functions

private static SqlDbType TypeToSqlDbType(Type t) {
    DbType dbtc = Parameters.ConvertTypeCodeToDbType(t.GetTypeCodeImpl());
    SqlParameter sp = new SqlParameter();
    // DbParameter dp = new DbParameter();
    // dp.DbType = dbtc;
    sp.DbType = dbtc;
    return sp.SqlDbType;
}

Source: stackoverflow.com

Similar codes

27 votes123 views3 answers
Basic movement script unity
C#
53 votes180 views6 answers
Load scene unity
C#
42 votes134 views2 answers
How to replace last character of string in c#
C#
0 vote128 views1 answer
Unity SceneTemplatePipeline
C#
4 votes172 views2 answers
Check if gameobject exists unity
C#Unity
37 votes128 views5 answers
How to generate random number in unity
C#
0 vote241 views1 answer
Best programming language for compression ratio
C#
0 vote131 views1 answer
Encrypt with public key and decrypt with private key c#
C#
0 vote130 views1 answer
Wpf rotate component
C#
3 votes164 views1 answer
How do I print something in the console at the start of the game unity
C#Unity