using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.SqlClient; namespace WindowsFormsApplication4 { public partial class Form1 : Form { SqlConnection con = new SqlConnection(@"server = HOME-A81E14F1B4/SQLEXPRESS;data source = .; initial catalog = test; user id=sa;pwd =pintu ;integrated security = SSPI"); SqlCommand com; string str; public Form1() { InitializeComponent(); } private void btn_create_Click(object sender, EventArgs e) { str = "CREATE TABLE employee (name VARCHAR(50),address VARCHAR(50))"; com = new SqlCommand(str, con); try { con.Open(); com.ExecuteNonQuery(); } catch { } con.Close(); MessageBox.Show("Table Created"); } private void btn_insert_Click(object sender, EventArgs e) { try { con.Open(); com = new SqlCommand("Insert into employee values('Raj','Pune')", con); com.ExecuteNonQuery(); con.Close(); } catch { } { MessageBox.Show("Record inserted"); } } } }

Answer

how to create dynamically create table add to db records

Srinivasarao Battula

11y

986

1 WCF

Answers (1)

Forum Statistics

Please welcome our newest member Jankoi .
2,381,645 users have contributed to 122,515 threads and 389,026
In the past 24 hours, we have 0 new threads, 0 new posts, and 0 new users.
In last week, the most popular thread is 'What is trending right now?'.

Upcoming Events

View all

How Gen AI is Reshaping Content, Code, and Commerce

Our Training Programs

View all

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training