Coumn batchid不属于table table1 [英] Coumn batchid does not belong to table table1

问题描述

页面加载代码如下

 PkgDates.Columns.Add（  Cmn_minor_code， typeof （ string ））; 
 PkgDates.Columns.Add（  BatchID， typeof （ string ））; 
 PkgDates.Columns.Add（  Disp_Course， typeof （ string ））; 
 PkgDates.Columns.Add（  Start_date， typeof运算（DateTime的））; 
 PkgDates.Columns.Add（  End_date， typeof运算（DateTime的））; 
 PkgRows = PkgDates.NewRow（）; 
 
  if （ this  .DdlPKGCode.Text！=  ）
 {
  return  ; 
} 
 ViewState [  table] = PkgDates; 

我有一个提交按钮。提交按钮代码如下

 PkgRows = PkgDates.NewRow（）; 
 PkgRows [  Cmn_minor_code] =  this  .DDLPKGMinorCode.Text.ToString（）TrimEnd（）; 
 PkgRows [  BatchID] =  this  .LstPKGCrsDate.SelectedValue.ToString（）TrimEnd（）; 
 
 PkgRows [  Start_date] = Dt_Batches.Rows [LstPKGCrsDate.SelectedIndex ] [ 2 ]; 
 PkgRows [  End_date] = Dt_Batches.Rows [LstPKGCrsDate.SelectedIndex] [ 3 ]; 
 PkgRows [  Disp_Course] =  this  .DDLPKGMinorCode.Text.ToString（）+    -  + StrDate; 
 
  this  .PkgDates.Rows.Add（PkgRows）; 
 ViewState [  table] = PkgDates; 
 
 ViewState [  AdCrsCount] = PkgDates.Rows.Count; 
 

当我运行并点击提交按钮时显示错误如下

列'  BatchID'不属于表表1。

请帮我从上面做出的错误是什么。

解决方案

在将所有列添加到所有数据表之后，请尝试添加以下行以提交列添加。

PkgDates.AcceptChanges（）;

Page load code as follows

PkgDates.Columns.Add("Cmn_minor_code", typeof(string));
            PkgDates.Columns.Add("BatchID", typeof(string));
            PkgDates.Columns.Add("Disp_Course", typeof(string));
            PkgDates.Columns.Add("Start_date", typeof(DateTime));
            PkgDates.Columns.Add("End_date", typeof(DateTime));
            PkgRows = PkgDates.NewRow();

            if (this.DdlPKGCode.Text != "")
            {
                return;
            }
            ViewState["table"] = PkgDates;

I have one submit button.Submit button code as follows

PkgRows = PkgDates.NewRow();
       PkgRows["Cmn_minor_code"] = this.DDLPKGMinorCode.Text.ToString().TrimEnd();
       PkgRows["BatchID"] = this.LstPKGCrsDate.SelectedValue.ToString().TrimEnd();

      PkgRows["Start_date"] = Dt_Batches.Rows[LstPKGCrsDate.SelectedIndex][2];
      PkgRows["End_date"] = Dt_Batches.Rows[LstPKGCrsDate.SelectedIndex][3];
  PkgRows["Disp_Course"] = this.DDLPKGMinorCode.Text.ToString() + " - " + StrDate;

       this.PkgDates.Rows.Add(PkgRows);
       ViewState["table"] = PkgDates;

       ViewState["AdCrsCount"] = PkgDates.Rows.Count;

When i run and click the submit button shows error as follows

Column 'BatchID' does not belong to table Table1.

please help me from my above what is the mistake i made.

解决方案

Please try adding below line to commit your column addding after adding all column to all your datatable.

PkgDates.AcceptChanges();

这篇关于Coumn batchid不属于table table1的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！