How Do I Create A Table In Button Click In C#

Question

1.00/5 (1 vote)

See more:

C#

C#4.0

MS-Access

Hi Friends

How do i create a table in C#.

Posted 25-Dec-14 15:34pm

satya.Sw

Add a Solution

Comments

DamithSL 25-Dec-14 21:38pm

where you want to create table? what have you tried so far?

PIEBALDconsult 25-Dec-14 22:34pm

That doesn't sound like a good idea; what are you trying to do?

satya.Sw 26-Dec-14 0:01am

Hi Experts.
Thank u all for replying.

I am very new to dotnet.

I have a window. and I wanted to add automatic table while clicking on button. and
For each table i need a specific name.

Example : I have Passport No. For Every Passport No. I want to create seperate table so i have choosen this way. and its working.

If there is any other solution. please Update me i am highly interested to take advices.

private void button1_Click(object sender, EventArgs e)
{

OleDbConnection myConnection = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\Administrator\Documents\Database1.accdb");

myConnection.Open();

OleDbCommand myCommand = new OleDbCommand();
myCommand.Connection = myConnection;
string qry = "CREATE TABLE [Database3]([Ename] text, [ESurname] text)";

myCommand.CommandText = qry.Replace("Database3", textBox1.Text);
myCommand.ExecuteNonQuery();
MessageBox.Show("Table Created Successfully");
myConnection.Close();
}

PIEBALDconsult 26-Dec-14 2:14am

"For Every Passport No. I want to create seperate table"

I _strongly_ advise against that; please find a better solution.

4 solutions

Solution 3

Thank You Boss. Its Working Good.

private void button1_Click(object sender, EventArgs e)
{

OleDbConnection myConnection = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\Administrator\Documents\Database1.accdb");

myConnection.Open();

OleDbCommand myCommand = new OleDbCommand();
myCommand.Connection = myConnection;
string qry = "CREATE TABLE [Database3]([Ename] text, [ESurname] text)";

myCommand.CommandText = qry.Replace("Database3", textBox1.Text);
myCommand.ExecuteNonQuery();
MessageBox.Show("Table Created Successfully");
myConnection.Close();
}

Posted 25-Dec-14 17:15pm

satya.Sw

Comments

BillWoodruff 25-Dec-14 23:57pm

Please post a reply to a solution as a comment on the reply, not as a "solution."

If a solution helped you, or solved your problem, be sure and vote for the solution, or accept it as your answer, to let the person who assisted you know you appreciate their time and effort.

Solution 4

Hi Experts.
Thank u all for replying.

I am very new to dotnet.

I have a window. and I wanted to add automatic table while clicking on button. and
For each table i need a specific name.

Example : I have Passport No. For Every Passport No. I want to create seperate table so i have choosen this way. and its working.

If there is any other solution. please Update me i am highly interested to take advices.

Posted 25-Dec-14 17:59pm

satya.Sw

Comments

DamithSL 26-Dec-14 0:08am

don't post your questions as solutions. create new question

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)

Yesii · Accepted Answer · 2014-12-25T16:00:00

Refer to the following

http://msdn.microsoft.com/en-us/library/ms753342(v=vs.110).aspx

A FlowDocument is created to host the Table, and a new Table is created and added to the contents of the FlowDocument.

// Create the parent FlowDocument...
flowDoc = new FlowDocument();

// Create the Table...
table1 = new Table();
// ...and add it to the FlowDocument Blocks collection.
flowDoc.Blocks.Add(table1);

// Set some global formatting properties for the table.
table1.CellSpacing = 10;
table1.Background = Brushes.White;

DamithSL · Accepted Answer · 2014-12-25T15:47:00

if you need to create table in access database you can use OleDbConnection and OleDbCommand classes to do it, for example:

C#

OleDbConnection conn = new OleDbConnection(connectionString);
OleDbCommand cmmd = new OleDbCommand("CREATE TABLE  TableName ( [ID] Counter Primary Key, [FirstName] Text, [LastName] Text)", conn);
con.Open();
cmmd.ExecuteNonQuery();

refer https://www.connectionstrings.com/access/[^] for how you can give connection string for access database.

How Do I Create A Table In Button Click In C#

4 solutions

Solution 2

Solution 1

Solution 3

Solution 4

Add your solution here

Preview 0