/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

10 votes344 views6 answers
Unity mouse click
C#Unity
4 votes371 views1 answer
Unity mouse look script 2021
C#Unity
0 vote295 views1 answer
Computing a Cartesian product or Combinations with LINQ
C#
5 votes308 views2 answers
Asp.net core redirecttoaction with parameters
C#
2 votes330 views1 answer
How to turn string to int in unity
C#
28 votes302 views4 answers
How to add data in list in c#
C#
0 vote327 views1 answer
Wpf binding to static property in code behind
C#
0 vote318 views1 answer
C# set cursor to loading and back
C#
0 vote325 views1 answer
C# mail retrieve library
C#
1 vote302 views1 answer
Unity agent does not move
C#