/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

10 votes340 views1 answer
Set width of rect transform unity
C#
0 vote348 views1 answer
C# filter non alphanumeric characters
C#
0 vote342 views1 answer
System.drawing.color to system.consolecolor
C#
0 vote361 views1 answer
C# on variable change property get set
C#
44 votes376 views6 answers
C# byte array to string
C#
0 vote342 views1 answer
Sort number in dynamo
C#
1 vote361 views1 answer
C# swtich
C#
-1 vote408 views1 answer
C# recursion formula for the factorial
C#
0 vote454 views1 answer
Is list sequential C#
C#
1 vote433 views1 answer
Nested dictionary c#
C#