forum

home / developersection / forums / insert data in database using windows application c#

Ask Question

Insert data in Database using windows Application c#

Anonymous User 1999 13-Dec-2015
I want to Insert data in Database using windows Application c# .please help me.
c# c#  database  windows controls 
Updated on 13-Dec-2015
Anonymous User

Other

I am a content writter !

Follow
Can you answer this question?
Answer

1 Answers

Anonymous User

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();
        }
    }

}

Insert data in Database using windows Application c#

 

advertising
advertising

Liked By

We use cookies to ensure you have the best browsing experience on our website. By using our site, you acknowledge that you have read and understood our Cookie Policy & Privacy Policy