Problem in creating table at runtime in c#.. Plz Help Dear ones... URGENT

Question

I have a three textbox in my form and a button one to table name ( Example .Emp details) two to get field name(Example ID) three to get field value(Example 10) i need a code to pass values in run time and all should be stored in SQL i dont know code but plz Help me.. im getting Error.. protected void Button1_Click(object sender, EventArgs e) { SqlConnection con=new SqlConnection('Data Source=localhost;Initial Catalog=Northwind;User Id=sa;Password=sa'); SqlDataAdapter da = new SqlDataAdapter('SELECT * FROM '+ TextBox1.Text +'',con); SqlCommand CMD = new SqlCommand('Create table '+ TextBox1.Text +'('+ TextBox2.Text +' )values( ''+ TextBox3.Text +'')',con); DataSet ds = new DataSet(); da.Fill(ds,'+ TextBox1.Text +'); DataGrid1.DataSource=ds; DataGrid1.DataMember='+ TextBox1.Text +'; DataGrid1.DataBind(); con.Open(); CMD.ExecuteNonQuery(); con.Close(); } Please dear friend Help me soon If any doubt mail me at senthil123123@gmail.com Thank u senthil kumar.

Gautam Baruah · Answer

Hi, though i could not understand properly still giving you one piece of code. This should work which i already executed and was running fine. protected void btnSubmit_Click(object sender, EventArgs e) { string sql = "CREATE TABLE [dbo].["+textbox1.Text+"](["+textbox2.Text+"] [nvarchar](25) NOT NULL)"; SqlConnection con=new SqlConnection("Data Source=localhost;Initial Catalog=Northwind;User Id=sa;Password=sa"); SqlCommand cmd = new SqlCommand(sql, con); SqlDataReader reader; try { con.Open(); cmd.ExecuteNonQuery(); sql = "insert into "+textbox1.Text+"("+textbox2.Text+") values("+textbox3.Text+")"; cmd = new SqlCommand(sql, con); cmd.ExecuteNonQuery(); sql = "select * from " + textbox1.Text; cmd = new SqlCommand(sql, con); reader = cmd.ExecuteReader(); DataTable dt = new DataTable(); dt.Load(reader); DataGrid1.DataSource = dt; DataGrid1.DataBind(); } catch { throw; } finally { con.Close(); } } Please let me know if this solve your problem.

Gautam Baruah · Answer

My Pleasure.

senthil · Answer

Dear Gautam Baruah... How can i say u.. Thanks for this code.. Its WORKING 100%... THANKS A LOT FOR ALL REPLYS.. KEEP SMILING.... HAPPY CODING SENTHIL KUMAR

Gautam Baruah · Answer

Hi Senthil, did u try the code? I think it wil give u the exact result that u r looking for.

senthil · Answer

THANKS FOR ALL Reply .. plz specify your maid id to reply for your questions dear ones.. Need any reply from me... I dont know you people but your help is a precious gift for me... contact at senthil123123@gmail.com

senthil · Answer

Three textboxes and one button in my form Example Table name(label) - Textbox (for getting value for table at runtime such as Employee details ) column name(label) - textbox (for getting a colum name for table such as ID) Column value(label) - textbox ( for getting a colum value for the colum name such as 10) Button if i click a button at run time the first textbox value should create a table the second text box should create a column for table the third to insert column name for table example in sql we create (This will be creted in sql) CREATE TABLE Employeedetails(ID Int) INSERT INTO TABLE(ID) VALUES(10) I needed this to create the above in run time .... I will very thankful if i finish this concept... Keep smiling Thanks for replys....

senthil · Answer

Three textboxes and one button in my form Example Table name(label) - Textbox (for getting value for table at runtime such as Employee details ) column name(label) - textbox (for getting a colum name for table such as ID) Column value(label) - textbox ( for getting a colum value for the colum name such as 10) Button if i click a button at run time the first textbox value should create a table the second text box should create a column for table the third to insert column name for table example in sql we create (This will be creted in sql) CREATE TABLE Employeedetails(ID Int) INSERT INTO TABLE(ID) VALUES(10) I needed this to create the above in run time .... I will very thankful if i finish this concept... Keep smiling Thanks for replys....

Sam Hobbs · Answer

As Aleksandar indicated, it is not clear whether you need to create tables or create rows in tables. I will assume you need to create rows in tables, but that does not make sense since you have only one field in your form so the new rows will have just one field. First I suggest you open the connection only once for the form, so add the following member to the form class: SqlConnection con; Then in the form's Load event do something such as: try { con = new SqlConnection("Data Source=localhost;Initial Catalog=Northwind;User Id=sa;Password=sa"); con.Open(); } catch (Exception ex) { MessageBox.Show("Connection error: " + ex.Message); Close(); } And in the form's Closed event: con.Close(); Then in the button click you can do something such as: try { String CommandText = String.Format("Insert Into {0}({1}) Values (@FieldData)", textBox1.Text, textBox2.Text); SqlCommand InsertCommand = new SqlCommand(CommandText, con); InsertCommand.Parameters.Add(new SqlParameter("@FieldData", textBox3.Text)); InsertCommand.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show("Insertion error: " + ex.Message); } But note that as I said, that will create a new row with just one field, and I doubt that is what you need. Can you clarify what you need to do?

Aleksandar Ilioski · Answer

i don't really understand your problem.. you create dataAdapter ("select * from someTable") and than create comand for creating that table.. how can you read from not existing table..?? the sql string for creating table would be CREATE TABLE tblName (pole1 tip1 [NOT NUL], pole2 tip2 auto_increment, PRYMARY KEY (pole2), …..) if that helps you.. if not, feel free to ask again.. but please explain your problem better

Problem in creating table at runtime in c#.. Plz Help Dear ones... URGENT

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (9)