/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

81 votes183 views5 answers
String to date
C#
-1 vote131 views1 answer
Linq c# or
C#
1 vote136 views2 answers
C# environment variables
C#
0 vote160 views1 answer
Select a whole row out of a 2d array C#
C#
0 vote147 views1 answer
C# get list item in random order
C#
0 vote120 views1 answer
How to seperate front of decimal and back of decimal in C#
C#
0 vote148 views1 answer
Limiting the amount of decimal places c#
C#
-1 vote149 views1 answer
How to add a componet to a gameobject throgh code unity
C#
2 votes133 views3 answers
Capitalize c#
C#
2 votes154 views1 answer
Unity player look at mouse
C#