/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 vote130 views1 answer
Create material unity script
C#Unity
117 votes238 views6 answers
Random number in C#
C#
9 votes113 views2 answers
How to convert float to int c#
C#
0 vote104 views1 answer
How to make a 2d character move in unity 2020
C#
1 vote103 views1 answer
C# convert int to pretty string
C#
3 votes107 views3 answers
Loop in c#
C#
0 vote101 views1 answer
Winforms how to check for enter key
C#
0 vote101 views1 answer
Select every second row in html table
C#
0 vote100 views1 answer
How unsort the data table options
C#
0 vote102 views1 answer
How to make a draggable visual studio panel
C#