/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 vote106 views1 answer
TextBox filling in C#
C#
0 vote97 views1 answer
Get all classes that extend a class c#
C#
26 votes137 views4 answers
Onkeypressed unity
C#Unity
2 votes102 views3 answers
C# while true loop
C#
1 vote168 views1 answer
Unity how to set an objects postion x,y,z
C#Unity
0 vote104 views1 answer
Print arraylist values to console unity
C#
2 votes112 views1 answer
How to type to console in unity
C#
1 vote89 views1 answer
C# const string array
C#
0 vote94 views1 answer
Write last line txt file c#
C#
2 votes93 views2 answers
C# dictionary values to list
C#