/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 vote240 views1 answer
Taskcontinuationoptions.onlyonfaulted
C#
4 votes278 views1 answer
How to reference a child object unity
C#Unity
0 vote250 views1 answer
C# random sleep
C#
1 vote255 views1 answer
How to make error sound c#
C#
0 vote242 views1 answer
C# for loop next iteration
C#
1 vote245 views1 answer
Asp net c# compare date to current
C#
0 vote257 views3 answers
Instantiate object inside of object Unity
C#
12 votes281 views2 answers
Doing void when gameobject setactive unity
C#
1 vote241 views1 answer
Regex only letters and numbers c#
C#
0 vote283 views1 answer
Count the Number of Duplicate Characters
C#