/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 vote234 views1 answer
Dapper c# insert range
C#
0 vote179 views2 answers
Unity list get item at index
C#
3 votes133 views2 answers
Remove duplicate char from string c#
C#
1 vote192 views1 answer
Unity C# make object face away
C#
0 vote237 views1 answer
How to run code without a gameobject unity
C#Unity
0 vote175 views1 answer
How to check type c#
C#
1 vote175 views1 answer
Toggle unity c#
C#
3 votes169 views2 answers
Switch case c# range
C#
2 votes160 views1 answer
Assign same value to multiple variables
C#
0 vote253 views1 answer
Unity draw waypoins path
C#