Delete DataGrid row:
if
( e.Item.Cells[
1
].ForeColor
==
Color.Green )
{
if (Session[ " CreateWay " ].ToString() == " 1 " )
{
Session[ " ItemStatus " ] = " New " ;
Session[ " qtItemNo " ] = e.Item.Cells[ 1 ].Text.Trim();
DataSet ds = new DataSet();
ds = (DataSet)Session[ " ItemInfo " ];
for ( int i = 0 ;i < ds.Tables[ 0 ].Rows.Count;i ++ )
{
if (e.Item.Cells[ 1 ].Text.ToString() == ds.Tables[ 0 ].Rows[i][ 0 ].ToString())
{
DataRow dr = ds.Tables[ 0 ].Rows[i];
ds.Tables[ 0 ].Rows.Remove(dr);
}
}
setQTItemData();
}
}
{
if (Session[ " CreateWay " ].ToString() == " 1 " )
{
Session[ " ItemStatus " ] = " New " ;
Session[ " qtItemNo " ] = e.Item.Cells[ 1 ].Text.Trim();
DataSet ds = new DataSet();
ds = (DataSet)Session[ " ItemInfo " ];
for ( int i = 0 ;i < ds.Tables[ 0 ].Rows.Count;i ++ )
{
if (e.Item.Cells[ 1 ].Text.ToString() == ds.Tables[ 0 ].Rows[i][ 0 ].ToString())
{
DataRow dr = ds.Tables[ 0 ].Rows[i];
ds.Tables[ 0 ].Rows.Remove(dr);
}
}
setQTItemData();
}
}
Data load:
DataTable dt
=
new
DataTable();
dt.Columns.Add( new DataColumn( " item_No " , typeof ( string )));
dt.Columns.Add( new DataColumn( " shipto_No " , typeof ( string )));
dt.Columns.Add( new DataColumn( " status " , typeof ( string )));
dt.Columns.Add( new DataColumn( " MS_Code " , typeof ( string )));
dt.Columns.Add( new DataColumn( " catg_flg " , typeof ( string )));
dt.Columns.Add( new DataColumn( " srce_type " , typeof ( string )));
dt.Columns.Add( new DataColumn( " reserve_no " , typeof ( string )));
dt.Columns.Add( new DataColumn( " qty_order " , typeof ( string )));
dt.Columns.Add( new DataColumn( " sp_contr " , typeof ( string )));
dt.Columns.Add( new DataColumn( " sales_dept " , typeof ( string )));
dt.Columns.Add( new DataColumn( " prod_prep_dept " , typeof ( string )));
dt.Columns.Add( new DataColumn( " lead_time " , typeof ( string )));
dt.Columns.Add( new DataColumn( " date_sche_ship " , typeof ( string )));
DataSet itemList;
itemList = COService.listCoItemInfoOfShipment(companyID,costCenterID,cono,shipmentNo);
txt_PageNO.Text = Convert.ToString(dg_itemList.CurrentPageIndex + 1 );
txt_TotalNum.Text = Convert.ToString( dg_itemList.PageCount + 1 );
if (Session[ " HeadStatus " ].ToString() == " Query " )
{
dg_itemList.DataSource = itemList;
dg_itemList.DataBind();
txt_PageNO.Text = Convert.ToString(dg_itemList.CurrentPageIndex + 1 );
txt_TotalNum.Text = Convert.ToString( dg_itemList.PageCount );
}
else
{
if ( Session[ " CreateWay " ].ToString() == " 1 " )
{
DataSet ds = new DataSet();
ds = (DataSet)Session[ " ItemInfo " ];
for ( int i = 0 ; i < itemList.Tables[ 0 ].Rows.Count; i ++ )
{
DataRow dr = dt.NewRow();
dr[ " item_No " ] = itemList.Tables[ 0 ].Rows[i][ " item_no " ].ToString();
dr[ " shipto_No " ] = itemList.Tables[ 0 ].Rows[i][ " SHIPTO_NO " ].ToString();
dr[ " status " ] = itemList.Tables[ 0 ].Rows[i][ " STATUS " ].ToString();
dr[ " MS_Code " ] = itemList.Tables[ 0 ].Rows[i][ " MS_CODE " ].ToString();
dr[ " catg_flg " ] = itemList.Tables[ 0 ].Rows[i][ " CATG_FLG " ].ToString();
dr[ " srce_type " ] = itemList.Tables[ 0 ].Rows[i][ " srce_type " ].ToString();
dr[ " qty_order " ] = itemList.Tables[ 0 ].Rows[i][ " qty_order " ].ToString();
dr[ " sp_contr " ] = itemList.Tables[ 0 ].Rows[i][ " sp_contr " ].ToString();
dr[ " reserve_no " ] = itemList.Tables[ 0 ].Rows[i][ " reserve_no " ].ToString();
dr[ " sales_dept " ] = itemList.Tables[ 0 ].Rows[i][ " sales_dept " ].ToString();
dr[ " lead_time " ] = itemList.Tables[ 0 ].Rows[i][ " lead_time " ].ToString();
dt.Rows.Add(dr);
}
for ( int i = 0 ; i < ds.Tables[ 0 ].Rows.Count; i ++ )
{
DataRow dr = dt.NewRow();
dr[ " item_No " ] = ds.Tables[ 0 ].Rows[i][ " ItemNO " ].ToString();
dr[ " shipto_No " ] = ds.Tables[ 0 ].Rows[i][ " ShiptoNO " ].ToString();
dr[ " status " ] = ds.Tables[ 0 ].Rows[i][ " Status " ].ToString();
dr[ " MS_Code " ] = ds.Tables[ 0 ].Rows[i][ " MSCode " ].ToString();
dr[ " catg_flg " ] = ds.Tables[ 0 ].Rows[i][ " Catalog " ].ToString();
dr[ " srce_type " ] = ds.Tables[ 0 ].Rows[i][ " SourceType " ].ToString();
dr[ " qty_order " ] = ds.Tables[ 0 ].Rows[i][ " QTY " ].ToString();
dr[ " sp_contr " ] = ds.Tables[ 0 ].Rows[i][ " ListPrice " ].ToString();
dr[ " reserve_no " ] = ds.Tables[ 0 ].Rows[i][ " ReserveNO " ].ToString();
dr[ " sales_dept " ] = ds.Tables[ 0 ].Rows[i][ " SalesDepart " ].ToString();
dr[ " lead_time " ] = ds.Tables[ 0 ].Rows[i][ " LeadTime " ].ToString();
dt.Rows.Add(dr);
}
DataSet ds1 = new DataSet();
ds1.Tables.Add(dt);
dg_itemList.DataSource = ds1;
dg_itemList.DataBind();
for ( int i = 0 ; i < ds.Tables[ 0 ].Rows.Count; i ++ )
{
ChangeColor(dg_itemList,dg_itemList.Items.Count - i - 1 ,Color.Green);
}
}
dt.Columns.Add( new DataColumn( " item_No " , typeof ( string )));
dt.Columns.Add( new DataColumn( " shipto_No " , typeof ( string )));
dt.Columns.Add( new DataColumn( " status " , typeof ( string )));
dt.Columns.Add( new DataColumn( " MS_Code " , typeof ( string )));
dt.Columns.Add( new DataColumn( " catg_flg " , typeof ( string )));
dt.Columns.Add( new DataColumn( " srce_type " , typeof ( string )));
dt.Columns.Add( new DataColumn( " reserve_no " , typeof ( string )));
dt.Columns.Add( new DataColumn( " qty_order " , typeof ( string )));
dt.Columns.Add( new DataColumn( " sp_contr " , typeof ( string )));
dt.Columns.Add( new DataColumn( " sales_dept " , typeof ( string )));
dt.Columns.Add( new DataColumn( " prod_prep_dept " , typeof ( string )));
dt.Columns.Add( new DataColumn( " lead_time " , typeof ( string )));
dt.Columns.Add( new DataColumn( " date_sche_ship " , typeof ( string )));
DataSet itemList;
itemList = COService.listCoItemInfoOfShipment(companyID,costCenterID,cono,shipmentNo);
txt_PageNO.Text = Convert.ToString(dg_itemList.CurrentPageIndex + 1 );
txt_TotalNum.Text = Convert.ToString( dg_itemList.PageCount + 1 );
if (Session[ " HeadStatus " ].ToString() == " Query " )
{
dg_itemList.DataSource = itemList;
dg_itemList.DataBind();
txt_PageNO.Text = Convert.ToString(dg_itemList.CurrentPageIndex + 1 );
txt_TotalNum.Text = Convert.ToString( dg_itemList.PageCount );
}
else
{
if ( Session[ " CreateWay " ].ToString() == " 1 " )
{
DataSet ds = new DataSet();
ds = (DataSet)Session[ " ItemInfo " ];
for ( int i = 0 ; i < itemList.Tables[ 0 ].Rows.Count; i ++ )
{
DataRow dr = dt.NewRow();
dr[ " item_No " ] = itemList.Tables[ 0 ].Rows[i][ " item_no " ].ToString();
dr[ " shipto_No " ] = itemList.Tables[ 0 ].Rows[i][ " SHIPTO_NO " ].ToString();
dr[ " status " ] = itemList.Tables[ 0 ].Rows[i][ " STATUS " ].ToString();
dr[ " MS_Code " ] = itemList.Tables[ 0 ].Rows[i][ " MS_CODE " ].ToString();
dr[ " catg_flg " ] = itemList.Tables[ 0 ].Rows[i][ " CATG_FLG " ].ToString();
dr[ " srce_type " ] = itemList.Tables[ 0 ].Rows[i][ " srce_type " ].ToString();
dr[ " qty_order " ] = itemList.Tables[ 0 ].Rows[i][ " qty_order " ].ToString();
dr[ " sp_contr " ] = itemList.Tables[ 0 ].Rows[i][ " sp_contr " ].ToString();
dr[ " reserve_no " ] = itemList.Tables[ 0 ].Rows[i][ " reserve_no " ].ToString();
dr[ " sales_dept " ] = itemList.Tables[ 0 ].Rows[i][ " sales_dept " ].ToString();
dr[ " lead_time " ] = itemList.Tables[ 0 ].Rows[i][ " lead_time " ].ToString();
dt.Rows.Add(dr);
}
for ( int i = 0 ; i < ds.Tables[ 0 ].Rows.Count; i ++ )
{
DataRow dr = dt.NewRow();
dr[ " item_No " ] = ds.Tables[ 0 ].Rows[i][ " ItemNO " ].ToString();
dr[ " shipto_No " ] = ds.Tables[ 0 ].Rows[i][ " ShiptoNO " ].ToString();
dr[ " status " ] = ds.Tables[ 0 ].Rows[i][ " Status " ].ToString();
dr[ " MS_Code " ] = ds.Tables[ 0 ].Rows[i][ " MSCode " ].ToString();
dr[ " catg_flg " ] = ds.Tables[ 0 ].Rows[i][ " Catalog " ].ToString();
dr[ " srce_type " ] = ds.Tables[ 0 ].Rows[i][ " SourceType " ].ToString();
dr[ " qty_order " ] = ds.Tables[ 0 ].Rows[i][ " QTY " ].ToString();
dr[ " sp_contr " ] = ds.Tables[ 0 ].Rows[i][ " ListPrice " ].ToString();
dr[ " reserve_no " ] = ds.Tables[ 0 ].Rows[i][ " ReserveNO " ].ToString();
dr[ " sales_dept " ] = ds.Tables[ 0 ].Rows[i][ " SalesDepart " ].ToString();
dr[ " lead_time " ] = ds.Tables[ 0 ].Rows[i][ " LeadTime " ].ToString();
dt.Rows.Add(dr);
}
DataSet ds1 = new DataSet();
ds1.Tables.Add(dt);
dg_itemList.DataSource = ds1;
dg_itemList.DataBind();
for ( int i = 0 ; i < ds.Tables[ 0 ].Rows.Count; i ++ )
{
ChangeColor(dg_itemList,dg_itemList.Items.Count - i - 1 ,Color.Green);
}
}
Change DataGrid row color:
public
void
ChangeColor(DataGrid dg,
int
index,Color cl)
{
for ( int i = 0 ;i < dg.Columns.Count;i ++ )
{
dg.Items[index].Cells[i].ForeColor = cl;
}
}
{
for ( int i = 0 ;i < dg.Columns.Count;i ++ )
{
dg.Items[index].Cells[i].ForeColor = cl;
}
}