Insert data in Database using windows Application c#

Anonymous User 2269 13 Dec 2015

I want to Insert data in Database using windows Application c# .please help me.

1 Answers

Anonymous User 13 Dec 2015

using System;
using System.Collections.Generic;
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.IO;
using System.Drawing.Imaging;
using System.Data.SqlClient;
using System.Data;
namespace WindowsForums
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }       
        private void save()
        {
            SqlConnection cn = new SqlConnection("Data Source=MSCLIENT-006;Initial Catalog=forum;Persist Security Info=True;User ID=sa;Password=mindstick");
            SqlCommand cmd = new SqlCommand();
            string sqlrt = "insert into [Employee] ([Emp_Name],[Emp_Sal],[Location]) values('" + txtempName.Text + "','" + txtempSal.Text + "','" + txtempAddress.Text + "')";
            cn.Open();
            cmd.Connection = cn;
            cmd.CommandText = sqlrt;
            cmd.ExecuteNonQuery();
            cn.Close();
        }
        private void clear()
        {
            txtempName.Text = "";
            txtempSal.Text = "";
            txtempAddress.Text = "";
        }
        private void btnSave_Click(object sender, System.EventArgs e)
        {
            save();
            clear();
        }
        private void btncleare_Click(object sender, System.EventArgs e)
        {
            clear();
        }
        private void btnclose_Click(object sender, System.EventArgs e)
        {
            this.Close();
        }
    }

}

Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.

Open .md

forum

Insert data in Database using windows Application c#

Can you answer this question?

1 Answers