public void fillGridFromSqlSelect(string QuerySelect, ref eac_sqlConnector sqlConnector) { sqlConn = sqlConnector; gridview.DataSource = null; gridview.Rows.Clear(); DataTable result = sqlConn.Select(QuerySelect); gridview.DataSource = result; tableName = result.TableName; }
private bool enable_autoInsert; //SQL for Autoinsert public eac_dataGridView(ref DataGridView gridviews, ref eac_sqlConnector sqlConnector) { sqlConn = sqlConnector; gridview = gridviews; // Usig pointer for edit in form //For event CellClick gridview.CellClick += new System.Windows. Forms.DataGridViewCellEventHandler(onClick); gridview.CellEndEdit += new System.Windows.Forms. DataGridViewCellEventHandler(CellEndEditUpdateGrid); gridview.CellValueChanged += //It is for Paste from clipboard new System.Windows.Forms.DataGridViewCellEventHandler(CellEndEditUpdateGrid); gridview.KeyDown += new System.Windows.Forms. KeyEventHandler(copyPaste_KeyDown); gridview.UserAddedRow += new System.Windows.Forms.DataGridViewRowEventHandler(NewRowAddedByUser); gridview.RowLeave += new System.Windows.Forms.DataGridViewCellEventHandler(RowLeaved); }