Insert Values into Tables using ADO.NET

 

code for Form1.cs:

using System;

using System.Windows.Forms;
using System.Data.SqlClient;

namespace Insert_Data
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void textBox1_TextChanged(object sender, EventArgs e)
        {

        }

        private void label1_Click(object sender, EventArgs e)
        {

        }

        private void Form1_Load(object sender, EventArgs e)
        {

        }

        private void button1_Click(object sender, EventArgs e)
        {
            SqlConnection conn=new SqlConnection("Data Source=ZAKIHP-PC\\ZAKISQL;Initial Catalog=LICT_DotnetDB;Integrated Security=True");
            conn.Open();
            SqlCommand sc=new SqlCommand("insert into Emp values('"+textBox1.Text+ "','" + textBox2.Text + "','" + textBox3.Text + "','"+textBox4.Text+"','" + textBox5.Text + "');",conn);
            int o = sc.ExecuteNonQuery();
            MessageBox.Show(o + ": Record has been inserted");
            conn.Close();
        }

        public static void main(string[] args)
        {
            Application.Run(new Form1());
        }

        private void button2_Click(object sender, EventArgs e)
        {
            Application.Exit();
        }
    }
}

There is also Form1.cs design

It would be a great help, if you support by sharing :)
Author: zakilive

Leave a Reply

Your email address will not be published.