forum

Home / DeveloperSection / Forums / Insert data in Database using windows Application c#

Ask Question

Insert data in Database using windows Application c#

Anonymous User167513-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

Anonymous User

Follow
I am a content writter !

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

}

answer 415871312102949

 

Liked By