/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 vote122 views1 answer
C# .net core convert string to enum
C#
0 vote127 views1 answer
Sort file name with C#
C#
0 vote135 views1 answer
Set dirty a property unity custom inspector
C#
0 vote91 views1 answer
Ef core count
C#
0 vote135 views1 answer
Alpahbet incremnet in c#
C#
1 vote158 views2 answers
Windows form textbox numbers only
C#
0 vote157 views1 answer
How to prevent or terminate time's up screen from windows family safety windows service c#
C#
98 votes231 views6 answers
Convert string to number C#
C#
0 vote129 views1 answer
Convert relative path to physical path c#
C#
1 vote181 views1 answer
Make an object disappear from a c# script unity
C#Unity