/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 vote322 views1 answer
Unity closest point to line
C#
0 vote325 views1 answer
Exception handling in c# web api
C#
0 vote288 views1 answer
Unity make a homing object
C#
1 vote328 views1 answer
How is c# pronounced
C#
7 votes332 views6 answers
C# how to exit program
C#
2 votes324 views1 answer
Core Request.CreateResponse
C#
3 votes295 views1 answer
Move file from one folder to another c#
C#
0 vote435 views1 answer
Unity magnetize a 3d object to cursor
C#Unity
0 vote355 views2 answers
Difference between %e/E, %f/F and %g/G in program C
C#
2 votes297 views1 answer
C# list.foreach
C#