To Create a table structure on a button click

Question

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

Manish Dwivedi · Answer

Hi, Take the reference of this article. http://www.csharphelp.com/archives/archive66.html

Anurag Agarwal · Answer

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

Vijaya Kadiyala · Answer

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

Anurag Agarwal · Answer

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 .... pls help ....

Manish Dwivedi · Answer

Hi, You can pass the table name like that. ADOCommand CreateTable = new ADOCommand("Create Table " + TextBox1.Text + "(vno integer,name char(20))", s);

Anurag Agarwal · Answer

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 ....

To Create a table structure on a button click

To Create a table structure on a button click

Answers (6)