void RefreshGrida()
{
DataTable tblSelect = new DataTable();
tblSelect = db.RunQuery("Select ID 'رقم المكان' , Name 'مكان الكتاب' From Places");
dgv.DataSource = tblSelect;
bmb = this.BindingContext[tblSelect];
lblPostion.Text = (bmb.Position + 1) + "/" + bmb.Count;
}
private void loadDSDATBAO()
{
//Tao lien ket tblPHIEUDATBAO voi cac control
txtSoPhieu.DataBindings.Add("text", tblPHIEUDATBAO, "SoPhieu", true);
dtNgayDat.DataBindings.Add("value", tblPHIEUDATBAO, "NgayDat", true);
cbSDT.DataBindings.Add("SelectedValue", tblPHIEUDATBAO, "MaKH", true);
bindPDB = this.BindingContext[tblPHIEUDATBAO];
//dang ki event positonchanged xu li boi dbPDB_Positonchanged ()
bindPDB.PositionChanged += new EventHandler(bdPDB_PositionChanged);
}
// <Snippet1>
private void PrintCell(object sender, MouseEventArgs e)
{
DataGrid thisGrid = (DataGrid)sender;
DataGridCell myDataGridCell = thisGrid.CurrentCell;
BindingManagerBase bm = BindingContext[thisGrid.DataSource, thisGrid.DataMember];
DataRowView drv = (DataRowView)bm.Current;
Console.WriteLine(drv [myDataGridCell.ColumnNumber]);
Console.WriteLine(myDataGridCell.RowNumber);
}
private void tao_mat_hang()
{
bangHH = qlBanHangBLO.Doc_dl_HH();
lbMatHang.DisplayMember = "TenHH";
lbMatHang.ValueMember = "MaHH";
lbMatHang.DataSource = bangHH;
bindingHH = BindingContext[bangHH];
bindingHH.PositionChanged += new EventHandler(bindingHH_PositionChanged);
}
public void dodulieuvaodatagridview()
{
dt = laydulieu("select * from nguoidung");
bs = new BindingSource();
bs.DataSource = dt;
danhsach = BindingContext[bs];
dataGridView1.DataSource = bs;
}
private void DeleteFileFormat()
{
BindingManagerBase bm = this.BindingContext[dataView1];
string settings_name = ((DataRowView)bm.Current).Row[1].ToString();
if (cl.DelFormat(settings_name))
{
this.dataView1.Table.Rows.Remove(((DataRowView)bm.Current).Row);
}
}
void RefreshGrida()
{
DataTable tblSelect = new DataTable();
tblSelect = db.RunQuery("Select d.ID 'رقم دار النشر', d.Name 'دار النشر', c.Name 'الدولة' From Dar_Nashr d , Countrys c Where d.Country_ID = c.ID");
dgv.DataSource = tblSelect;
bmb = this.BindingContext[tblSelect];
lblPostion.Text = (bmb.Position + 1) + "/" + bmb.Count;
}
private void loadDSDATBAO()
{
//Tao lien ket tblPHIEUDATBAO voi cac control
txtSoPhieu.DataBindings.Add("text", tblPHIEUDATBAO, "SoPhieu", true);
dtNgayDat.DataBindings.Add("value", tblPHIEUDATBAO, "NgayDat", true);
cbSDT.DataBindings.Add("SelectedValue", tblPHIEUDATBAO, "MaKH", true);
bindPDB = this.BindingContext[tblPHIEUDATBAO];
//Đăng Ký Event PositionChanged xu ly bởi bdPDB_PositionChanged (object sender, EventArgs e)
bindPDB.PositionChanged += new EventHandler(bdPDB_PositionChanged);
}
void RefreshGrida()
{
DataTable tblSelect = new DataTable();
tblSelect = db.RunQuery(" Select ID 'رقم التصنيف', Name 'أسم التصنيف' From Categorys");
dgv.DataSource = tblSelect;
bmb = this.BindingContext[tblSelect];
lblPostion.Text = (bmb.Position + 1) + "/" + bmb.Count;
}
private void bindingManager_CurrentChanged(object sender, EventArgs e)
{
BindingManagerBase bindingManagerBase = (BindingManagerBase)sender;
foreach (object obj in bindingManagerBase.Bindings)
{
Binding binding = (Binding)obj;
binding.ControlUpdateMode = ControlUpdateMode.OnPropertyChanged;
}
}
// <Snippet1>
private void PrintPropertyDescriptions(BindingManagerBase b)
{
Console.WriteLine("Printing Property Descriptions");
PropertyDescriptorCollection ps = b.GetItemProperties();
for (int i = 0; i < ps.Count; i++)
{
Console.WriteLine("\t" + ps[i].Name + "\t" + ps[i].PropertyType);
}
}
void RefreshGrida()
{
DataTable tblSelect = new DataTable();
tblSelect = db.RunQuery("Select a.ID 'رقم المؤلف', a.Name 'أسم المؤلف', a.DOB 'تاريخ الميلاد', c.Name 'الدولة' from Authors a, Countrys c where a.Country_ID = c.ID ");
dgv.DataSource = tblSelect;
bmb = this.BindingContext[tblSelect];
lblPostion.Text = (bmb.Position + 1) + "/" + bmb.Count;
}
private void FrmProductCategory_Load(object sender, EventArgs e)
{
db = new DatabaseDataContext();
tbl_ProductCategory = db.tbl_LoaiHangHoas;
LoadDatabaseToDataGridView();
//Binding
txtName.DataBindings.Add("Text", tbl_ProductCategory, "Ten", true);
listProductCategory = this.BindingContext[tbl_ProductCategory];
}
public void LoadDataBinding()
{
txtMaSV.DataBindings.Add("text", BangSinhVien, "MaSV", true);
txtHoTen.DataBindings.Add("text", BangSinhVien, "HoTen", true);
dtpNgaySinh.DataBindings.Add("text", BangSinhVien, "NgaySinh", true);
radNam.DataBindings.Add("checked", BangSinhVien, "GioiTinh", true);
cbbLop.DataBindings.Add("SelectedValue", BangSinhVien, "MaLop", true);
txtDiaChi.DataBindings.Add("text", BangSinhVien, "DiaChi", true);
pictureBoxHinh.DataBindings.Add("ImageLocation", BangSinhVien, "Hinh", true);
DSSV = this.BindingContext[BangSinhVien];
}
private void btnAddToDomainFilterList_Click(object sender, EventArgs e)
{
if (this.tbDomain.Text != "")
{
this.xa.Settings.domainFilters.Add(this.tbDomain.Text);
this.tbDomain.Text = "";
BindingManagerBase bmb = this.lbDomainFilters.BindingContext[this.xa.Settings.domainFilters];
bmb.SuspendBinding();
bmb.ResumeBinding();
}
}
public FRM_CATEGORIES()
{
InitializeComponent();
da = new SqlDataAdapter("select id_cat as 'المعرف', DESCRIPTION_CAT as 'الصنف' from categories", sqlcon);
da.Fill(dt);
dgList.DataSource = dt;
txtID.DataBindings.Add("text", dt, "المعرف");
txtDes.DataBindings.Add("text", dt, "الصنف");
bmb = this.BindingContext[dt];
lblPosition.Text = (bmb.Position + 1) + " / " + bmb.Count;
}
public Users_Manage_Form()
{
Business_Layer.CLS_LOGIN login = new Business_Layer.CLS_LOGIN();
InitializeComponent();
da = new SqlDataAdapter("SELECT USERNAME AS 'Username',PASSWORD AS 'Password' from Users", sqlcon);
da.Fill(dt);
metroGrid1.DataSource = dt;
bmb = this.BindingContext[dt];
}
public static void SuspendTwoWayBinding(BindingManagerBase bindingManager)
{
if (bindingManager == null)
{
throw new ArgumentNullException("bindingManager");
}
foreach (Binding b in bindingManager.Bindings)
{
b.DataSourceUpdateMode = DataSourceUpdateMode.Never;
}
}
//===================================================
public FRM_Delivery_Boy()
{
InitializeComponent();
DA = new SqlDataAdapter("select * from [Delivery Mens]", MyCon);
DA.Fill(Dt);
dataGridView1.DataSource = Dt;
textBox_ID.DataBindings.Add("text", Dt, "DeliveryMan_ID");
textBox_name.DataBindings.Add("text", Dt, "DelieveryMAn_Name");
textBox_phone.DataBindings.Add("text", Dt, "phone");
BM = this.BindingContext[Dt];
}
private void tiendodean_Load(object sender, EventArgs e)
{
addcot1();
addcot2();
addcot3();
addcot4();
dateTimePicker1.Value = DateTime.Now;
dataGridViewtiendodean.AutoGenerateColumns = false;
dataGridViewtiendodean.DataSource = tiendodean;
btiendodean = this.BindingContext[tiendodean];
}
public static void UpdateDataBoundObject(BindingManagerBase bindingManager)
{
if (bindingManager == null)
{
throw new ArgumentNullException("bindingManager");
}
foreach (Binding b in bindingManager.Bindings)
{
b.WriteValue();
}
}
private void btnLeft_Click(object sender, System.EventArgs e)
{
if (this.dvFileFields.Count == 0)
{
return;
}
BindingManagerBase bm = this.BindingContext[dvFileFields];
DataRow dr = ((DataRowView)bm.Current).Row;
RemoveFileField(dr);
}
private void DelFormatFieldProps()
{
if (dvFileFields.Count < 1)
{
return;
}
BindingManagerBase bm = this.BindingContext[dvFileFields];
DataRow row = ((DataRowView)bm.Current).Row;
RemoveFileField(row);
}
private void PrevHandler(object sender, EventArgs e)
{
CurrencyManager cm = BindingContext [dataset, "Sports.AthletesSports"] as CurrencyManager;
cm.Position--;
Console.WriteLine("CM POSITION: {0} {1}", cm.Position, cm);
BindingManagerBase scm = BindingContext [dataset, "Sports.AthletesSports.AthleteName"] as BindingManagerBase;
Console.WriteLine("BINDINGS: {0} {1}", scm, (scm != null ? scm.Position : -666));
}
public void DoDuLieu_Vao_DatagridView()
{
dt = laydulieu("select * from mon");
bs = new BindingSource();
bs.DataSource = dt;
danhsach = BindingContext[bs];
dataGridView1.DataSource = bs;
bindingNavigator1.BindingSource = bs;
}
public Categories()
{
InitializeComponent();
da = new SqlDataAdapter("select cat_ID as 'معرف الصنف' , Description as 'اسم الصنف' from Categories", con);
da.Fill(dt);
dgvcategories.DataSource = dt;
textid.DataBindings.Add("text", dt, "معرف الصنف");
textname.DataBindings.Add("text", dt, "اسم الصنف");
bm = this.BindingContext[dt];
labelpos.Text = (bm.Position + 1) + " / " + bm.Count;
}
public F_CatManaging()
{
InitializeComponent();
da = new SqlDataAdapter("select ID,DESCRPTION_CAT as 'Category' from CATEGORIES", SqlConnection);
da.Fill(dt);
dataGridView1.DataSource = dt;
txtID.DataBindings.Add("text", dt, "ID");
txtDes.DataBindings.Add("text", dt, "Category");
bmb = this.BindingContext[dt];
label3.Text = (bmb.Position + 1) + " / " + bmb.Count;
}
private void RefrescarLista()
{
BindingManagerBase bm = this.lProps.BindingContext[this._puntoAcceso.Propiedades.Items];
CurrencyManager cm = (CurrencyManager)bm;
if (cm != null)
{
cm.Refresh();
}
EventoCambiaEstado(estadoModelo.Pendiente);
}
public FRM_CAT_Mngmnt()
{
InitializeComponent();
da = new SqlDataAdapter("select ID_Cat,Name_Cat from Categories", conn);
da.Fill(dt);
dataGridView1.DataSource = dt;
textBox_CatID.DataBindings.Add("text", dt, "ID_Cat");
textBox_CatName.DataBindings.Add("text", dt, "Name_Cat");
bm = this.BindingContext[dt];
label3.Text = (bm.Position + 1) + "/" + bm.Count;
}
/// <summary>
/// 选择不同收费标准
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void radfee_CheckedChanged(object sender, EventArgs e)
{
RadioButton bt = sender as RadioButton;
if (null == bt || !bt.Checked)
{
return;
}
int index = Convert.ToInt16(basefun.valtag(Convert.ToString(bt.Tag), "val"));
//查询收费标准,默认增加一条明细
DataTable tabpark = this.ds.Tables["停车场管理"];
DataView dvfee = this.ds.Tables["收费标准"].DefaultView;
BindingManagerBase bindMgrbase = this.BindingContext[tabpark];
DataRowView drpark = bindMgrbase.Current as DataRowView;
if (null == drpark || "门岗" == Convert.ToString(drpark["类型"]) || dvfee.Count < 1)
{
return;
}
DataTable tabdetail = this.ds.Tables["收费标准时段"];
if (4 == index || 5 == index)
{
tabdetail = this.ds.Tables["收费标准时刻"];
}
DataRowView drvFee = dvfee[0];
string feetype = "消费方式" + Convert.ToString(index);
if (feetype != Convert.ToString(drvFee["计费方式"]))
{
drvFee["计费方式"] = feetype;
}
tabdetail.DefaultView.RowFilter = string.Format("标准ID='{0}'", drvFee["ID"]);
tabdetail.DefaultView.Sort = "序号";
DataRowView drvdetail = null;
if (tabdetail.DefaultView.Count > 0)
{
drvdetail = tabdetail.DefaultView[0];
}
if (null == drvdetail)
{
DataRow dr = tabdetail.NewRow();
dr["ID"] = Guid.NewGuid().ToString();
dr["标准ID"] = drvFee["ID"];
dr["序号"] = 1;
tabdetail.Rows.Add(dr);
}
//刷新编辑控件值
this.tabFeeStd.SelectedIndex = -1 + index;
this.isValSetting = true;
this.setFeeParam(tabdetail, this.tabFeeStd.SelectedTab);
this.isValSetting = false;
}
private void ConfigureDataSource(object newDataSource, string newDataMember, bool force)
{
if (!_isConfigurating)
{
_isConfigurating = true;
try
{
if (DataSource == newDataSource && DataMember == newDataMember && !force)
{
return;
}
base.DataSource = newDataSource;
base.DataMember = newDataMember;
if (_isInitializing)
{
_loadOnEndInit = true;
}
else
{
UnwireEvents(_errorManager);
if (ContainerControl != null && DataSource != null && ContainerControl.BindingContext != null)
{
_errorManager = ContainerControl.BindingContext[DataSource, DataMember];
}
else
{
_errorManager = null;
}
WireEvents(_errorManager);
if (_errorManager != null)
{
UpdateBinding();
}
}
}
finally
{
_isConfigurating = false;
}
}
}
private void WireEvents(BindingManagerBase bindingManager)
{
if (bindingManager == null)
{
return;
}
bindingManager.CurrentChanged += HandlerCurrentChanged;
bindingManager.BindingComplete += HandlerBindingComplete;
var currencyManager = bindingManager as CurrencyManager;
if (currencyManager != null)
{
currencyManager.ItemChanged += HandlerItemChanged;
currencyManager.Bindings.CollectionChanged += HandlerBindingsChanged;
}
}
