Convert string[] to sqldbtype[] ?????

Accepted answer

0

Thanks both of you for help!!

0

Vulpes12y ago

Try this:

using System;

using System.Data;

using System.Linq;

class Test

{

static void Main()

{

string[] dbtypes = {"NVARCHAR", "INT", "BIT"};

Type t = typeof(SqlDbType);

SqlDbType[] sqldbtypes = dbtypes.Select(d => (SqlDbType)Enum.Parse(t, d, true)).ToArray();

// check it worked

foreach(SqlDbType s in sqldbtypes) Console.WriteLine(s);

Console.ReadKey();

}

}

The output is:

NVarChar

Int

Bit

0