基本信息
源码名称:combobox 绑定多列 例子
源码大小:0.10M
文件格式:.zip
开发语言:C#
更新时间:2015-06-12
友情提示:(无需注册或充值,赞助后即可获取资源下载链接)
嘿,亲!知识可是无价之宝呢,但咱这精心整理的资料也耗费了不少心血呀。小小地破费一下,绝对物超所值哦!如有下载和支付问题,请联系我们QQ(微信同号):78630559
本次赞助数额为: 2 元×
微信扫码支付:2 元
×
请留下您的邮箱,我们将在2小时内将文件发到您的邮箱
源码介绍
using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
namespace MyCustomControls
{
public delegate void AfterRowSelectEventHandler(object sender, DataRow SelectedRow);
/// <summary>
/// Summary description for MultiColumnComboPopup.
/// </summary>
public class MultiColumnComboPopup : System.Windows.Forms.Form
{
/// <summary>
/// Required designer variable.
/// </summary>
private System.ComponentModel.Container components = null;
private DataRow selectedRow = null;
private System.Windows.Forms.ListView lstvMyView;
private DataRow[] inputRows = null;
private DataTable dataTable = null;
private int mCols = 0;
private int mRows = 0;
private string[] columnsToDisplay = null;
private string[][] data = null;
public event AfterRowSelectEventHandler AfterRowSelectEvent;
public MultiColumnComboPopup()
{
InitializeComponent();
mCols = 4;
mRows = 0;
InitializeGridProperties();
}
public MultiColumnComboPopup(DataRow[] drows) {
InitializeComponent();
this.inputRows = drows;
SetDataRows(inputRows);
this.dataTable = inputRows[0].Table;
}
public MultiColumnComboPopup(DataTable dtable, ref DataRow selRow, string[] colsToDisplay) {
InitializeComponent();
this.dataTable = dtable;
this.selectedRow = selRow;
this.columnsToDisplay = colsToDisplay;
if(columnsToDisplay!=null)
SetDataTable(dataTable,columnsToDisplay);
else
SetDataTable(dataTable);
}
/// <summary>
/// Clean up any resources being used.
/// </summary>
protected override void Dispose( bool disposing )
{
if( disposing )
{
if(components != null)
{
components.Dispose();
}
}
base.Dispose( disposing );
}
#region Windows Form Designer generated code
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.lstvMyView = new System.Windows.Forms.ListView();
this.SuspendLayout();
//
// lstvMyView
//
this.lstvMyView.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;
this.lstvMyView.Dock = System.Windows.Forms.DockStyle.Fill;
this.lstvMyView.FullRowSelect = true;
this.lstvMyView.GridLines = true;
this.lstvMyView.HeaderStyle = System.Windows.Forms.ColumnHeaderStyle.Nonclickable;
this.lstvMyView.MultiSelect = false;
this.lstvMyView.Name = "lstvMyView";
this.lstvMyView.Size = new System.Drawing.Size(292, 88);
this.lstvMyView.TabIndex = 0;
this.lstvMyView.View = System.Windows.Forms.View.Details;
this.lstvMyView.KeyDown = new System.Windows.Forms.KeyEventHandler(this.lstvMyView_KeyDown);
this.lstvMyView.DoubleClick = new System.EventHandler(this.lstvMyView_DoubleClick);
//
// MultiColumnComboPopup
//
this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
this.ClientSize = new System.Drawing.Size(292, 88);
this.ControlBox = false;
this.Controls.AddRange(new System.Windows.Forms.Control[] {
this.lstvMyView});
this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.None;
this.KeyPreview = true;
this.Name = "MultiColumnComboPopup";
this.ShowInTaskbar = false;
this.StartPosition = System.Windows.Forms.FormStartPosition.Manual;
this.KeyDown = new System.Windows.Forms.KeyEventHandler(this.MultiColumnComboPopup_KeyDown);
this.Leave = new System.EventHandler(this.MultiColumnComboPopup_Leave);
this.Deactivate = new System.EventHandler(this.MultiColumnComboPopup_Deactivate);
this.ResumeLayout(false);
}
#endregion
#region Functions
private void InitializeGridProperties() {
lstvMyView.Items.Clear();
lstvMyView.Columns.Clear();
//Add Data Headers
for(int i=0;i<mCols;i ) {
lstvMyView.Columns.Add(columnsToDisplay[i],-1,HorizontalAlignment.Left);
}
//Add Empty Values
for(int i=0;i<mRows;i ) {
ListViewItem item = new ListViewItem("");
lstvMyView.Items.Add(item);
for(int j=0;j<mCols;j ) {
item.SubItems.Add(" ");
}
}
}
public void SetCellValue(int Row, int Column, string ItemValue) {
if(IsValidRowAndColumn(Row,Column)) {
if(Column == 0) {
lstvMyView.Items[Row].Text = ItemValue;
}
else {
lstvMyView.Items[Row].SubItems[Column].Text = ItemValue;
}
}
}
public string GetCellValue(int Row, int Column) {
if(IsValidRowAndColumn(Row,Column)) {
if(Column == 0) {
return lstvMyView.Items[Row].Text;
}
else {
return lstvMyView.Items[Row].SubItems[Column].Text;
}
}
else {
return null;
}
}
public void SetFullRow(int Row, string[] ItemValues) {
if(IsValidRow(Row)) {
if(ItemValues.Length > 0) {
for(int i=0;i<ItemValues.Length;i ) {
SetCellValue(Row,i,ItemValues[i]);
}
}
else {
MessageBox.Show(this,"SetFullRow: Empty Values Sent","Grid Error");
}
}
}
public void SetFullRow(int Row, DataRow drow) {
if(IsValidRow(Row)) {
if(mCols > 0) {
for(int i=0;i<mCols;i ) {
SetCellValue(Row,i,(string)drow[i]);
}
}
else {
MessageBox.Show(this,"SetFullRow: Empty Values Sent","Grid Error");
}
}
}
public void SetFullColumn(int Column, string[] ItemValues) {
if(IsValidColumn(Column)) {
if(ItemValues.Length > 0) {
for(int i=0;i<lstvMyView.Items.Count;i ) {
SetCellValue(i,Column,ItemValues[i]);
}
}
else {
MessageBox.Show(this,"SetFullColumn: Empty Values Sent","Grid Error");
}
}
}
public string[] GetFullRow(int Row) {
string[] ItemValues = new string[lstvMyView.Columns.Count];
if(IsValidRow(Row)) {
for(int i=0;i<lstvMyView.Items.Count;i ) {
ItemValues[i] = GetCellValue(Row,i);
}
return ItemValues;
}
else {
return null;
}
}
public string[] GetFullColumn(int Column) {
string[] ItemValues = new string[lstvMyView.Items.Count];
if(IsValidColumn(Column)) {
for(int i=0;i<lstvMyView.Items.Count;i ) {
ItemValues[i] = GetCellValue(i,Column);
}
return ItemValues;
}
else {
return null;
}
}
public void AddItems(string[][] ItemValues) {
if(ItemValues.Length > 0) {
mRows = ItemValues.Length;
mCols = ItemValues[0].Length;
InitializeGridProperties();
for(int i=0;i<mRows;i ) {
SetFullRow(i,ItemValues[i]);
}
}
else {
MessageBox.Show(this,"AddItems: Empty Values Sent","Grid Error");
}
}
public string[][] GetItems() {
string[][] ItemValues= new string[lstvMyView.Items.Count][];
for(int i=0;i<lstvMyView.Items.Count;i ) {
ItemValues[i] = GetFullRow(i);
}
return ItemValues;
}
public void SetColumnHeaderNames(string[] ColumnNames) {
for(int i=0;i<ColumnNames.Length;i ) {
if(i>=lstvMyView.Columns.Count) {
lstvMyView.Columns.Add(ColumnNames[i],25,HorizontalAlignment.Center);
lstvMyView.Columns[i].Width = ColumnNames[i].Length * (int)Font.SizeInPoints;
}
else {
lstvMyView.Columns[i].Text = ColumnNames[i];
lstvMyView.Columns[i].Width = ColumnNames[i].Length * (int)Font.SizeInPoints;
}
}
}
public void SetColumnWidths(int[] Widths) {
for(int i=0;i<Widths.Length;i ) {
if(i >= lstvMyView.Columns.Count) {
lstvMyView.Columns.Add("",Widths[i] * (int)lstvMyView.Font.SizeInPoints ,HorizontalAlignment.Center);
}
else {
lstvMyView.Columns[i].Width = Widths[i] * (int)Font.SizeInPoints;
}
}
}
public void SetColumnWidth(int Column, int ColWidth) {
if(IsValidColumn(Column)) {
lstvMyView.Columns[Column].Width = ColWidth * (int)Font.SizeInPoints;
}
}
public void SetDataTable(DataTable dtable) {
DataColumnCollection dcc = dtable.Columns;
DataRowCollection drc = dtable.Rows;
data = new string[drc.Count][];
string[] strarrColNames = null;
int ictr = 0;
for(int i=0;i<drc.Count;i ) {
data[i] = new string[dcc.Count];
}
foreach (DataRow dr in drc) {
for(int i=0;i<dcc.Count;i ) {
data[ictr][i] = dr[i].ToString();
}
ictr ;
}
strarrColNames = new string[dcc.Count];
for(int i=0;i<dcc.Count;i ) {
strarrColNames[i] = dcc[i].ColumnName;
}
AddItems(data);
//SetColumnHeaderNames(strarrColNames);
}
public void SetDataTable(DataTable dtable,string[] colsToDisplay) {
DataRowCollection drc = dtable.Rows;
data = new string[drc.Count][];
int ictr = 0;
for(int i=0;i<drc.Count;i ) {
data[i] = new string[colsToDisplay.Length];
}
foreach (DataRow dr in drc) {
for(int i=0;i<colsToDisplay.Length;i ) {
data[ictr][i] = dr[colsToDisplay[i]].ToString();
}
ictr ;
}
AddItems(data);
//SetColumnHeaderNames(colsToDisplay);
}
private bool IsValidRowAndColumn(int Row, int Column) {
if(Column < 0 || Row < 0) {
MessageBox.Show(this,"Row or Column Cannot be Negative!","Grid Error");
return false;
}
else if(Row > lstvMyView.Items.Count) {
MessageBox.Show(this,"SetCellValue: Row Out Of Range","Grid Error");
return false;
}
else if(Column > lstvMyView.Columns.Count) {
MessageBox.Show(this,"SetCellValue: Column Out Of Range " Column.ToString(),"Grid Error");
return false;
}
else {
return true;
}
}
private bool IsValidRow(int Row) {
if(Row < 0) {
MessageBox.Show(this,"Row Cannot be Negative!","Grid Error");
return false;
}
else if(Row > lstvMyView.Items.Count) {
MessageBox.Show(this,"Row Out Of Range","Grid Error");
return false;
}
else {
return true;
}
}
private bool IsValidColumn(int Column) {
if(Column < 0) {
MessageBox.Show(this,"Column Cannot be Negative!","Grid Error");
return false;
}
else if(Column > lstvMyView.Columns.Count) {
MessageBox.Show(this,"Column Out Of Range " Column.ToString() ,"Grid Error");
return false;
}
else {
return true;
}
}
#endregion
private void gridValue_SelectedIndexChanged(object sender, System.EventArgs e) {
//
}
public void SetDataRows(DataRow[] drows){
mRows = drows.Length;
mCols = drows[0].Table.Columns.Count;
InitializeGridProperties();
for(int i=0;i<mRows;i ) {
SetFullRow(i,drows[i]);
}
SetColumnHeaderNames(GetColumnNames(drows[0]));
}
private string[] GetColumnNames(DataRow drow){
string[] strColNames = new string[drow.Table.Columns.Count];
for(int i=0;i<drow.Table.Columns.Count;i ){
strColNames[i] = drow.Table.Columns[i].ColumnName;
}
return strColNames;
}
private void MultiColumnComboPopup_Deactivate(object sender, System.EventArgs e) {
this.Close();
}
private void MultiColumnComboPopup_Leave(object sender, System.EventArgs e) {
this.Close();
}
private void MultiColumnComboPopup_KeyDown(object sender, System.Windows.Forms.KeyEventArgs e) {
if(e.KeyData==Keys.Escape){
this.Close();
}
}
private void lstvMyView_KeyDown(object sender, System.Windows.Forms.KeyEventArgs e) {
if(e.KeyData==Keys.Enter){
if(lstvMyView.SelectedItems.Count>0){
selectedRow = dataTable.Rows[lstvMyView.SelectedIndices[0]];
if(AfterRowSelectEvent!=null)
AfterRowSelectEvent(this,selectedRow);
}
this.Close();
}
}
private void lstvMyView_DoubleClick(object sender, System.EventArgs e) {
if(lstvMyView.SelectedItems.Count>0){
selectedRow = dataTable.Rows[lstvMyView.SelectedIndices[0]];
if(AfterRowSelectEvent!=null)
AfterRowSelectEvent(this,selectedRow);
}
this.Close();
}
private string[] GetColumnNames(DataTable dtable){
string[] strColNames = new string[dtable.Columns.Count];
for(int i=0;i<dtable.Columns.Count;i ){
strColNames[i] = dtable.Columns[i].ColumnName;
}
return strColNames;
}
public DataRow[] InputRows{
set{
inputRows = value;
if(inputRows == null)
return;
SetDataRows(inputRows);
}
}
// public string[] NonDisplayColumnNames{
// set{
//
// }
// }
public DataTable Table{
set{
dataTable = value;
if(dataTable == null)
return;
SetDataTable(dataTable);
}
}
public DataRow SelectedRow{
get{
return selectedRow;
}
}
public int Cols {
get {
mCols = lstvMyView.Columns.Count;
return mCols;
}
}
public int Rows {
get {
mRows = lstvMyView.Items.Count;
return mRows;
}
}
}
}