how to create dynamic tables in sql server using C#

Question

0.00/5 (No votes)

See more:

create the dynamic tables in sql server through C# based on input given by the user.
when user giving his/her name the c# code has to create table in sql server in their user name
EX:

SQL

string crt_table = "create table"+ Textbob_dept.Text +"Faculty(FacultyID nchar(30),Username nchar(30),Password nchar(30))";

SqlCommand com_tbl = new SqlCommand(crt_table, cnn);

help me to understand with example in step by step process..

Posted 11-Nov-14 3:34am

Elaa_zx

Updated 13-Nov-14 17:19pm

King Fisher

v4

Add a Solution

Comments

DamithSL 11-Nov-14 9:47am

any exceptions when you execute your sql statement?
you may need some spaces
string crt_table = "create table "+ Textbob_dept.Text +"Faculty (FacultyID nchar(30), [Username] nchar(30), [Password] nchar(30))";

Shweta N Mishra 11-Nov-14 11:25am

you should also check if the table exists, if not then only create.

Otherwise you will get an error.

Elaa_zx 11-Nov-14 21:44pm

table doesn't in that name..
i am creating it in new database

VC.J 12-Nov-14 2:03am

Any exception you have get while executing the code ?

Thava Rajan 12-Nov-14 2:52am

what kind of design it is?!!!
why you need to create a table for each faculty?

pradiprenushe 14-Nov-14 1:02am

Please check for details
http://www.dotnetperls.com/sqlclient

Jörgen Andersson 14-Nov-14 1:44am

I'm with Thava here, if you need to create tables dynamically you have failed at normalization.
Read more about it here: http://en.wikipedia.org/wiki/Database_normalization
Add an extra column for the department instead.

Tomas Takac 14-Nov-14 2:01am

What is your question exactly? You apparently know that your code creates a table based on user's input. So what part is not clear? Do you want to get rid of the dynamic tables and you are asking how? Then you should probably explain why are you creating the tables dynamically in the first place.

Sinisa Hajnal 14-Nov-14 3:25am

Be aware of SQL injection attack potential. Never trust user input.

Also, what is the question here?

2 solutions

Add a Solution

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

jing567 · Answer 1 · 2014-11-14T04:20:00

SQL

CREATE PROCEDURE sproc_CreateTableAtRuntime
           @TableName NVARCHAR(128)
          ,@Column1Name NVARCHAR(32)
          ,@Column1DataType NVARCHAR(32)
          ,@Column1Nullable NVARCHAR(32)

AS

DECLARE @SQLString NVARCHAR(MAX)
SET @SQString = 'CREATE TABLE ' + @TableName + '( '+ @Column1Name + ' ' + @Column1DataType + ' '+ @Column1Nullable +') ON PRIMARY '

EXEC (@SQLString)

Call this sp and Send the above parameters from c# code
In case if you need more columns add in the store procedure as I have given.
If you believe that column generation will be dynamic then then just send the columns and its data types from Code side.... Please let me know if nay quaries... If you are satisfied Please mark it as answer

/\jmot · Answer 2 · 2014-11-15T12:01:00

Try these links..
it'll help you..

http://stackoverflow.com/questions/10033758/create-sql-table-programmatically[^]
http://stackoverflow.com/questions/19589020/c-sharp-create-sql-table-programmatically[^]
http://stackoverflow.com/questions/4541050/creating-new-sql-server-table-with-c-sharp[^]

how to create dynamic tables in sql server using C#

2 solutions

Solution 2

Solution 3

Add your solution here

Preview 0

how to create dynamic tables in sql server using C#

2 solutions

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us