/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

-1 vote238 views1 answer
Linq from list c#
C#
1 vote252 views1 answer
Mapping dictionary to object c#
C#
0 vote257 views1 answer
C# Create Swiss QR-Bill API
C#
0 vote267 views1 answer
Unity run all interfaces
C#Unity
0 vote226 views1 answer
Gegenstände bewegen c#
C#
1 vote259 views1 answer
How create another new app file in laravel
C#
13 votes250 views1 answer
Check for collision unity c#
C#
27 votes252 views6 answers
Stack over flow
C#
0 vote262 views1 answer
How to filter a datatable in c#
C#
0 vote231 views1 answer
Dynamic group by expression C#
C#