Programmatically pull data types for MS SQL table columns for later insertion

Question

Rails has an awesome way of looking up column names and expected datatypes from the DB, alleviating a lot of programming.

I'm trying to build something like this in C#.NET, because we have large tables that are ever changing. I'll be adding parameters like so:

SqlParameter param = new SqlParameter("parametername", *SqlDbType.Int*);
param.Direction = ParameterDirection.Input;
param.Value = 0;
comm.Parameters.Add(param);

Notice the SqlDbType. How can I get that? If I get DataColumns from the DataSet, all I can get is System types like System.string.

tsilb · Accepted Answer · 2008-11-07 19:27:10Z

2

why not just let ADO.NET detect it automatically:

SqlParameter param = new SqlParameter("parametername", value);

'course, you don't actually need Direction, either:

comm.Parameters.Add(new SqlParameter("parametername",value));

I'm kind of a fan of doing things in one line :)

answered Nov 7, 2008 at 19:27

tsilb

8,04514 gold badges74 silver badges100 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Tinister · Accepted Answer · 2008-11-07 19:28:45Z

1

For our project we query the INFORMATION_SCHEMA tables before we build our SQL statements. If you stick the value in DATA_TYPE from INFORMATION_SCHEMA.COLUMNS into an Enum.Parse that should give you the correct value.

answered Nov 7, 2008 at 19:28

Tinister

11.6k6 gold badges39 silver badges37 bronze badges

Collectives™ on Stack Overflow

Programmatically pull data types for MS SQL table columns for later insertion

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related