/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 vote364 views1 answer
C# list audio devices
C#
0 vote339 views1 answer
Integer required asp.net core
C#
-1 vote349 views1 answer
Entity framework id not auto increment
C#
0 vote336 views1 answer
List of 2 different iherent classes c#'
C#
0 vote328 views1 answer
Get file id from mongodb without objectid using c#
C#
0 vote346 views1 answer
Check c# date for 0001/01/01
C#
0 vote366 views1 answer
C# insert spaces before capital letters
C#
0 vote444 views1 answer
Unity trygetcomponent
C#Unity
0 vote328 views2 answers
ToLocalIsoString() vs toIsoString()
C#
1 vote353 views1 answer
In what occasions do you use void update and fixedupdate C# unity
C#