how to create dynamic table using .net code [Resolved]

Posted by Saisindura under Sql Server on 2/24/2012 | Points: 10 | Views : 3124 | Status : [Member] | Replies : 4
hi all

please tell me how to create dynamic tables for particular user in database using c#.net and asp.net.
i.e like for first user
first.registration
first.data.
for second user
second.registration
second.data
.....
....
like that i need maintain all tables in one database.

Thanks&Regards
srisai



Responses

Posted by: Naraayanan on: 2/24/2012 [Member] Starter | Points: 50

Up
0
Down

Resolved
Hi,
Check this link
http://www.c-sharpcorner.com/UploadFile/mahesh/CreatingDBProgrammaticallyMCB11282005064852AM/CreatingDBProgrammaticallyMCB.aspx

Regards,
Lakshmi Naraayanan.S
http://dotnettechrocks.blogspot.in/
http://abaprocker.blogspot.com/

Saisindura, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Ppathi on: 2/24/2012 [Member] Starter | Points: 25

Up
0
Down
Hi,

Please go through this link

http://stackoverflow.com/questions/7508289/creating-a-dynamic-table-for-net-code-behind-c-sharp

Thanks & Regards,
Pasupathi G
No Pain No Gain

Saisindura, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Pradeepkumar417 on: 2/24/2012 [Member] Starter | Points: 25

Up
0
Down
Hi,

why you are trying to save the different user's data in different tables. I think it is not a good appraoch. I think it is better to create 2 tables and maintaining relation(primary key and foriegn key relations) between them.

If you want like that just go through the above links.

Thanks & Regards,
Software Engineer,
Pradeep Kumar

Saisindura, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Saisindura on: 2/24/2012 [Member] Starter | Points: 25

Up
0
Down
why because i need maintain more records for particular user.
for performance and security purpose i need create different tables for different users.
please help me

Thanks&Regards
srisai

Saisindura, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response