Update datagridview ต้องการให้ datagridview แสดงข้อมูลเวลาเพิ่มข้อมูลลงฐานข้อมูล

Code 


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.Data.SqlClient;
using System.Runtime.InteropServices;
using System.Net;
using System.Net.Sockets;
using System.Threading;
using System.IO;

namespace LastProject
{
    public partial class ManageUser : Form
    {
        public ManageUser()
        {
            InitializeComponent();
       
        }

        SqlConnection Conn;
       
        string strConn;

        DataSet ds = new DataSet();
    
          

        private void Form1_Load(object sender, EventArgs e)
        {
            // TODO: This line of code loads data into the 'server1DataSet.Program' table. You can move, or remove it, as needed.
            this.programTableAdapter.Fill(this.server1DataSet.Program);
            strConn = "Data Source=SKZ-43D05CDB745;Initial Catalog=server1;Integrated Security=True; User ID=sa;Password=1234";
            Conn = new SqlConnection();
            if (Conn.State == ConnectionState.Open)
            {
                Conn.Close();

            }
            Conn.ConnectionString = strConn;
            Conn.Open();
     
        }
        private void check()
       {
           int c = ds.Tables["Program"].Rows.Count - 1;
           

            for (int i = 0; i <= c; i++)
           {
               if (ds.Tables["Program"].Rows[i]["NameProgram"].ToString().Equals(txtNameProgram.Text.Trim()))
               {
                   MessageBox.Show("คุณป้อนข้อมูลซ้ำ !!! กรุณาป้อนข้อมูลใหม่", "ผลการตรวจสอบ", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                   txtID.Text = "";
                   txtID.Focus();
                   txtNameProgram.Text = "";
                   txtNameProcess.Text = "";
                   return;
               }

           }

       }
        private void ShowData()     //Refresh Data Gridview and ListDelete Program
        {
           /* 
            StringBuilder sb = new StringBuilder();
            sb.Remove(0, sb.Length);
            sb.Append("select IDProgram,NameProgram,NameProcess");
            sb.Append("from Program");
            sb.Append("Order by IDProgram");
            string sqldata = sb.ToString();
            
            DataTable dt;

            SqlCommand com = new SqlCommand();
            com.CommandText = sqldata;
            com.CommandType = CommandType.Text;
            com.Connection = Conn;
            SqlDataReader dr;
            dr = com.ExecuteReader();
            
            if (dr.HasRows)
            {
                dt = new DataTable();
                dt.Load(dr);
                dgvProgram.DataSource = dt;
           }
            else
           {
               dgvProgram.DataSource = null;
           }
            dr.Close();
            */
            
            string sqldata = " select * from Program ";
            SqlDataAdapter da = new SqlDataAdapter(sqldata, Conn);
            
            da.Fill(ds, "Program");
            dgvProgram.ReadOnly = true;
           // da.Update(ds, "Program"); 
            dgvProgram.DataSource = ds.Tables["Program"];

            string sqldata1 = "select NameProgram from Program";
            SqlDataAdapter da1 = new SqlDataAdapter(sqldata1, Conn);
            da1.Fill(ds, "Data2");
            checkedListBox.DataSource = ds.Tables["Data2"];
            checkedListBox.DisplayMember = "NameProgram";
            checkedListBox.ValueMember = "NameProgram";
            checkedListBox.SelectedIndex = 0;

        }

        private void Add_Click(object sender, EventArgs e)
        {
            if (txtID.Text.Trim() == "" || txtNameProgram.Text.Trim() == "" || txtNameProcess.Text.Trim() == "")
            {
                MessageBox.Show("กรุณากรอกข้อมูลให้ครบ !!!!!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                txtID.Text = "";
                txtID.Focus();
                txtNameProgram.Text = "";
                txtNameProcess.Text = "";
                return;
            }
      
            if (MessageBox.Show("คุณต้องการเพิ่มโปรแกรมใช่หรือไม่?", "คำยืนยัน", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.Yes)
            {
               // check();
                strConn = "Data Source=SKZ-43D05CDB745;Initial Catalog=server1;Integrated Security=True; User ID=sa;Password=1234";
                Conn = new SqlConnection();
                if (Conn.State == ConnectionState.Open)
                {
                    Conn.Close();
                }
                Conn.ConnectionString = strConn;
                Conn.Open();
                
                StringBuilder sb = new StringBuilder();
                SqlTransaction tr = Conn.BeginTransaction();
              

                try
                {
                     
                    sb.Remove(0, sb.Length);
                    sb.Append("INSERT INTO Program (IDProgram,NameProgram,NameProcess)");
                    sb.Append("VALUES(@IDProgram,@NameProgram, @NameProcess)");
                   
                    string sqlAdd;
                    sqlAdd = sb.ToString();
                    SqlCommand com = new SqlCommand();
                    com.CommandText = sqlAdd;
                    com.CommandType = CommandType.Text;
                    com.Connection = Conn;
                    com.Transaction = tr;
                    com.Parameters.Clear();

                    
                    com.Parameters.Add("@IDProgram", SqlDbType.Int).Value = txtID.Text.Trim(); ;
                    com.Parameters.Add("@NameProgram", SqlDbType.NVarChar).Value = txtNameProgram.Text.Trim();
                    com.Parameters.Add("@NameProcess", SqlDbType.NVarChar).Value = txtNameProcess.Text.Trim();
                    com.ExecuteNonQuery();
                    tr.Commit();
                              
                   MessageBox.Show("เพิ่มข้อมูลโปรแกรมเรียบร้อยแล้ว!!!", "ผลการทำงาน", MessageBoxButtons.OK, MessageBoxIcon.Information);

                   

                   txtID.Text = "";
                   txtID.Focus();
                   txtNameProgram.Text = "";
                   txtNameProcess.Text = "";
                   ShowData(); 
                 }
                   
                catch (Exception ex)
                {

                    MessageBox.Show("ไม่สามารถเพิ่มข้อมูลโปรแกรมได้ เนื่องจาก " + ex.Message, "ผลการตรวจสอบ", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                    txtID.Text = "";
                    txtID.Focus();
                    txtNameProgram.Text = "";
                    txtNameProcess.Text = "";
                }
 
            }
           
        }