/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

1 vote110 views1 answer
Convert string to int and read it
C#
0 vote106 views1 answer
Listbox1.remove item c#
C#
2 votes177 views1 answer
Unity run void from another script
C#Unity
0 vote124 views1 answer
VLC .net
C#
0 vote100 views1 answer
Linq query to fetch parent child data from same table in c#
C#
0 vote146 views1 answer
Iterate througha game object in unity
C#Unity
0 vote97 views1 answer
Header export excel data only php
C#
0 vote66 views1 answer
Create a xml file with c# and use xmlwriter to write to class
C#
0 vote101 views1 answer
Change name of gameobject
C#
0 vote142 views2 answers
Unity 2d top down movement script
C#Unity