Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Feb 04, 2010 09:14 AM by harrylynn
Jan 22, 2010 08:42 PM|LINK
Sorry if my subject seems confusing. I have been looking for a way to convert C# datatype into database specific type of MS SQL. For example when I do
Jan 22, 2010 09:48 PM|LINK
When you are passing parameters to a database, you can specify its parameter type.
So if you are passing in a uniqueidentifer to a sql stored procedure you would create a sqlparameter and set its type to one of the matchin enumeration values in the SqlDbType enum.
Jan 23, 2010 07:26 AM|LINK
Thanks for the tips. I think i have to refine my question a bit. What i'm trying to achieve is I have a table in one database and
I'm trying to copy that table into another database. So, in SQL create statement I might need to put like
CREATE TABLE WHATEVER ( column and its datatype)
Is there anyway to achieve this or umm would it b better off to just use SQL CREATE statement in query editor ? much thanks.
Jan 23, 2010 09:46 PM|LINK
Why dont you just do a table export?
Jan 24, 2010 12:33 PM|LINK
How about using SSIS to copy the tables from database to database?
Jan 26, 2010 12:28 AM|LINK
As suggested above, it's not easy to control it in source code. Always, we can take advantage of SQL script. That means you can either execute the SQL script in a query window directly or save and execute it from source code.
Feb 04, 2010 09:14 AM|LINK
Thanks all for all the replies.