C# Code
using System;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Data;
using System.Data.SqlClient;
namespace wang.lx
{
class HXGL_HXGL:Window
{
ListView lv;
dbHelper db = new dbHelper();
GridView gv;
GridViewColumn gvc;
public HXGL_HXGL()
{
Title = "橫向項目管理";
Grid grid = new Grid();
SizeToContent = SizeToContent.Height;
Width = 750;
grid.Margin = new Thickness(10);
Content = grid;
RowDefinition rd = new RowDefinition();
rd.Height = GridLength.Auto;
grid.RowDefinitions.Add(rd);
rd = new RowDefinition();
rd.Height = GridLength.Auto;
grid.RowDefinitions.Add(rd);
WrapPanel wrap = new WrapPanel();
Button btn1 = new Button();
btn1.Content = "增加";
btn1.Click += HXGL_btnOnClick;
btn1.Height = btn1.Width = 40;
wrap.Children.Add(btn1);
Button btn2 = new Button();
btn2.Height = btn2.Width = 40;
btn2.Content = "修改";
wrap.Children.Add(btn2);
Button btn3 = new Button();
btn3.Height = btn3.Width = 40;
btn3.Content = "刪除";
wrap.Children.Add(btn3);
grid.Children.Add(wrap);
ScrollViewer sv = new ScrollViewer();
sv.HorizontalScrollBarVisibility = ScrollBarVisibility.Auto;
sv.Height = this.Height - btn1.Height - 10;
grid.Children.Add(sv);
Grid.SetRow(sv, 1);
lv = new ListView();
sv.Content = lv;
Data_Init();
gv = new GridView();
gv.AllowsColumnReorder = true;
gv.ColumnHeaderToolTip = "橫向項目管理";
lv.View = gv;
//可以向如下方式添加,但相當(dāng)繁瑣,代碼重復(fù)次數(shù)超過兩次,最好寫成函數(shù)
//gvc = new GridViewColumn();
//gvc.DisplayMemberBinding = new Binding("name");
//gvc.Header = "項目名稱";
//gvc.Width = 100;
//gv.Columns.Add(gvc);
//gvc = new GridViewColumn();
//gvc.DisplayMemberBinding = new Binding("XMXH");
//gvc.Header = "項目序號";
//gvc.Width = 100;
//gv.Columns.Add(gvc);
//gvc = new GridViewColumn();
//gvc.DisplayMemberBinding = new Binding("fzr");
//gvc.Header = "負責(zé)人";
//gvc.Width = 100;
//gv.Columns.Add(gvc);
//gvc = new GridViewColumn();
//gvc.DisplayMemberBinding = new Binding("HTJF");
//gvc.Header = "合同經(jīng)費";
//gvc.Width = 100;
//gv.Columns.Add(gvc);
//gvc = new GridViewColumn();
//gvc.DisplayMemberBinding = new Binding("DKJE");
//gvc.Header = "到款金額";
//gvc.Width = 100;
//gv.Columns.Add(gvc);
//利用數(shù)組批量添加,注意,此處必須和讀取的字段大小寫保持一致,否則無法顯示
string[] bstr = {"Name","XMXH","FZR","HTJF","DKJE", "HTBH", "FZRYB", "SBJF", "DKSJ", "XMLB", "LXSJ", "QDRQ", "JTSJ", "WTDW", "YXQX", "XMJJ","XMWCQKJJ", "XMCJZ" };
string[] headstr = {"項目名稱","項目序號","負責(zé)人","合同經(jīng)費","到款金額", "合同編號", "負責(zé)人院別", "設(shè)備經(jīng)費", "到款時間", "項目類別", "立項時間", "簽訂日期", "結(jié)題時間", "委托單位", "有效期限", "項目簡介","項目完成情況簡介", "項目參加者"};
AddColumn(bstr, headstr);
}
//批量添加函數(shù)
protected void AddColumn(string[] bstr, string[] headstr)
{
for(int i=0;i<bstr.Length;i++)
{
gvc = new GridViewColumn();
gvc.DisplayMemberBinding = new Binding(bstr[i]);
gvc.Header = headstr[i];
//gvc.Width = 100;
gv.Columns