/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 vote336 views1 answer
Google script get font color
C#
0 vote344 views1 answer
Unity read from text file
C#Unity
7 votes281 views2 answers
Instantiate gameobject as child
C#
0 vote317 views1 answer
Functions unity
C#Unity
-1 vote279 views2 answers
Escape in c#
C#
0 vote352 views1 answer
Unity create file name datetime
C#Unity
27 votes289 views4 answers
Player movement script unity
C#
0 vote353 views1 answer
Unity apply bloom of a different color
C#Unity
0 vote329 views1 answer
How to iterate a generic list in c#
C#
21 votes285 views6 answers
Button group bootstrap
C#