62,248
社区成员
发帖
与我相关
我的任务
分享如何在原有的DataSet.Tables[0]表中增加ID列？
肯定是个老问题，如何在原有的DataSet.Tables[0]表中增加ID列？ID从1到原有表的行数或记录数量，（用C#)谢谢！！！
...全文
请发表友善的回复…
发表回复
xrll 2003-01-21
- 打赏
- 举报
多谢WOLVE，稍后便试！！
wolve 2003-01-21
- 打赏
- 举报
sorry,the parameters are error!
again:
Col = dataset.tables(0).columns.Add("ID", System.Type.GetType("System.Decimal"))
again:
Col = dataset.tables(0).columns.Add("ID", System.Type.GetType("System.Decimal"))
wolve 2003-01-21
- 打赏
- 举报
Dim Col As DataColumn
Col = dataset.tables(0).columns.Add("ID", System.Type.GetType("System.Decimal"), _
"Price + Tax")
dim r as datarow
dim i as int=0
for each r in dataset.tables(0).rows
r.item("ID")=i
next
Col = dataset.tables(0).columns.Add("ID", System.Type.GetType("System.Decimal"), _
"Price + Tax")
dim r as datarow
dim i as int=0
for each r in dataset.tables(0).rows
r.item("ID")=i
next
xrll 2003-01-21
- 打赏
- 举报
我用的是dataset.readerxml()！谢谢
ZHANG9652 2003-01-21
- 打赏
- 举报
我建议您在sql语句中先创建好一列，给个初始数值，然后得到记录集后用循环进行赋值就是了
xrll 2003-01-21
- 打赏
- 举报
谢谢 WOLVE、阿俊、阿灰的提醒，我用以下方法解决了：
DataColumn myDataColumn= customerTable.Columns.Add("ID",System.Type.GetType("System.Decimal"));
int i=0;
foreach( DataRow row in customerTable.Rows )
{
row["id"]= i++;
}
DataColumn myDataColumn= customerTable.Columns.Add("ID",System.Type.GetType("System.Decimal"));
int i=0;
foreach( DataRow row in customerTable.Rows )
{
row["id"]= i++;
}
require 2003-01-21
- 打赏
- 举报
DataColumn Col;
Col=dataset.table(0).columns.Add("ID",System.Type.GetType
("System.decimal"),_"price + Tax")
datarow r;
int i;
foreach(r in dataset.tables(0).rows)
{
r.item("ID)=i;
}
Col=dataset.table(0).columns.Add("ID",System.Type.GetType
("System.decimal"),_"price + Tax")
datarow r;
int i;
foreach(r in dataset.tables(0).rows)
{
r.item("ID)=i;
}
xrll 2003-01-21
- 打赏
- 举报
能将以下代码改为c#吗？
Dim Col As DataColumn
Col = dataset.tables(0).columns.Add("ID", System.Type.GetType("System.Decimal"), _
"Price + Tax")
dim r as datarow
dim i as int=0
for each r in dataset.tables(0).rows
r.item("ID")=i
next
Dim Col As DataColumn
Col = dataset.tables(0).columns.Add("ID", System.Type.GetType("System.Decimal"), _
"Price + Tax")
dim r as datarow
dim i as int=0
for each r in dataset.tables(0).rows
r.item("ID")=i
next
ahui_net 2003-01-21
- 打赏
- 举报
BoundColumn NumberColumn = new BoundColumn();
NumberColumn.HeaderText = "ID";
NumberColumn.DataField="你的id";
NumberColumn.FooterText = {0};
ds.Columns.AddAt(0,NumberColumn);
ds.DataBind();
NumberColumn.HeaderText = "ID";
NumberColumn.DataField="你的id";
NumberColumn.FooterText = {0};
ds.Columns.AddAt(0,NumberColumn);
ds.DataBind();
ahui_net 2003-01-21
- 打赏
- 举报
BoundColumn NumberColumn = new BoundColumn();
NumberColumn.ItemStyle.Width = 10;
NumberColumn.HeaderText = jsSwep;
NumberColumn.ItemStyle.HorizontalAlign = HorizontalAlign.Center;
ds.Columns.AddAt(0,NumberColumn);
ds.DataBind();
NumberColumn.ItemStyle.Width = 10;
NumberColumn.HeaderText = jsSwep;
NumberColumn.ItemStyle.HorizontalAlign = HorizontalAlign.Center;
ds.Columns.AddAt(0,NumberColumn);
ds.DataBind();
xrll 2003-01-21
- 打赏
- 举报
有没有用c#编的代码？
一、对于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("英语");
}
}
}
