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

978

Answers (1)

Next Recommended Forum

To Find missing dates in data-gridview.

Updation in Sql Server.