请教一个DataTable的问题 就是在一个组件了把数据存在一个DataTable 然后用户可以读取这个的dataTable的值可以向DataTAble 添加数据大哥们!要怎么做才可以实现啊? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 foreach(DataRow dr in DataTable.Rows){ 控件= dr["字段名"].toString(); 。} 谢谢大哥我是想问如何在组件里定义那个datatable才可以在我组件上点击按钮增加了数据后让其他组件读取数据? DataTable NewDT=new DataTable(); NewDT.TableName="TempTable"; //new DataTable //add Columns string thisTableName = FatherTable.TableName.Replace("[","").Replace("]",""); for (int i=0;i<FatherTable.Columns.Count;i++) { string thisColumnsName=FatherTable.Columns[i].ToString(); System.Type thisType= FatherTable.Columns[i].GetType(); DataColumn NewColumn = new DataColumn(thisTableName+"."+thisColumnsName,thisType); NewColumn.MaxLength = FatherTable.Columns[i].MaxLength; NewDT.Columns.Add(NewColumn); } thisTableName = ChildTable.TableName.Replace("[","").Replace("]",""); for (int i=0;i<ChildTable.Columns.Count;i++) { string thisColumnsName=ChildTable.Columns[i].ToString(); System.Type thisType= ChildTable.Columns[i].GetType(); DataColumn NewColumn = new DataColumn(thisTableName+"."+thisColumnsName,thisType); NewDT.Columns.Add(NewColumn); } //add Rows int getColumnsCount = NewDT.Columns.Count; int getFatherColumnsCount = FatherTable.Columns.Count; if (ChildTable.Rows.Count == 0) { for (int i=0;i<FatherTable.Rows.Count;i++) { DataRow NewRow = NewDT.NewRow(); for (int m=0;m<getColumnsCount;m++) { if (m < getFatherColumnsCount) { NewRow[m] = FatherTable.Rows[i][m]; } } NewDT.Rows.Add(NewRow); } } else if (FatherTable.Rows.Count == 0) { for (int k=0;k<ChildTable.Rows.Count;k++) { DataRow NewRow = NewDT.NewRow(); for (int m=getFatherColumnsCount; m < getColumnsCount; m++) { NewRow[m] = ChildTable.Rows[k][m-getFatherColumnsCount]; } NewDT.Rows.Add(NewRow); } } else { for (int i=0;i<FatherTable.Rows.Count;i++) { for (int k=0;k<ChildTable.Rows.Count;k++) { DataRow NewRow = NewDT.NewRow(); for (int m=0;m<getColumnsCount;m++) { if (m<getFatherColumnsCount) { NewRow[m] = FatherTable.Rows[i][m]; } else { NewRow[m] = ChildTable.Rows[k][m-getFatherColumnsCount]; } } NewDT.Rows.Add(NewRow); } } } //Add Relations Relations=Relations.Trim().Replace("[","").Replace("]",""); DataRow[] SeclectRows=NewDT.Select(Relations); fcTable=NewDT.Clone(); fcTable.TableName=NewDataTableName.Trim(); foreach (DataRow row in SeclectRows) { fcTable.Rows.Add(row.ItemArray); } // } return fcTable; } 关于对象的事件问题 一个数据解密的问题 怎样选择微软tts中人物发音 关于委托使用得问题 请问activereport中label的文字对齐属性,我将其设置为justify,就是两端对齐为何没用阿? 关于如何返回一个IDataReader呢? 怎样编程修改USB转UART的虚拟端口号? 十万火急的问题!!asp 调用 C#写的Com组件问题,愿以二百分相送 今天装了vs.net final,觉得挺心灰意冷的 做excel插件开发,在ms-office上做的插件可以直接用于wps的吗 我应该怎样改代码才能使文章段和段之间排版正常啊? 请问double型的数据值范围对小数位数有限制吗?
foreach(DataRow dr in DataTable.Rows)
{
控件= dr["字段名"].toString();
。
}
才可以在我组件上点击按钮增加了数据后让其他组件读取数据?
NewDT.TableName="TempTable";
//new DataTable
//add Columns
string thisTableName = FatherTable.TableName.Replace("[","").Replace("]","");
for (int i=0;i<FatherTable.Columns.Count;i++)
{
string thisColumnsName=FatherTable.Columns[i].ToString();
System.Type thisType= FatherTable.Columns[i].GetType();
DataColumn NewColumn = new DataColumn(thisTableName+"."+thisColumnsName,thisType);
NewColumn.MaxLength = FatherTable.Columns[i].MaxLength;
NewDT.Columns.Add(NewColumn);
}
thisTableName = ChildTable.TableName.Replace("[","").Replace("]","");
for (int i=0;i<ChildTable.Columns.Count;i++)
{
string thisColumnsName=ChildTable.Columns[i].ToString();
System.Type thisType= ChildTable.Columns[i].GetType();
DataColumn NewColumn = new DataColumn(thisTableName+"."+thisColumnsName,thisType);
NewDT.Columns.Add(NewColumn);
}
//add Rows
int getColumnsCount = NewDT.Columns.Count;
int getFatherColumnsCount = FatherTable.Columns.Count;
if (ChildTable.Rows.Count == 0)
{
for (int i=0;i<FatherTable.Rows.Count;i++)
{
DataRow NewRow = NewDT.NewRow();
for (int m=0;m<getColumnsCount;m++)
{
if (m < getFatherColumnsCount)
{
NewRow[m] = FatherTable.Rows[i][m];
}
}
NewDT.Rows.Add(NewRow);
}
}
else if (FatherTable.Rows.Count == 0)
{
for (int k=0;k<ChildTable.Rows.Count;k++)
{
DataRow NewRow = NewDT.NewRow();
for (int m=getFatherColumnsCount; m < getColumnsCount; m++)
{
NewRow[m] = ChildTable.Rows[k][m-getFatherColumnsCount];
}
NewDT.Rows.Add(NewRow);
}
}
else
{
for (int i=0;i<FatherTable.Rows.Count;i++)
{
for (int k=0;k<ChildTable.Rows.Count;k++)
{
DataRow NewRow = NewDT.NewRow();
for (int m=0;m<getColumnsCount;m++)
{
if (m<getFatherColumnsCount)
{
NewRow[m] = FatherTable.Rows[i][m];
}
else
{
NewRow[m] = ChildTable.Rows[k][m-getFatherColumnsCount];
}
}
NewDT.Rows.Add(NewRow);
}
}
}
//Add Relations
Relations=Relations.Trim().Replace("[","").Replace("]","");
DataRow[] SeclectRows=NewDT.Select(Relations);
fcTable=NewDT.Clone();
fcTable.TableName=NewDataTableName.Trim();
foreach (DataRow row in SeclectRows)
{
fcTable.Rows.Add(row.ItemArray);
}
// }
return fcTable;
}