/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

3 votes105 views1 answer
Read folder c#
C#
1 vote137 views2 answers
Unity for loop array
C#Unity
1 vote123 views1 answer
Unity character controller ignore collision
C#
0 vote111 views1 answer
Asp.netcore: develop on win10 run on ubuntu
C#
0 vote113 views1 answer
C# add key value pair to dictionary
C#
0 vote120 views1 answer
Translate nicely between two vector3
C#
3 votes121 views4 answers
Get user by username c#
C#
0 vote71 views2 answers
As keyword c#
C#
6 votes105 views6 answers
C# for loop
C#
6 votes117 views2 answers
Left moust click unity
C#