/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

5 votes142 views2 answers
Read text file to string c#
C#
1 vote155 views1 answer
How c# connection
C#
5 votes145 views2 answers
Regions unity
C#
8 votes136 views3 answers
Functions c#
C#
34 votes151 views3 answers
Unity get all by tag
C#
0 vote160 views1 answer
Order by and then by c#
C#
31 votes244 views3 answers
Create new gameobject unity
C#Unity
11 votes181 views2 answers
Unity 2d raycast mouse
C#Unity
3 votes179 views1 answer
Unity if in editor
C#Unity
3 votes166 views2 answers
.net c# print object
C#