无法将行转换为 C# 中的 DataTable

Question

我正在尝试将 DataRow 转换为 DataTable，但出现错误。我搜索并尝试了所有可能的解决方案，但没有一个有效！

我有一个方法接受 DataTable 作为其参数（此 DataTable 恰好有一行）。该方法将返回一些信息。

起初，我尝试使用 ImportRow(newtable.ImportRow(row)) 将 DataRow 转换为 DataTable，但是 newtable< /code> 之后为空。然后，我尝试了 dt.clone()，但这会用所有内容填充 newtable，这不是我想要的！实际上这正是我所追求的。

private static void BatchFrontSidePrinting(Student St, frmBaseCard frm)
{
    DBINFOPACK UserInfo;
    DBCARDINFO CardInfo;
    DataTable newtable = new DataTable("newtable");

    foreach (DataRow row in dt.Rows)
    {
        try
        {

            // here, I'm trying to send one DataRow as a DataTable to the GetInfo() method,
            // and for the next iteratio , after getting the info I'm removing the row which was just added,
            // so that for the next iteration, newdatatable is empty.  All of the proceeding actions fail !:( 

            newtable.ImportRow(row); // doesn't work! 

            UserInfo = GetInfo(newtable);

            newtable.Rows.Remove(row); // doesn't work! 

            St = UserInfo.STUDENT;

            ((frmFrontSideCard)frm).Replica = UserInfo.CARDINFO.Replica;

            if (UserInfo.CARDINFO.Replica)
            {
                Loger.Items.Add("Replication !");
            }

            // print
            ((frmFrontSideCard)frm).Print = St;

            // update
            CardInfo = UserInfo.CARDINFO;
            CardInfo.SID = UserInfo.STUDENT.ID;
            CardInfo.BIMAGE = UserInfo.BIMAGE;
            SetInfo(CardInfo);
        }
        catch (Exception exep)
        {
            Loger.Items.Add(String.Format("Inside [BatchFrontSidePrinting()] : Student {0} {1}:", St.ID, exep.Message));
        }
    }
}

Answer 1

foreach (DataRow row in dt.Rows)
{
    try
    {
        DataTable newtable = new DataTable();
        newtable = dt.Clone(); // Use Clone method to copy the table structure (Schema).
        newtable.ImportRow(row); // Use the ImportRow method to copy from dt table to its clone.
        UserInfo = GetInfo(newtable);

    catch (Exception exep)
    {
        //
    }
}

Answer 2

var someRow = newTable.NewRow();
someRow[0] = row[0]; // etc
newTable.Rows.Add(someRow);

Answer 3

看起来您正在使用 newtable 作为临时容器，将 dt 中的每一行发送到 GetInfo 方法。如果是这样，为什么不更改 GetInfo 方法以获取 DataRow 而不是包含单个 DataRow 的 DataTable ？然后，您可以摆脱 newtable 而不必费心创建和复制 DataRow。

private static void BatchFrontSidePrinting(Student St, frmBaseCard frm) 
{ 
    DBINFOPACK UserInfo ; 
    DBCARDINFO CardInfo; 

    foreach (DataRow row in dt.Rows) 
    { 
        try 
        {       
            // just pass the row
            UserInfo = GetInfo(row); 

            // rest of the code as before
            St = UserInfo.STUDENT; 
            ((frmFrontSideCard)frm).Replica = UserInfo.CARDINFO.Replica; 
            if (UserInfo.CARDINFO.Replica) 
            { 
                Loger.Items.Add("Replication !"); 
            } 
            //print 
            ((frmFrontSideCard)frm).Print = St; 
            //update 
            CardInfo = UserInfo.CARDINFO; 
            CardInfo.SID = UserInfo.STUDENT.ID; 
            CardInfo.BIMAGE = UserInfo.BIMAGE; 
            SetInfo(CardInfo); 
        } 
        catch (Exception exep) 
        { 
            Loger.Items.Add(String.Format("Inside [BatchFrontSidePrinting()] : Student {0} {1}:", St.ID, exep.Message)); 
        }