/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 vote161 views1 answer
Singly linked list c#
C#
0 vote197 views1 answer
Unity get game version
C#
3 votes214 views1 answer
C# read text file to list string
C#
0 vote211 views1 answer
Make character move upward forever unity 2d
C#
13 votes205 views3 answers
Unity how to move an object
C#Unity
2 votes265 views1 answer
How to remove space between string in c#
C#
0 vote231 views2 answers
Material.icons for wpf
C#
0 vote202 views1 answer
Forces the user to enter his password before submitting the form asp.net core
C#
1 vote187 views1 answer
How to chagne rotation in unity
C#
0 vote218 views1 answer
Rotate gameobject unity
C#