/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

0 vote225 views1 answer
Failed to generate swagger file. Error dotnet swagger tofile --serializeasv2 --output
C#
0 vote206 views1 answer
HMD Motion Emulation
C#
0 vote188 views1 answer
Close windows by esc wpf
C#
1 vote198 views1 answer
C# combine list of bool
C#
1 vote223 views1 answer
Remove all non number in c#
C#
28 votes205 views2 answers
C# file exist
C#
0 vote214 views1 answer
Type or namespace text could not be found unity
C#Unity
1 vote191 views1 answer
Comapre Binary Trees
C#
7 votes171 views5 answers
C# or
C#
0 vote205 views1 answer
Unity master volume changer
C#