TO MAKE A DATABASE (C#.NET)

One of my readers mailed me to solve his problem
Actually he is working for a software firm in Chennai,India.
There in their project,there was a module to create a database connection,
create a database,and create a table....These are much complicated in a sense.
Tell you..the actual value of each database should not be static.
Done ..he send me a mail to solve this.
Ok where ever you are please check my blog Mr.Anand kumar
It will help you i am sure....


------------------------------------------------------------------------------------

First of all we must add namespaces on our program
A complete general notes on basics of .net will present you later ok?


using system.data.sqlclient;

Then

add this

string source = (@"Data Source=.;Initial Catalog=*yourdatabasename*;Integrated Security=True");
string insert = ("insert into tbl_soft values('" + textBox1.Text + "','" + textBox2.Text + "')");
SqlConnection cnn = new SqlConnection(source);
cnn.Open();
SqlCommand cmd = new SqlCommand(insert,cnn);
cmd.ExecuteNonQuery();
MessageBox.Show("files added successfully");

here i've used certain controls to give the values in database rather sql server.
Those are textboxes.Once it generates the values ,it will add itself as Main and Sub Tables.