inserting data into database and display in gridview using C#

Question

2.59/5 (3 votes)

See more:

C#

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
 
namespace EnableorDisableApplication3
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
 
            //FillData();
        }
 
 
        SqlConnection con = new SqlConnection("Server=KK-PC;Database=SampleDB;User id=sa;password=sa2008;");
 
        private void Form1_Load(object sender, EventArgs e)
        {
            try
            {
                con.Open();
            }
            catch (SystemException ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
 
        private void button1_Click(object sender, EventArgs e)
 
        {
 
            SqlConnection con = new SqlConnection("Server=KK-PC;Initial Catalog=SampleDB;User id=sa;password=sa2008;");
            using (SqlCommand cmd = new SqlCommand("Insert into Emp_Details (Emp_ID,Name,Education) values (" + textBox2.Text + ",'" + textBox3.Text + "','" + textBox1.Text + "')", con))
            {
                cmd.ExecuteNonQuery();
            }
 
 
        }
 
 
      void FillData()
        {
            // 1
            // Open connection
            using (SqlConnection c = new SqlConnection("Server=KK-PC;Initial Catalog = SampleDB;User id=sa;Password=sa2008;"))
            {
                c.Open();
 
                // Create new DataAdapter
                using (SqlDataAdapter a = new SqlDataAdapter(
                    "SELECT * FROM Emp_Details", c))
                {
                    // 3
                    // Use DataAdapter to fill DataTable
                    DataTable t = new DataTable();
                    a.Fill(t);
                    // 4
                    // Render data onto the screen
                    dataGridView1.DataSource = t;
                }
            }
        }
 
        private void label2_Click(object sender, EventArgs e)
        {
 
        }
 
        private void label1_Click(object sender, EventArgs e)
        {
 
        }
        private void textBox2_TextChanged(object sender, EventArgs e)
        {
 
        }
    }
}

Data is displaying in grid view but when i enter the particulars it's not inserting in to DB & grid view.

Can any one help me tosolve this problem.

Posted 11-Feb-14 23:18pm

Karthik Achari

Updated 11-Feb-14 23:29pm

Gitanjali Singh

v2

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

V. · Answer 1 · 2014-02-12T00:03:00

There is a lot wrong with the code I'm afraid.

1. Get the SQL stuff out of the GUI code. Read this article[^] eg.
2) You're code is vulnerable for SQL injection. See here[^]
3) If you want to update your grid, you need to call FillData again after an insert. The grid's DataSource object will not update itself.
4) Remove the Form1, Button1, etc... instances and replace them with some useful names. (also change the corresponding event handler names.)

hope this helps.

Bojjaiah · Answer 2 · 2014-02-12T00:21:00

try this

C#

private void button1_Click(object sender, EventArgs e)
        {
            SqlConnection con = new SqlConnection("User ID=sa;password=pass@word1;Initial Catalog=Test;Data Source=.;");
            con.Open();
            using (SqlCommand cmd = new SqlCommand("Insert into Emp_Details (Emp_ID,Name,Education) values (" + textBox1.Text + ",'" + textBox2.Text + "','" + textBox3.Text + "')", con))
            {
                cmd.ExecuteNonQuery();
            }
            con.Close();

            FillData();
        }

        void FillData()
        {
            using (SqlConnection c = new SqlConnection("User ID=sa;password=pass@word1;Initial Catalog=Test;Data Source=.;"))
            {
                c.Open();
                using (SqlDataAdapter a = new SqlDataAdapter("SELECT * FROM Emp_Details", c))
                {
                    DataTable t = new DataTable();
                    a.Fill(t);
                    dataGridView1.DataSource = t;
                }
            }
        }

Karthik Achari · Answer 3 · 2014-02-12T19:58:00

C#

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace MyDBApp
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
           
        }
        SqlConnection con = new SqlConnection("Server=127.0.0.1;Database=SampleDB;User id=sa;password=sa2008;");

        
        private void Form1_Load(object sender, EventArgs e)
        {
            try
            {
                con.Open();
                FillData();
            }
            catch (SystemException ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

        private void button1_Click(object sender, EventArgs e)
        {
            
            using (SqlCommand cmd = new SqlCommand("Insert into Emp_Details (Emp_ID,Name,Education) values (" + textBox2.Text + ",'" + textBox3.Text + "','" + textBox1.Text + "')", con))
            {
                cmd.ExecuteNonQuery();
            }
            FillData();
        }

        private void textBox2_TextChanged(object sender, EventArgs e)
        {

        }
    
    
     void FillData()
        {
            
                using (SqlDataAdapter a = new SqlDataAdapter("SELECT * FROM Emp_Details", con))
                {
                    DataTable t = new DataTable();
                    a.Fill(t);
                    dataGridView1.DataSource = t;
                }
            
        }
    }
}

inserting data into database and display in gridview using C#

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0