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

10y

1.5k

Answers (1)

Next Recommended Forum

To Find missing dates in data-gridview.

file exists check

Forum Statistics

Please welcome our newest member Ck. Nitin.
3,083,022 users have contributed to 147,418 threads and 483,473
In the past 24 hours, we have 11 new threads, 26 new posts, and 100 new users.
In last week, the most popular thread is 'System.Data.SqlClient'.

Upcoming Events

View all

Overview of Web API in Power Pages - Microsoft Business Application: Ep.29
Deep Dive into Flutter, NoSQL, and Power Fx
Excel Automation with Power Automate : Automate Your Business Processes - Ep.3