private void btManRefresh_Click(object sender, EventArgs e) { string name = this.ManufacturerlookUpEdit.Text; if (name.Length == 0) { return; } if (name.Length > 3) { name = name.Substring(0, 3); } try { MDataSet.ManufacturerDataTable _tmp = new MDataSet.ManufacturerDataTable(); (this.ParentForm as FormDialog).MainForm.manufacturerTableAdapter.FillByName(_tmp, name); this.mDataSet.Manufacturer.Merge(_tmp); } catch (Exception err) { MessageBox.Show(err.Message); } }
public virtual MDataSet.ManufacturerDataTable GetDataNew() { this.Adapter.SelectCommand = this.CommandCollection[3]; MDataSet.ManufacturerDataTable dataTable = new MDataSet.ManufacturerDataTable(); this.Adapter.Fill(dataTable); return dataTable; }
public virtual MDataSet.ManufacturerDataTable GetDataByName(string name) { this.Adapter.SelectCommand = this.CommandCollection[1]; if ((name == null)) { this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value; } else { this.Adapter.SelectCommand.Parameters[1].Value = ((string)(name)); } MDataSet.ManufacturerDataTable dataTable = new MDataSet.ManufacturerDataTable(); this.Adapter.Fill(dataTable); return dataTable; }
public virtual MDataSet.ManufacturerDataTable GetDataByReceiptMasterRef(System.Nullable<int> ReceiptMasterRef) { this.Adapter.SelectCommand = this.CommandCollection[2]; if ((ReceiptMasterRef.HasValue == true)) { this.Adapter.SelectCommand.Parameters[1].Value = ((int)(ReceiptMasterRef.Value)); } else { this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value; } MDataSet.ManufacturerDataTable dataTable = new MDataSet.ManufacturerDataTable(); this.Adapter.Fill(dataTable); return dataTable; }
private void btManRefresh_Click(object sender, EventArgs e) { string name = this.ManufacturerlookUpEdit.Text; if (name.Length == 0) return; if (name.Length > 3) name = name.Substring(0, 3); try { MDataSet.ManufacturerDataTable _tmp = new MDataSet.ManufacturerDataTable(); (this.ParentForm as FormDialog).MainForm.manufacturerTableAdapter.FillByName(_tmp,name); this.mDataSet.Manufacturer.Merge(_tmp); } catch (Exception err) { MessageBox.Show(err.Message); } }