/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 vote119 views1 answer
How to sign in with your unity id in unity hub
C#
2 votes144 views3 answers
Constructor definition
C#
0 vote230 views1 answer
Best programming language for compression ratio
C#
4 votes123 views1 answer
Make winforms full-screen c#
C#
0 vote125 views2 answers
Visual studio auto generate and setters
C#
0 vote118 views1 answer
Asp.net core relative file path within console app
C#
1 vote122 views2 answers
Fix Module not found: Error: Can't resolve '@fortawesome/free-solid-svg-icons'
C#
1 vote120 views1 answer
Assign datasource to dropdownlist in c#
C#
1 vote123 views1 answer
C# separate string by a new line
C#
0 vote117 views2 answers
How many days till christmas
C#