How to Create data base table from other database table in C#

Question

0.00/5 (No votes)

See more:

Hello everyone, Am working with c# and Sql server 2005 , I want to create a database using with c# from existing database ...
but i have find some error in my code, ie.

C#

SqlConnection sqlcon = new SqlConnection("Data Source=.\\SQLEXPRESS;initial catalog=;Integrated Security=SSPI;User Instance=True");
sqlcon.Open();
SqlCommand sqlcmd = new SqlCommand("SELECT * INTO imgsoftware.dbo.ram4 FROM TBLADMIN", sqlcon);
sqlcmd.ExecuteNonQuery();
sqlcon.Close();

error is: Database 'imgsoftware' does not exist. but i have this database

if someone have any solution of this problem tell me..

Thanx ....

Posted 24-Jan-12 19:33pm

manish the error

Updated 24-Jan-12 20:01pm

Michel [mjbohn]

v2

Add a Solution

5 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

pravallika tumuluri · Answer 1 · 2012-01-24T19:47:00

Solution 1

Hi,

http://www.functionx.com/csharp1/adonet/Lesson04.htm

Hope this url is helpfull to you.

Posted 24-Jan-12 19:47pm

pravallika tumuluri

Updated 24-Jan-12 20:58pm

v2

Comments

manish the error 25-Jan-12 2:01am

Thanx for it , But my problem is , i want to create a database table from another existing database table... and in this url not have any information about it,,
please send me another solution ...

**AmitGajjar** · Answer 2 · 2012-01-24T22:13:00

Solution 2

Hi,

You need to execute CREATE TABLE....AS query for that.

check this link.

you also need to specify your database name along with your table name.

hope it will help you,

thanks
-Amit.

Posted 24-Jan-12 22:13pm

AmitGajjar

Updated 24-Jan-12 22:14pm

v2

Comments

manish the error 25-Jan-12 4:39am

thnx for rply , but i want to create a database table from another database table ie.
run this code in your sql server manegment studio===
SELECT * INTO imgsoftware.dbo.ram4 FROM ram.dbo.TBLADMIN

i want to execute this code in c#, if you have any solution please send me...

Thnx

AmitGajjar 25-Jan-12 4:46am

it works fine in Management studio. what error you are getting with C# code ?

AmitGajjar 25-Jan-12 4:47am

are you sure you have rights on imgsoftware database ?

AmitGajjar 25-Jan-12 4:48am

using windows authentication are you able to do everything on imgsoftware database ? please check permission.

manish the error 25-Jan-12 4:53am

yes i am working with full authentication in windows bt it's not working...
i hav got a error eg.
Database 'imgsoftware' does not exist. but i have this database

if u have another solution for this send me.
if u have another way for doing this send me , i want to create a database table from other database...

thnx

AmitGajjar 25-Jan-12 4:56am

you mean to say, you want to copy table even if imgsoftware does not exist ? is this what you want ?

manish the error 25-Jan-12 5:00am

no both database are exist,
i want to create a table in a database using an another database table ,means same schema....

AmitGajjar 25-Jan-12 5:11am

if it is giving Database 'imgsoftware' does not exist. then there must be 2 reason, 1) database not exist 2) required permission/ credentials are incorrect. check manually with other database. or create dummy database and try this query.

manish the error 25-Jan-12 5:22am

i have use this code with different different database , but it's give me same error , so it's not a database error , it's c# error .......
i don't know that how can i work with different database in same time in c#.
It's code not working with same database also in c#... so it's a c# code error.....please check, and if u have another solution send me
Thnx...

AmitGajjar 25-Jan-12 6:22am

i have executed same query using ExecuteNonQuery and it is working fine ...

manish the error 25-Jan-12 6:31am

thanx for the help , i have executed this query in different system and it's working fine, with same database, it was system problem...
thanks again.....

if u don't mind give me your mail id...

Sanjay K. Gupta · Answer 3 · 2012-01-24T22:23:00

Solution 3

Create table DatabaseName.schemaName.tableName
.............
...............

eg.

Create table Test.dbo.Testing(id int)

Posted 24-Jan-12 22:23pm

Sanjay K. Gupta

Comments

manish the error 25-Jan-12 4:42am

thnx for rply ...
but please read this question properly....

and if you have any solution please send me it

thnx

Abdul Quader Mamun · Answer 4 · 2012-01-24T22:31:00

SqlConnection sqlcon = new SqlConnection("Data Source=.\\SQLEXPRESS;initial catalog=;Integrated Security=SSPI;User Instance=True");
sqlcon.Open();
SqlCommand sqlcmd = new SqlCommand("SELECT * INTO imgsoftware.dbo.ram4 FROM TBLADMIN", sqlcon);

SqlCommand sqlcmd = new SqlCommand("SELECT * INTO ram4 FROM TBLADMIN", sqlcon);
--This is not a create table command

SqlCommand sqlcmd = new SqlCommand("Create Table yourTable(Id int)", sqlcon);

sqlcmd.ExecuteNonQuery();
sqlcon.Close();

Thanks
Mamun

Kanasz Robert · Answer 5 · 2012-01-24T22:39:00

Solution 5

Hi,

try to set catalog property of connection string.

Regards
Robert

Posted 24-Jan-12 22:39pm

Kanasz Robert

Comments

manish the error 25-Jan-12 4:48am

thnx for the rply sir ...
but i have seted all thise property bt its not working ,,,, if u have any ather solution please send me...

thnx again

How to Create data base table from other database table in C#

5 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Solution 5

Add your solution here

Preview 0

Existing Members

...or Join us