/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 vote260 views2 answers
Linear search c#
C#
44 votes238 views5 answers
C# error messagebox
C#
2 votes245 views1 answer
Import C++ into C#
C#
0 vote254 views1 answer
Convert list of string to dictionary
C#
0 vote194 views1 answer
Unity download image from web
C#Unity
1 vote217 views1 answer
C# hex to console color
C#
10 votes238 views3 answers
Get percentage c#
C#
3 votes234 views3 answers
Convert ienumerable to list
C#
2 votes250 views1 answer
Unity c# throw exception
C#Unity
0 vote257 views1 answer
Assert.Equal
C#