How to create a table on Click event

[sacr83]

Hi All, I have some prob in c#.So i want to CREATE a TABLE on Button's "click" event.That's mean when I click on "ok" botton "a new table have to create on my existing DATABASE ".So how i do it in C#..? ReGardZ "ChiNthaKa"

CheeN

[Ashfield]

The same as you do any other time, issue a CREATE TABLE command - for example CREATE TABLE Fred(Column1 int NOT NULL, Column2 varchar(50) NULL...etc)

Bob Ashfield Consultants Ltd

[Blue_Boy]

Create SQL Table using C# code.[^]

---

I Love T-SQL

[Ashfield]

yep, thats another way :)

Bob Ashfield Consultants Ltd

[Blue_Boy]

yep :)

---

I Love T-SQL

[Rohan Priya]

Hi Chinthaka , You can write the following code in the button onclick event . Before that you should import System.Data.SqlClient namespace . SqlConnection conn= new SqlConnection("ConnectionString"); conn.Open(); MessageBox.Show("Connection est.."); SqlCommand comCreate = new SqlCommand("CREATE TABLE EMP_TABLE_CREATE(EmpID INT , EmpName VARCHAR(20))",conn); int intCreate = comCreate.ExecuteNonQuery(); MessageBox.Show("Table Created.." + intCreate); SqlCommand conInsert = new SqlCommand("INSERT INTO EMP_TABLE_CREATE VALUES(11,'MyName')",conn ) ; int intInsert = conInsert.ExecuteNonQuery(); MessageBox.Show("Row Inserted.." + intInsert); MessageBox.Show("Displaying Row : "); SqlCommand conSelect = new SqlCommand("SELECT * FROM EMP_TABLE_CREATE",conn) ; SqlDataReader dr= conSelect.ExecuteReader(); dr.Read(); while(dr.HasRows) { MessageBox.Show(dr.GetInt32(0).ToString() +":"+dr.GetString(1)) ; dr.NextResult(); } conn.Close(); Hope this is what you wanted . Let me know if you have any further queries . Thanks

Priya Rohan