/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

31 votes155 views3 answers
Raycast unity
C#Unity
0 vote139 views1 answer
Could not load file or assembly 'Ubiety.Dns.Core, Version=2.2.1.0
C#
0 vote118 views1 answer
Lambda C# select any perform action list call function
C#
0 vote167 views1 answer
Local to global position unity
C#Unity
0 vote170 views1 answer
Connect To MongoDB From A Different Machine
C#
0 vote154 views1 answer
Freeze scene unity
C#Unity
55 votes167 views6 answers
C# print
C#
1 vote127 views1 answer
Search a value into a list int list in c#
C#
0 vote139 views2 answers
Dynamic c# .add
C#
3 votes120 views1 answer
Unity how to rotate something to point to something else
C#