一、对于MyMulDataGridViewHeader的使用的一个简单的示例
1、数据表
use master
go
--创建数据库
if exists(select * from sys.sysdatabases where name='TestDB')
drop database TestDB
go
create database TestDB
on
(
name ='TestDB_data',
filename = 'E:\Data\TestDB_data.mdf',
size = 5mb,
maxsize = 20mb,
filegrowth = 10%
)
log on
(
name ='TestDB_log',
filename = 'E:\Data\TestDB_log.ldf',
size =3mb,
maxsize = 10mb,
filegrowth = 1mb
)
go
use TestDB
go
if exists(select * from sys.tables where name='UserInfo')
drop table UserInfo
go
create table UserInfo
(
id int primary key identity(1,1),
uname varchar(20) not null,
usex int not null,
uage int not null,
chineseremark int not null,
matchremark int not null,
englishremark int not null
)
go
insert into userinfo values('小谭',1,21,82,90,81)
insert into userinfo values('小花',0,21,83,90,82)
insert into userinfo values('小华',0,20,84,90,99)
insert into userinfo values('小方',0,20,85,92,85)
insert into userinfo values('小高',0,21,86,90,88)
insert into userinfo values('小宁',1,21,87,90,89)
insert into userinfo values('小江',1,21,88,90,92)
insert into userinfo values('小艳',0,20,89,90,93)
insert into userinfo values('小琼',0,21,92,98,95)
go
select * from userinfo
//后台调用
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
using MyDataGridMultiHeaderHelp;
namespace MyTest
{
public partial class Form3 : Form
{
public Form3()
{
InitializeComponent();
}
DataGridView dgv = new DataGridView();
private void Form3_Load(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection("Server=.;DataBase=TestDB;Uid=sa;Pwd=123456");
SqlCommand cmd = new SqlCommand("select * from userinfo", conn);
SqlDataAdapter sda = new SqlDataAdapter();
sda.SelectCommand = cmd;
DataSet ds = new DataSet();
sda.Fill(ds);
DataTable dt = ds.Tables[0];
//清除原有的控件
if (dgv != null && dgv.Name != "Mydgv")
{
panel1.Controls.RemoveByKey(dgv.Name);
dgv.Dispose();
dgv = null;
}
dgv = CreateDataGridView();
dgv.DataSource = dt;
this.panel1.Controls.Add(dgv);
}
private MyMulDataGridViewHeader CreateDataGridView()
{
MyMulDataGridViewHeader dgv = DataIntance.InstanceDataGridView();
DataIntance intance = new DataIntance(dgv);
TreeView mytv = new TreeView();//实例树。以树节点为多表头节点
intance.SetData(mytv.Nodes, "学员信息表");
intance.SetData(mytv.Nodes[0].Nodes, "ID编号");
intance.SetData(mytv.Nodes[0].Nodes, "姓名");
intance.SetData(mytv.Nodes[0].Nodes, "性别");
intance.SetData(mytv.Nodes[0].Nodes, "年龄");
intance.SetData(mytv.Nodes[0].Nodes, "成绩");
intance.SetData(mytv.Nodes[0].Nodes[4].Nodes, "语文");
intance.SetData(mytv.Nodes[0].Nodes[4].Nodes, "数学");
intance.SetData(mytv.Nodes[0].Nodes[4].Nodes, "英语");
intance.SetProperty("ID");
intance.SetProperty("uname");
intance.SetProperty("usex");
intance.SetProperty("uage");
intance.SetProperty("chineseremark");
intance.SetProperty("matchremark");
intance.SetProperty("englishremark");
dgv.ColumnTreeView = new TreeView[] { mytv };
dgv.ColumnDeep = 3;
return dgv;
}
}
}
二、GridView多表头的使用
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;
using MyDataGridMultiHeaderHelp;
namespace MyWeb
{
public partial class GridViewMulRow : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
GetMulData();
}
}
private void GetMulData()
{
SqlConnection conn = new SqlConnection("Server=.;DataBase=TestDB;Uid=sa;Pwd=123456");
SqlCommand cmd = new SqlCommand("select * from userinfo", conn);
SqlDataAdapter sda = new SqlDataAdapter();
sda.SelectCommand = cmd;
DataSet ds = new DataSet();
sda.Fill(ds);
DataTable dt = ds.Tables[0];
this.gvTest.DataSource = dt;
this.gvTest.DataBind();
TableCellCollection tcHeader = this.gvTest.HeaderRow.Cells;
tcHeader.Clear();
GridViewMulRowHeader gv = new GridViewMulRowHeader(tcHeader);
gv.InstanceTableCell("学员信息表</th></tr><tr>", "colspan", "7");
gv.InstanceTableCell("ID编号", "rowspan", "2");
gv.InstanceTableCell("姓名", "rowspan", "2");
gv.InstanceTableCell("性别", "rowspan", "2");
gv.InstanceTableCell("年龄", "rowspan", "2");
gv.InstanceTableCell("成绩</th></tr><tr>", "colspan", "3");
gv.InstanceTableCell("语文");
gv.InstanceTableCell("数学");
gv.InstanceTableCell("英语");
}
}
}
本文描述了一个关于使用帮助类返回数据库记录时遇到的问题，即返回的结果集为空的情况。通过检查和调试，最终发现是因为参数数组为空导致没有数据可以返回。
扫一扫
623
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
