各位C#高手,小弟一个问题请各位帮忙,在VS.NET2005中,想把Lable,TextBox/ComboBox,Form,DataGridView,四个控件组合起来,Lable.text表示字段中文名字,在TextBox/ComboBox中输入或者点击下拉的时候能在数据库中搜索相应的信息在DataGridView中显示出来,记得有位高手(chsfly(一蓑烟雨任平生))开发过,但是代码不全,所以在这里再次提出,请不惜指教.
------解决方案--------------------------------------------------------
新建一个usercontrol ,把这些东西都放进去
新建一个属性字段如 ControlText ,给Lable.text赋值
其他的照这样做就行了
TextBox/ComboBox中输入或者点击下拉的时候能在数据库中搜索相应的信息在DataGridView中显示出来,
在TextBox/ComboBox 的TextChanged 中把 DataGridView的DataSource 绑定
------解决方案--------------------------------------------------------
你设置label为autozise为true。
下拉列表绑定一个bindingsource,datagridview再绑定一个bindingsource。
然后在combobox的事件中写代码就好了。
------解决方案--------------------------------------------------------
using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
namespace RamiSaad
{
/// <summary>
/// Summary description for DataGridComboBoxColumn.
/// This class builds the combobox column user control for datagrids for windows applications.
/// It inherits DataGridTextBoxColumn, since this is already an available control in the .Net Framework.
/// What needs to be modified, depending on the application, is the Leave event.
/// To use this class, simply add it to the project, construct an instance, and use the properties of its ComboBox
/// this is a sample usage:
///
/// DataGridComboBoxColumn col2=new DataGridComboBoxColumn();
/// col2.ComboBox.DataSource=dataSet.Client;
/// col2.ComboBox.DisplayMember= "Name ";
/// col2.ComboBox.ValueMember= "Id ";
/// dataGrid1.TableStyles[0].GridColumnStyles.Add(col2);
///
/// </summary>
public class DataGridComboBoxColumn : DataGridTextBoxColumn
{
// Hosted combobox control
private ComboBox comboBox;
private CurrencyManager cmanager;
private int iCurrentRow;
// Constructor - create combobox,
// register selection change event handler,
// register lose focus event handler
public DataGridComboBoxColumn()
{
this.cmanager = null;
// Create combobox and force DropDownList style
this.comboBox = new ComboBox();
this.comboBox.DropDownStyle = ComboBoxStyle.DropDownList;
this.ComboBox.Visible = false;
// Add event handler for notification when combobox loses focus
this.comboBox.Leave += new EventHandler(comboBox_Leave);
this.ComboBox.VisibleChanged +=new EventHandler(ComboBox_VisibleChanged);
}
// Property to provide access to combobox
public ComboBox ComboBox
{
get { return comboBox; }
}
// On edit, add scroll event handler, and display combobox
protected override void Edit(System.Windows.Forms.CurrencyManager
source, int rowNum, System.Drawing.Rectangle bounds, bool readOnly,
string instantText, bool cellIsVisible)
{
base.Edit(source, rowNum, bounds, readOnly, instantText,
cellIsVisible);
if (!readOnly && cellIsVisible)
{
// Save current row in the DataGrid and currency manager
// associated with the data source for the DataGrid
this.iCurrentRow = rowNum;
this.cmanager = source;
// Add event handler for DataGrid scroll notification
this.DataGridTableStyle.DataGrid.Scroll
+= new EventHandler(DataGrid_Scroll);
// Site the combobox control within the current cell
this.comboBox.Parent = this.TextBox.Parent;