public void FileDataTable(int PageSize)
{
//循环加入行数为PageSize的行
for (int i = 0; i < PageSize; i++)
{
DataRow newrow;
if (mydatareader.Read())
{
//如果有记录,则把这条数据加入到datatable中
//循环把列中的信息加入到新行中
for (int j = 0; j < mydatareader.FieldCount; j++)
{
newrow = mydatatable.NewRow();
newrow[j] = mydatareader[j].ToString();
}
mydatatable.Rows.Add(newrow);
}
else
{
//如果没有,则跳出循环
break;
}
}
}
我已经写出了一些但是系统提示说不对
说mydatatable.Rows.Add(newrow);这行的newrow是使用了未赋值的局部变量
谢谢
{
//循环加入行数为PageSize的行
for (int i = 0; i < PageSize; i++)
{
DataRow newrow;
if (mydatareader.Read())
{
//如果有记录,则把这条数据加入到datatable中
//循环把列中的信息加入到新行中
for (int j = 0; j < mydatareader.FieldCount; j++)
{
newrow = mydatatable.NewRow();
newrow[j] = mydatareader[j].ToString();
}
mydatatable.Rows.Add(newrow);
}
else
{
//如果没有,则跳出循环
break;
}
}
}
我已经写出了一些但是系统提示说不对
说mydatatable.Rows.Add(newrow);这行的newrow是使用了未赋值的局部变量
谢谢
解决方案 »
- 【急,斑竹帮偶,偶快崩溃了!】win2003服务器上生成excel 后下载 报:拒绝访问
- DateTable.Select(sql)sql条件中有日期字段的条件怎么写?
- 域名神奇的变成了机器名
- 如何把这段html代码弄成C#的字符形?
- 在一个弹出窗口里面有一个保存按钮,我怎么样让它点了保存后,执行完保存的代码后,然后关闭这个弹出的窗口?
- C#下之asp.net中将真彩图转256色图的问题
- 在后台如何启动oracle中的一个job?
- 祸不单行,ASP.NET不能连接到IIS了!
- 谁有javascript日历呀!
- 关于网站后台定时执行任务
- 关于usercontrol控件的一个问题 谢谢
- 如何给自定义控件自定义属性?
{
//循环加入行数为PageSize的行
for (int i = 0; i < PageSize; i++)
{
DataRow newrow;
if (mydatareader.Read())
{
//如果有记录,则把这条数据加入到datatable中
//循环把列中的信息加入到新行中
for (int j = 0; j < mydatareader.FieldCount; j++)
{
newrow = mydatatable.NewRow();
newrow[j] = mydatareader[j].ToString();
mydatatable.Rows.Add(newrow);
}
}
else
{
//如果没有,则跳出循环
break;
}
}
}
Private Sub CreateNewDataRow()
' Use the MakeTable function below to create a new table.
Dim myTable As DataTable
myTable = MakeNamesTable()
' Once a table has been created, use the NewRow to create a DataRow.
Dim myRow As DataRow
myRow = myTable.NewRow()
' Then add the new row to the collection.
myRow("fName") = "John"
myRow("lName") = "Smith"
myTable.Rows.Add(myRow)
Dim dc As DataColumn
For Each dc in myTable.Columns
Console.WriteLine(dc.ColumnName)
Next
DataGrid1.DataSource=myTable
End Sub
Private Function MakeNamesTable() As DataTable
' Create a new DataTable titled 'Names.'
Dim namesTable As DataTable = new DataTable("Names")
' Add three column objects to the table.
Dim idColumn As DataColumn = new DataColumn()
idColumn.DataType = System.Type.GetType("System.Int32")
idColumn.ColumnName = "id"
idColumn.AutoIncrement = True
namesTable.Columns.Add(idColumn)
Dim fNameColumn As DataColumn = New DataColumn()
fNameColumn.DataType = System.Type.GetType("System.String")
fNameColumn.ColumnName = "Fname"
fNameColumn.DefaultValue = "Fname"
namesTable.Columns.Add(fNameColumn)
Dim lNameColumn As DataColumn = new DataColumn()
lNameColumn.DataType = System.Type.GetType("System.String")
lNameColumn.ColumnName = "LName"
namesTable.Columns.Add(lNameColumn)
' Create an array for DataColumn objects.
Dim keys(0) As DataColumn
keys(0) = idColumn
namesTable.PrimaryKey = keys
' Return the new DataTable.
MakeNamesTable = namesTable
End Function[C#]
private void CreateNewDataRow(){
// Use the MakeTable function below to create a new table.
DataTable myTable;
myTable = MakeNamesTable();
// Once a table has been created, use the NewRow to create a DataRow.
DataRow myRow;
myRow = myTable.NewRow();
// Then add the new row to the collection.
myRow["fName"] = "John";
myRow["lName"] = "Smith";
myTable.Rows.Add(myRow);
foreach(DataColumn dc in myTable.Columns)
Console.WriteLine(dc.ColumnName);
dataGrid1.DataSource=myTable;
}
private DataTable MakeNamesTable(){
// Create a new DataTable titled 'Names.'
DataTable namesTable = new DataTable("Names");
// Add three column objects to the table.
DataColumn idColumn = new DataColumn();
idColumn.DataType = System.Type.GetType("System.Int32");
idColumn.ColumnName = "id";
idColumn.AutoIncrement = true;
namesTable.Columns.Add(idColumn);
DataColumn fNameColumn = new DataColumn();
fNameColumn.DataType = System.Type.GetType("System.String");
fNameColumn.ColumnName = "Fname";
fNameColumn.DefaultValue = "Fname";
namesTable.Columns.Add(fNameColumn);
DataColumn lNameColumn = new DataColumn();
lNameColumn.DataType = System.Type.GetType("System.String");
lNameColumn.ColumnName = "LName";
namesTable.Columns.Add(lNameColumn);
// Create an array for DataColumn objects.
DataColumn [] keys = new DataColumn [1];
keys[0] = idColumn;
namesTable.PrimaryKey = keys;
// Return the new DataTable.
return namesTable;
}
while(mydatareader.Read())
{
DataRow newrow;
if (mydatareader.Read())
{
//如果有记录,则把这条数据加入到datatable中
//循环把列中的信息加入到新行中
for (int j = 0; j < mydatareader.FieldCount; j++)
{
newrow = mydatatable.NewRow();
newrow[j] = mydatareader[j].ToString();
}
mydatatable.Rows.Add(newrow);
}
}