110,571
社区成员
发帖
与我相关
我的任务
分享如何将DGV中的int转化成枚举***寻求解决方案
在将 数据 保存到 数据库 之前，我将枚举值转成了 int 类型，在数据库中保存的int类型的数据。
在做查询的时候，我的大致做法如下：
1、将数据表的数据Fill 到 DateSet
2、将DateSet 绑定到 DataGridView 中.
因此，用户看到的枚举数据都是 0、1 之类的，我现在想将int 转换成 枚举值.ToString(),然后显示到DataGridView 中，
因为数据量比较大 FOREACH 遍历 DateSet 效率有点低。
请问各位大侠有没有好的方式???
大侠们 帮帮忙
小弟第一次发帖，求助 所给分数如果有不合理之处望海涵!
...全文
请发表友善的回复…
发表回复
让爱延续 2010-07-31
- 打赏
- 举报
[Quote=引用 1 楼 wuyq11 的回复:]
void DataGridView1_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
if(this.dataGridView1.Columns[e.ColumnIndex].Name == "")
{
e……
[/Quote]
恩 谢谢啦…
void DataGridView1_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
if(this.dataGridView1.Columns[e.ColumnIndex].Name == "")
{
e……
[/Quote]
恩 谢谢啦…
wuyq11 2010-07-31
- 打赏
- 举报
void DataGridView1_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
if(this.dataGridView1.Columns[e.ColumnIndex].Name == "")
{
e.Value = Enum.GetName(typeof(类型), int.Parse(类型));Convert.ToInt16(e.Value));}
}
{
if(this.dataGridView1.Columns[e.ColumnIndex].Name == "")
{
e.Value = Enum.GetName(typeof(类型), int.Parse(类型));Convert.ToInt16(e.Value));}
}
一、对于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("学员信息表", "colspan", "7");
gv.InstanceTableCell("ID编号", "rowspan", "2");
gv.InstanceTableCell("姓名", "rowspan", "2");
gv.InstanceTableCell("性别", "rowspan", "2");
gv.InstanceTableCell("年龄", "rowspan", "2");
gv.InstanceTableCell("成绩 ", "colspan", "3");
gv.InstanceTableCell("语文");
gv.InstanceTableCell("数学");
gv.InstanceTableCell("英语");
}
}
}
