public void CreateTableAdapter() { _workerTable.Clear(); _adapter = new SqlDataAdapter(@"SELECT* FROM workers", SingleConnection.NewConnection()); _adapter.Fill(_workerTable); _dataGridView.DataSource = _workerTable; }
public void CreateTableAdapter() { try { string tmp = @"SELECT C.id as [ID], C.date as [Дата платежа], C.cost as [Сумма], W.name as [Водитель], C.note as [Примечание] FROM cleaning_works AS C, workers AS W WHERE C.fk=W.id;"; _cleanTable.Clear(); _adapter = new SqlDataAdapter(tmp, SingleConnection.NewConnection()); _adapter.Fill(_cleanTable); _dataGridView.DataSource = _cleanTable; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public CleaningWorks(DataGridView dataGridView, Label clean, Label pay, Label itog, MaskedTextBox maskedTextBox, DateTimePicker dateTimePicker, TextBox textBox, ComboBox comboBox) { SingleConnection.NewConnection(); _connect = new WG_db(); _connect.cleaning_works.Load(); _cleanTable = new DataTable(); _dataGridView = dataGridView; _maskedTextBox = maskedTextBox; _dateTimePicker = dateTimePicker; _textBox = textBox; _comboBox = comboBox; _cleansumm = clean; _paysumm = pay; _itogsumm = itog; Summ(); }
public void InsertCommand() { try { SqlCommand _insert = new SqlCommand(@"INSERT INTO workers (name, phone ) VALUES (@name, @phone);", SingleConnection.NewConnection()); _insert.Parameters.Add(new SqlParameter("@name", SqlDbType.NVarChar, 100)); _insert.Parameters.Add(new SqlParameter("@phone", SqlDbType.VarChar, 16)); _insert.Parameters["@name"].SourceVersion = DataRowVersion.Current; _insert.Parameters["@phone"].SourceVersion = DataRowVersion.Current; _insert.Parameters["@name"].SourceColumn = "name"; _insert.Parameters["@phone"].SourceColumn = "phone"; _adapter.InsertCommand = _insert; SqlCommandBuilder _builder = new SqlCommandBuilder(_adapter); _adapter.Update(_workerTable); CreateTableAdapter(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public Workers(DataGridView dataGridView) { SingleConnection.NewConnection(); _workerTable = new DataTable(); _dataGridView = dataGridView; }