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

981

Answers (1)

Next Recommended Forum

To Find missing dates in data-gridview.

Updation in Sql Server.

Leaderboard

View all

Harshit Pandey

Priyanshu Agnihotri

Shivam Payasi

View all

Yesterday's leader

Harshit Pandey

java, python, BigData

Kanpur (Holy See (Vatican City))

9.1k

121.2k

Member of the month

Rinki

Chennai (India)

5.5k

14.8k

Speaker of the month

Shivam Payasi

C#, .NET

Chitrakoot (India)

21.3k

19.3k

Upcoming events

View all

Bhubaneswar Chapter
Building Websites with Microsoft Power Pages: Exploring WebPage, WebTemplate, and Page Templates - Microsoft Business Application Ep. 25

Suggested for you

View all

Gaurav Kumar Singh

Rathrola Prem Kumar

Nilesh Jadav

James Tomar

Rinki

Forum Statistics

Please welcome our newest member Grace Lee.
2,380,749 users have contributed to 122,527 threads and 388,993
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 'How can I optimize my Twilio SMS usage to reduce costs?'.