/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 vote144 views1 answer
Unity ar scale
C#Unity
0 vote123 views1 answer
What dotnet command does
C#
0 vote148 views1 answer
Monogame print
C#
27 votes125 views3 answers
Unity get textmesh pro component
C#
-2 votes165 views1 answer
C# error
C#
4 votes130 views1 answer
Unity check when clicked on object
C#
3 votes132 views2 answers
C# float
C#
0 vote143 views1 answer
Asp.net mvc class="" inline select
C#
0 vote134 views1 answer
C# datagridview multiple row selection without control
C#
0 vote137 views1 answer
Hardcode dropdown cshtml
C#