private void radGridView1_UserAddedRow(object sender, GridViewRowEventArgs e) { var commandServer = new CommandServer(); _bindingSource = new BindingSource { DataSource = commandServer.DataGridSet(@"select key_typeHelp, typeHelp as [Тип помощи] from typeHelp order by typeHelp").Tables[0] }; radGridView1.Invoke(new MethodInvoker(delegate() { radGridView1.DataSource = _bindingSource.DataSource; })); }
//обновление таблицы private void radGridViewSoc_UserAddedRow(object sender, GridViewRowEventArgs e) { var commandServer = new CommandServer(); _bindingSource_soc = new BindingSource { DataSource = commandServer.DataGridSet(@"select * from socPersonelViewColor() order by [ФИО]").Tables[0] }; radGridViewSoc.Invoke(new MethodInvoker(delegate() { radGridViewSoc.DataSource = _bindingSource_soc; })); }
private void radGridView5_UserAddedRow(object sender, GridViewRowEventArgs e) { var commandServer = new CommandServer(); _bindingSource_personel = new BindingSource { DataSource = commandServer.DataGridSet(@"select * from spezialistView(0, 0) order by [ФИО]").Tables[0] }; radGridView5.Invoke(new MethodInvoker(delegate() { radGridView5.DataSource = _bindingSource_personel; })); }
private void LoadGridInspector(object sender, DoWorkEventArgs e) { var commandServer = new CommandServer(); _binding = new BindingSource { DataSource = commandServer.DataGridSet(@"select* from spezialistView(1, 0) order by[ФИО]").Tables[0] }; radGridView1.DataSource = _binding; if (radGridView1.Columns.Count > 0) { radGridView1.Columns[0].IsVisible = false; radGridView1.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill; } }
private void LoadGridInspector() { var commandServer = new CommandServer(); _binding = new BindingSource { DataSource = commandServer.DataGridSet(@"select* from spezialistViewColor('1') where date_end is null order by[ФИО]").Tables[0] }; radGridView1.DataSource = _binding; if (radGridView1.Columns.Count > 0) { radGridView1.Columns[0].IsVisible = false; radGridView1.Columns[2].IsVisible = false; radGridView1.Columns[3].IsVisible = false; radGridView1.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill; } }
private void UpdateGridView() { var commandServer = new CommandServer(); _bindingSource = new BindingSource { DataSource = commandServer.DataGridSet(@"select key_typeHelp, typeHelp as [Тип помощи] from typeHelp order by typeHelp").Tables[0] }; radGridView1.Invoke(new MethodInvoker(delegate() { radGridView1.DataSource = _bindingSource; radGridView1.Columns[0].IsVisible = false; using (radGridView1.DeferRefresh()) { radGridView1.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill; foreach (GridViewDataColumn column in radGridView1.Columns) { column.BestFit(); } } radGridView1.Columns[1].WrapText = true; })); }