T
toytoto
ok here's the code and bellow i explain the problem
// Create new data view
DataView BottomDataView = new DataView();
// Give dataview the datatable
BottomDataView.Table = myBottomDT;
DataTable myNewBottomDT = new DataTable("myNewBottomDT1");
DataRow myNewBottomDR;
#region Table Columns
// Define the columns of the table.
for (int i = 0; i < BottomDataView.Table.Columns.Count; i++)
{
switch (BottomDataView.Table.Columns.ColumnName.ToString())
{
case "id_futures":
myNewBottomDT.Columns.Add("Futures");
break;
case "id_planner":
myNewBottomDT.Columns.Add("Responsible");
break;
case "cd_commodity":
myNewBottomDT.Columns.Add("Commodity<BR>Service");
break;
case "tx_desc":
myNewBottomDT.Columns.Add("Description");
break;
case "qy_leadtime":
myNewBottomDT.Columns.Add("Lead Time");
break;
case "dt_planning_def":
myNewBottomDT.Columns.Add("Need Date");
break;
case "fl_memo":
myNewBottomDT.Columns.Add("Memo Only");
break;
case "qy_hrs_est":
myNewBottomDT.Columns.Add("Man Hrs Est");
break;
case "qy_hrs_act":
myNewBottomDT.Columns.Add("Man Hrs Act");
break;
case "cd_cmmt":
myNewBottomDT.Columns.Add("Type");
break;
case "id_cmmt":
myNewBottomDT.Columns.Add("Document #");
break;
case "id_vendor_no":
myNewBottomDT.Columns.Add("Vendor");
break;
case "id_po":
myNewBottomDT.Columns.Add("PO #");
break;
default:
myNewBottomDT.Columns.Add(BottomDataView.Table.Columns.ColumnName.ToString());
break;
}
}
myNewBottomDT.Columns.Add("Remove");
#endregion
#region Table Rows
foreach (DataRowView myDRV in BottomDataView)
{
myNewBottomDR = myNewBottomDT.NewRow();
for (int i = 0; i < BottomDataView.Table.Columns.Count; i++)
{
switch (BottomDataView.Table.Columns.ColumnName.ToString())
{
case "fl_memo":
if ( myDRV.ToString() == "1" )
{
myNewBottomDR = "Yes";
}
else
{
myNewBottomDR = "No";
}
break;
default:
myNewBottomDR = myDRV;
break;
}
}
myNewBottomDT.Rows.Add(myNewBottomDR);
}
#endregion
int temp = myNewBottomDT.Rows.Count;
int nextFutureId = Convert.ToInt32(
myNewBottomDT.Rows[temp-1]["Futures"].ToString() ) + 1 ;
//there is a problem here not sure y
myNewBottomDR = myNewBottomDT.NewRow();
myNewBottomDT.Rows.Add(myNewBottomDR);
DataView myNewBottomDV = new DataView(myNewBottomDT);
DGPlanningStatusBottom.DataSource = myNewBottomDV;
DGPlanningStatusBottom.DataBind();
if i DON'T include the blank row all postback's are working fine all
event's are triggered, but when i had the blank row before binding the
DT/DV to the datagrid i receive the following error and NO EVENT's are
triggered at all
// Create new data view
DataView BottomDataView = new DataView();
// Give dataview the datatable
BottomDataView.Table = myBottomDT;
DataTable myNewBottomDT = new DataTable("myNewBottomDT1");
DataRow myNewBottomDR;
#region Table Columns
// Define the columns of the table.
for (int i = 0; i < BottomDataView.Table.Columns.Count; i++)
{
switch (BottomDataView.Table.Columns.ColumnName.ToString())
{
case "id_futures":
myNewBottomDT.Columns.Add("Futures");
break;
case "id_planner":
myNewBottomDT.Columns.Add("Responsible");
break;
case "cd_commodity":
myNewBottomDT.Columns.Add("Commodity<BR>Service");
break;
case "tx_desc":
myNewBottomDT.Columns.Add("Description");
break;
case "qy_leadtime":
myNewBottomDT.Columns.Add("Lead Time");
break;
case "dt_planning_def":
myNewBottomDT.Columns.Add("Need Date");
break;
case "fl_memo":
myNewBottomDT.Columns.Add("Memo Only");
break;
case "qy_hrs_est":
myNewBottomDT.Columns.Add("Man Hrs Est");
break;
case "qy_hrs_act":
myNewBottomDT.Columns.Add("Man Hrs Act");
break;
case "cd_cmmt":
myNewBottomDT.Columns.Add("Type");
break;
case "id_cmmt":
myNewBottomDT.Columns.Add("Document #");
break;
case "id_vendor_no":
myNewBottomDT.Columns.Add("Vendor");
break;
case "id_po":
myNewBottomDT.Columns.Add("PO #");
break;
default:
myNewBottomDT.Columns.Add(BottomDataView.Table.Columns.ColumnName.ToString());
break;
}
}
myNewBottomDT.Columns.Add("Remove");
#endregion
#region Table Rows
foreach (DataRowView myDRV in BottomDataView)
{
myNewBottomDR = myNewBottomDT.NewRow();
for (int i = 0; i < BottomDataView.Table.Columns.Count; i++)
{
switch (BottomDataView.Table.Columns.ColumnName.ToString())
{
case "fl_memo":
if ( myDRV.ToString() == "1" )
{
myNewBottomDR = "Yes";
}
else
{
myNewBottomDR = "No";
}
break;
default:
myNewBottomDR = myDRV;
break;
}
}
myNewBottomDT.Rows.Add(myNewBottomDR);
}
#endregion
int temp = myNewBottomDT.Rows.Count;
int nextFutureId = Convert.ToInt32(
myNewBottomDT.Rows[temp-1]["Futures"].ToString() ) + 1 ;
//there is a problem here not sure y
myNewBottomDR = myNewBottomDT.NewRow();
myNewBottomDT.Rows.Add(myNewBottomDR);
DataView myNewBottomDV = new DataView(myNewBottomDT);
DGPlanningStatusBottom.DataSource = myNewBottomDV;
DGPlanningStatusBottom.DataBind();
if i DON'T include the blank row all postback's are working fine all
event's are triggered, but when i had the blank row before binding the
DT/DV to the datagrid i receive the following error and NO EVENT's are
triggered at all