/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

26 votes192 views1 answer
C# date formats custom
C#
0 vote200 views4 answers
Read csv file into wpf C#
C#
4 votes190 views2 answers
C# remove word from string
C#
2 votes184 views2 answers
C# winforms select folder dialogue
C#
3 votes206 views1 answer
Unity how to wait for seconds without coroutine
C#
0 vote217 views1 answer
Unity master volume changer
C#
9 votes248 views1 answer
Unity get layer of gameobject
C#Unity
2 votes206 views1 answer
C# to binary
C#
0 vote237 views1 answer
C# url relative path remove
C#
0 vote330 views1 answer
Vb.net wait 1 second
C#