Re: [問題] DataSet、DataTableAdapter 回存資料庫

[mosluce ()]

說明：
首先 DataGridView 先自己建好 Colunmn

Colunmn中的參數         設定值
HeaderText              隨意
DataProperty            必須和 Table 中的 FieldName 一樣
(Name)                  欄位名稱 (ex. dataview.Colunmn["someName"])

以上建立OK後
就可以套了~

自解答：
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SQLite;
using System.Data;
using System.Windows.Forms;

namespace AccountSystem.Data
{
    class DataGridViewManager
    {
        DataSet _ds;
        DataTable _dt;

        SQLiteConnection _conn;
        SQLiteCommand _cmd;
        SQLiteCommandBuilder _cmdBuilder;
        SQLiteDataAdapter _adp;
        DataGridView _view;

        public DataTable dataTable { get { return _dt; } }

        public DataGridViewManager()
        {

        }

        public DataGridViewManager(SQLiteConnection c, string CommandText, DataGridView v)
        {
            FillData(c, CommandText, v);
        }

        public static DataGridViewManager getInstance()
        {
            return new DataGridViewManager();
        }

        public static DataGridViewManager getInstance(SQLiteConnection c, string CommandText, DataGridView v)
        {
            return new DataGridViewManager(c, CommandText, v);
        }

        public void UpdateData()
        {
            try
            {
                _adp.Update(_dt);
                _dt.Clear();
                _adp.Fill(_dt);
            }
            catch (SQLiteException ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

        public void RejectData()
        {
            _dt.RejectChanges();
        }

        public void FillData(SQLiteConnection c, string CommandText, DataGridView v)
        {
            _cmd = c.CreateCommand();
            _cmd.CommandText = CommandText;
            _adp = new SQLiteDataAdapter(_cmd);
            _cmdBuilder = new SQLiteCommandBuilder(_adp);
            _ds = new DataSet();
            _dt = _ds.Tables.Add();
            _view = v;
            _conn = c;

            _adp.Fill(_dt);
            _view.DataSource = _dt;
        }
    }
}

--
※ 發信站: 批踢踢實業坊(ptt.cc) 
◆ From: 219.85.58.90