/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 vote192 views1 answer
Change vignette intensity unity
C#Unity
16 votes183 views2 answers
C# delete file if exists
C#
0 vote177 views1 answer
Unity get quaternion z
C#Unity
0 vote210 views1 answer
How to chceck for a tag in a trigger enter 2d unity
C#Unity
0 vote180 views1 answer
C# unhandled exception in thread”
C#
0 vote180 views1 answer
Unity camera follow with lerp
C#
0 vote161 views1 answer
C# sum object values
C#
0 vote160 views1 answer
How to auto format c# code in visual studio
C#
0 vote188 views1 answer
Asp.net throw unauthorized exception
C#
1 vote203 views1 answer
C# how to remove an image in a folder
C#