如何在原有的DataSet.Tables[0]表中增加ID列?

xrll 2003-01-21 09:25:05
肯定是个老问题,如何在原有的DataSet.Tables[0]表中增加ID列?ID从1到原有表的行数或记录数量,(用C#)谢谢!!!
...全文
85 11 打赏 收藏 转发到动态 举报
AI 作业
写回复
用AI写文章
11 条回复
切换为时间正序
请发表友善的回复…
发表回复
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"))
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
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++;
}
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;
}
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
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();
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();
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("英语"); } } }

62,248

社区成员

发帖
与我相关
我的任务
社区描述
.NET技术交流专区
javascript云原生 企业社区
社区管理员
  • ASP.NET
  • .Net开发者社区
  • R小R
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告

.NET 社区是一个围绕开源 .NET 的开放、热情、创新、包容的技术社区。社区致力于为广大 .NET 爱好者提供一个良好的知识共享、协同互助的 .NET 技术交流环境。我们尊重不同意见,支持健康理性的辩论和互动,反对歧视和攻击。

希望和大家一起共同营造一个活跃、友好的社区氛围。

试试用AI创作助手写篇文章吧