| 发表于：2007-03-27 16:21:373楼 得分:20 |
using system;
using system.drawing;
using system.collections;
using system.componentmodel;
using system.windows.forms;
using system.data;
using system.data.sqlclient;
namespace prjdatagirdstyle
{
public class form1 : system.windows.forms.form
{
private system.windows.forms.datagrid grdtest;
private system.componentmodel.container components = null;
public form1（)
{
initializecomponent（);
}
protected override void dispose（ bool disposing )
{
if（ disposing )
{
if （components != null)
{
components.dispose（);
}
}
base.dispose（ disposing );
}
#region windows 窗体设计器生成的代码
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void initializecomponent（)
{
this.grdtest = new system.windows.forms.datagrid（);
（（system.componentmodel.isupportinitialize)（this.grdtest)).begininit（);
this.suspendlayout（);
//
// grdtest
//
this.grdtest.datamember = " ";
this.grdtest.headerforecolor = system.drawing.systemcolors.controltext;
this.grdtest.location = new system.drawing.point（16, 24);
this.grdtest.name = "grdtest ";
this.grdtest.size = new system.drawing.size（368, 224);
this.grdtest.tabindex = 0;
//
// form1
//
this.autoscalebasesize = new system.drawing.size（6, 14);
this.clientsize = new system.drawing.size（416, 283);
this.controls.add（this.grdtest);
this.name = "form1 ";
this.text = "form1 ";
this.load += new system.eventhandler（this.form1_load);
（（system.componentmodel.isupportinitialize)（this.grdtest)).endinit（);
this.resumelayout（false);
}
#endregion
/// <summary>
/// 应用程序的主入口点。
/// </summary>
[stathread]
static void main（)
{
application.run（new form1（));
}
//在这里对列名和列的对齐方式方式进行设置
private void form1_load（object sender, system.eventargs e) {
sqlconnection cnn=new sqlconnection（ "server=.;database=pubs;uid=sa;pwd=; ");
sqldataadapter da=new sqldataadapter（ "select * from titles ",cnn);
datatable dt=new datatable（ "titles ");
datagridtablestyle dgts=new datagridtablestyle（);
dgts.mappingname= "titles ";
this.grdtest.tablestyles.add（dgts);
datagridcolumnstyle dgcs1=new datagridtextboxcolumn（);
dgcs1.mappingname= "title_id ";
dgcs1.headertext= "编号 ";
dgcs1.alignment=horizontalalignment.center;
dgts.gridcolumnstyles.add（dgcs1);
datagridcolumnstyle dgcs2=new datagridtextboxcolumn（);
dgcs2.mappingname= "title ";
dgcs2.headertext= "标题 ";
dgcs2.alignment=horizontalalignment.left;
dgts.gridcolumnstyles.add（dgcs2);
datagridcolumnstyle dgcs3=new datagridtextboxcolumn（);
dgcs3.mappingname= "type ";
dgcs3.headertext= "类型 ";
dgcs3.alignment=horizontalalignment.left;
dgts.gridcolumnstyles.add（dgcs3);
datagridcolumnstyle dgcs4=new datagridtextboxcolumn（);
dgcs4.mappingname= "price ";
dgcs4.headertext= "价格 ";
dgcs4.alignment=horizontalalignment.right;
dgts.gridcolumnstyles.add（dgcs4);
da.fill（dt);
this.grdtest.datasource=dt;
}
}
}
| | |
|
