public static System.Data.DataTable ToDataTable <T>(this IEnumerable <T> collection) { System.Data.DataTable dt = new System.Data.DataTable(); Type t = typeof(T); System.Reflection.PropertyInfo[] pia = t.GetProperties(); //Create the columns in the DataTable foreach (System.Reflection.PropertyInfo pi in pia) { if ((pi.PropertyType.IsGenericType)) { Type typeOfColumn = pi.PropertyType.GetGenericArguments()[0]; dt.Columns.Add(pi.Name, typeOfColumn); } else { dt.Columns.Add(pi.Name, pi.PropertyType); } } //Populate the table foreach (T item in collection) { System.Data.DataRow dr = dt.NewRow(); dr.BeginEdit(); foreach (System.Reflection.PropertyInfo pi in pia) { dr[pi.Name] = pi.GetValue(item, null); } dr.EndEdit(); dt.Rows.Add(dr); } return(dt); }
private void cboSelectedIndex(object sender, System.EventArgs e) { System.Data.DataRow dr = _contacto.ListaClientes.Rows.Find(grdCliente[grdCliente.CurrentRowIndex, 0]); if (dr != null) { dr.BeginEdit(); dr["TipoContacto"] = ((ComboBox)sender).SelectedValue; dr["TipoContactoDescripcion"] = ((ComboBox)sender).Text; dr.EndEdit(); } }
private void cboSelectedIndex(object sender, System.EventArgs e) { System.Data.DataRow dr = _asignacion.ListaCobradores.Rows.Find(grdListaCobradores[grdListaCobradores.CurrentRowIndex, 0]); if ((dr != null) && (Convert.ToInt32(dr["EmpleadoResguardo"]) != Convert.ToInt32(((ComboBox)sender).SelectedValue))) { dr.BeginEdit(); dr["EmpleadoResguardo"] = ((ComboBox)sender).SelectedValue; dr["EmpleadoResguardoNombre"] = ((ComboBox)sender).Text; dr.EndEdit(); } }
/// <summary> /// the operation target is to update constantly the Using: box // its done by an infinite thread that requires the Ip from the server /// </summary> public void UpdateUsingTB() { while (true) { bool ok = true; System.Threading.Thread.Sleep(100000); this.Form_1.button1.Click += new EventHandler(this.slep); this.Wriite(IPC + ":Get Total Using"); string info = this.Reead(); if (info == "New client arrives") { this.NewClient(); ok = false; } if (ok) { string EqualltyCheck = info.Substring(0, this.IPC.Length); if (EqualltyCheck.Equals(this.IPC)) { this.Form_1.Invoke(new MethodInvoker(delegate() { this.Form_1.TUsingBox.Text = info.Substring(this.IPC.Length + 1); })); } if (!(EqualltyCheck.Equals(this.IPC))) { int Ipin = info.IndexOf(':') + 1; string Ipn = info.Substring(0, Ipin); string Datta = info.Substring(Ipin); int Parami = Datta.IndexOf(':'); string Parmat = Datta.Substring(0, Parami); this.Form_1.Invoke(new MethodInvoker(delegate() { this.IPC = Convert.ToString(this.Form_1.Clients.SelectedItem); System.Data.DataRow copyingvaluesRow = this.computersBasicDDataSet.Basic_Table.Rows.Find(Ipn); copyingvaluesRow.BeginEdit(); this.Form_1.TUsingBox.Text = Convert.ToString(copyingvaluesRow[Parmat]); copyingvaluesRow[Parmat] = Datta; })); } } this.Form_1.button1.Click += new EventHandler(this.slep); } }
public virtual void ImportXls(System.Data.DataTable dt) { int rowcnt = 1; string keyfield = dt.Columns[0].Caption; Object[,] data = readCell(1, ++rowcnt, dt.Columns.Count); string tmp = ""; while (data[1, 1] != null) { tmp += data[1, 1].ToString() + "{}"; System.Data.DataRow[] dr = dt.Select(keyfield + "='" + data[1, 1].ToString() + "'"); if (dr != null && dr.Length > 0) { dr[0].BeginEdit(); for (int i = 0; i < data.GetUpperBound(1); i++) { if (data[1, i + 1] != null) { dr[0][i] = data[1, i + 1]; } } dr[0].EndEdit(); } else { System.Data.DataRow r = dt.NewRow(); r.BeginEdit(); for (int i = 0; i < data.GetUpperBound(1); i++) { if (data[1, i + 1] != null) { r[i] = data[1, i + 1]; } } r.EndEdit(); dt.Rows.Add(r); } data = readCell(1, ++rowcnt, dt.Columns.Count); } }
private void btnSave_Click(object sender, RoutedEventArgs e) { if (action == ActionState.New) { try { System.Data.DataRow newRow = phoneNumbersDataSet.PhoneNumbers.NewRow(); newRow.BeginEdit(); newRow["Phonenum"] = txtPhoneNumber.Text.Trim(); newRow["Subscriber"] = txtSubscriber.Text.Trim(); newRow["Contract_Value"] = Int32.Parse(txtContractValue.Text.Trim()); newRow["Contract_Date"] = DateTime.Parse(txtContractDate.Text.Trim()); newRow.EndEdit(); phoneNumbersDataSet.PhoneNumbers.Rows.Add(newRow); tblPhoneNumbersAdapter.Update(phoneNumbersDataSet.PhoneNumbers); phoneNumbersDataSet.AcceptChanges(); } catch (System.Data.DataException ex) { phoneNumbersDataSet.RejectChanges(); MessageBox.Show(ex.Message); } btnNew.IsEnabled = true; btnEdit.IsEnabled = true; btnSave.IsEnabled = false; btnCancel.IsEnabled = false; lstPhones.IsEnabled = true; btnPrevious.IsEnabled = true; btnNext.IsEnabled = true; txtPhoneNumber.IsEnabled = false; txtSubscriber.IsEnabled = false; txtContractValue.IsEnabled = false; txtContractDate.IsEnabled = false; } else if (action == ActionState.Edit) { try { System.Data.DataRow editRow = phoneNumbersDataSet.PhoneNumbers.Rows[lstPhones.SelectedIndex]; editRow.BeginEdit(); editRow["Phonenum"] = txtPhoneNumber.Text.Trim(); editRow["Subscriber"] = txtSubscriber.Text.Trim(); editRow["Contract_Value"] = Int32.Parse(txtContractValue.Text.Trim()); editRow["Contract_Date"] = DateTime.Parse(txtContractDate.Text.Trim()); editRow.EndEdit(); tblPhoneNumbersAdapter.Update(phoneNumbersDataSet.PhoneNumbers); phoneNumbersDataSet.AcceptChanges(); } catch (System.Data.DataException ex) { phoneNumbersDataSet.RejectChanges(); MessageBox.Show(ex.Message); } btnNew.IsEnabled = true; btnEdit.IsEnabled = true; btnDelete.IsEnabled = true; btnSave.IsEnabled = false; btnCancel.IsEnabled = false; lstPhones.IsEnabled = true; btnPrevious.IsEnabled = true; btnNext.IsEnabled = true; txtPhoneNumber.IsEnabled = false; txtSubscriber.IsEnabled = false; txtContractValue.IsEnabled = false; txtContractDate.IsEnabled = false; txtPhoneNumber.SetBinding(TextBox.TextProperty, txtPhoneNumberBinding); txtSubscriber.SetBinding(TextBox.TextProperty, txtSubscriberBinding); } else if (action == ActionState.Delete) { try { System.Data.DataRow deleterow = phoneNumbersDataSet.PhoneNumbers.Rows[lstPhones.SelectedIndex]; deleterow.Delete(); tblPhoneNumbersAdapter.Update(phoneNumbersDataSet.PhoneNumbers); phoneNumbersDataSet.AcceptChanges(); } catch (System.Data.DataException ex) { phoneNumbersDataSet.RejectChanges(); MessageBox.Show(ex.Message); MessageBox.Show(ex.Message); } btnNew.IsEnabled = true; btnEdit.IsEnabled = true; btnDelete.IsEnabled = true; btnSave.IsEnabled = false; btnCancel.IsEnabled = false; lstPhones.IsEnabled = true; btnPrevious.IsEnabled = true; btnNext.IsEnabled = true; txtPhoneNumber.IsEnabled = false; txtSubscriber.IsEnabled = false; txtPhoneNumber.SetBinding(TextBox.TextProperty, txtPhoneNumberBinding); txtSubscriber.SetBinding(TextBox.TextProperty, txtSubscriberBinding); txtContractValue.SetBinding(TextBox.TextProperty, txtContractValueBinding); txtContractDate.SetBinding(TextBox.TextProperty, txtContractDateBinding); } }