dataset help

Guest · Sep 12, 2007

hi,
i need help on setting datatype of a table's column at runtime..
i'm loading a dataset from an xml file...
after loading, i want to set the datatype of one of the column as int32..

how can i acheive it..
is there any way to set the datatypes of the columns before loading the data
from xml file..
please help out

Cor Ligthert[MVP] · Sep 13, 2007

Hi,

You cannot set easily all existing columns in SQL server to another format.
And there where it is possible it is probably not in your interest.

However you can by just creating the Create statement and the
command.SqlNonQuery do a lot.

http://www.vb-tips.com/CreateSqlDatabase.aspx

Cor

dataset help

Guest

Cor Ligthert[MVP]