dataset help

[Guest]

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]]

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