/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 vote291 views1 answer
Take screenshot in c#
C#
0 vote369 views1 answer
Delegates in UntiyC#
C#
4 votes268 views2 answers
Vector3 to quaternion C#
C#
1 vote314 views2 answers
Unity 2d looka tt mouse
C#Unity
0 vote291 views1 answer
Process start web document
C#
0 vote274 views1 answer
How to disable vsync in monogame
C#
0 vote325 views1 answer
How to use the mouse scroll wheel to move the camera in unity
C#Unity
0 vote276 views1 answer
Erewt
C#
1 vote259 views1 answer
The CodeDom provider type "Microsoft.CodeDom.Providers.DotNetCompilerPlatform.CSharpCodeProvider, Microsoft.CodeDom.Providers.DotNetCompilerPlatform, Version=2.0.1.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" could not be located.
C#
0 vote295 views1 answer
Xamarin forms uwp button hover
C#