/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 vote218 views1 answer
How to convert a key state to a letter in monogame
C#
0 vote314 views1 answer
Unity deadzone
C#
12 votes293 views3 answers
Git checkout reset hard
C#
0 vote279 views1 answer
Reverse a linked list C#
C#
0 vote307 views1 answer
Wpf scoll to on new item datagrtid
C#
0 vote331 views1 answer
Save string unity
C#
0 vote227 views1 answer
Convert linq query to json format
C#
0 vote286 views1 answer
C# do while or
C#
0 vote282 views1 answer
Vb.net remove last comma from string
C#
2 votes289 views1 answer
Find closest gameobject unity
C#