dgv属性用法

winform的dataviewgrid与infragistics的ultraGrid的部分属性用法 2008-09-09 15:50 ////AutoSizeColumnsMode指定如何设置列宽
//setGridView.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
////AutoSizeRowsMode指定如何设置行高
//setGridView.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.AllCells;
//// 设定列标题的宽度可以自由调整
//setGridView.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.AutoSize;
//// 设定行标题的宽度可以自由调整
//setGridView.RowHeadersWidthSizeMode = DataGridViewRowHeadersWidthSizeMode.AutoSizeToAllHeaders;

//DataGridViewCheckBoxColumn column = new DataGridViewCheckBoxColumn();
//setGridView.Columns.Insert(0, column);


//列标题文本居中 DataGridViewColumn控件中的列
foreach (DataGridViewColumn col in setGridView.Columns)
{
col.SortMode = DataGridViewColumnSortMode.NotSortable;
}
setGridView.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;


//行高度 DataGridViewRow控件中的行
foreach (DataGridViewRow rows in setGridView.Rows)
{
rows.Height = 15;
}


//单击选取整行 SelectionMode指定如何设置单元格 DataGridViewSelectionMode可以如何选定单元格
setGridView.SelectionMode = DataGridViewSelectionMode.FullRowSelect; //FullRowSelect通过单击表头和所包含的单元格选取整行
//设定不显示DateGridView的最左一列
setGridView.RowHeadersVisible = false;
//返回DataGridView控件中选中行的任意单元格的数据
return setGridView.CurrentCell.OwningRow.Cells[0].Value.ToString();





------------------------------------------------------------------------------------------
this.dataGridView1.DataSource = ds.Tables[0]; //将dataGridView邦定到数据集第一个表


//获取当前单元格的值
this.dataGridView1.CurrentCell = this.dataGridView1[1, 2];
object value = this.dataGridView1.CurrentCell.Value;
if (value != null)
{
string strValue = value.ToString();
textBox1.Text = strValue;
}

//需要初始化事件吧
this.dataGridView1.SelectionChanged += new System.EventHandler(object sender, EventArgs e);

this.dataGridView1.SelectionChanged += new System.EventHandler(this.dataGridView1_SelectionChanged_1);



this.button1.Click += new System.EventHandler(this.button1_Click);


-----------------------------------------------------------------------------------------

str = "select * from Qu

alityInfo where emname = '" + s1 + "'";
oda = new OleDbDataAdapter(str, conn);
oda.Fill(dataSet1, "QualityInfo1");


this.dataSet1.Relations.Add("Select",
dataSet1.Tables["QualityInfo1"].Columns["deteid"],
dataSet1.QualityDetails.Columns["deteid"]);
OleDbCommandBuilder cb = new OleDbCommandBuilder(oda);

this.ultraGrid1.DataSource = this.dataSet1;
this.ultraGrid1.DataMember = "QualityInfo1";




--------------------------------ultraGrid--------------------------------------------------


int i = this.ultraGrid1.ActiveRow.Index; //获得行号


string id = this.ultraGrid1.Rows[i].Cells[0].Value.ToString().Trim();//获得单元格数据


groupbybox 是关系到Drag a column here to group by that column这行英文的显示功能。

this.ultraGrid1.ActiveCell.Value.ToString();//获得选中当前单元格数据

this.ultraGrid1.ActiveRow.Band.ToString();//获得当前活动行所属的关系.