To Create a table structure on a button click

Anurag Agarwal

17y6.2k.NET

To Create a table structure on a button click

Hi,

can any one tell me to create a new table in ms access database on the event of a button click, i tried the method of create table but it didn't work.

i need to create a table structure name "subject" with fields

subject code as text [primary key]

subject name as text

in database name quiz ..........

Thanks

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Blocked Account17y ago
Accepted answer
Hi,
Take the reference of this article.
http://www.csharphelp.com/archives/archive66.html
0
Anurag Agarwal17y ago
Ya Vj, first look the code

sql_create = new StringWriter();
sql_create.WriteLine("create table + TSubcode.Text + (srno int not null primary key, quest varchar(255) null,A varchar(255) null,B varchar(255) null,C varchar(255) null,D varchar(255) null)");
sql_create.Flush();
cmd.CommandType = CommandType.Text;
cmd.CommandTimeout = 30;
cmd.CommandText = sql_create.ToString();
cmd.ExecuteNonQuery();

now the problem is with the "TSubcode.Text", if i gve the specific name then code works fine but when i accepts the name frm user
it gives error as

Object reference not set to an instance of an object. at _Default.BCreate_Click(Object sender, EventArgs e)

how to accept table name from user so to create a table in database with tht name.

The above link didn't proved to be of much use Thanx ...........pls help
0
Vijaya Kadiyala17y ago
Hi

Are you getting any specific error while creating this?? time being Check out the below link..

http://www.davidhayden.com/blog/dave/archive/2006/01/27/2775.aspx

Thanks -- Vijaya Kadiyala
0
Anurag Agarwal17y ago
hi Manish, srry i was little buzy with module thus i was not able to over it, but actually what u have told i have tried bt it didn't worked ......look wt i am doing //*********************************************** sql_create = new StringWriter(); //sql_create.WriteLine("create table webtech (srno int not null primary key, quest varchar(255) null,A varchar(255) null,B varchar(255) null,C varchar(255) null,D varchar(255) null)"); sql_create.WriteLine("create table " + TSubcode.Text + " (srno int not null primary key, quest varchar(255) null,A varchar(255) null,B varchar(255) null,C varchar(255) null,D varchar(255) null)"); sql_create.Flush(); cmd.CommandType = CommandType.Text; cmd.CommandTimeout = 30; cmd.CommandText = sql_create.ToString(); cmd.ExecuteNonQuery(); //*********************************************** i am working on ms-access, and require to use the table name inputted by user thru an interface .... < the above code is working fine if i gave a tablename there only > pls help ....
0
Blocked Account17y ago
Hi,
You can pass the table name like that.

ADOCommand CreateTable = new ADOCommand("Create Table " + TextBox1.Text + "(vno integer,name char(20))", s);
0
Anurag Agarwal17y ago
Thanx Manish, bt i have already done tht, one more problem i am facing, the link which u have send me have got the table name as a1, which is being created at run time, i have tried several means to take the name of table as input frm user bt failed. Can u suggest me the way how to pass the name of table thru variable name ( say TextBox1.Text ) is being used for taking name of table as input ....
0