ASP.NET

public static DataRow Process(DataRow source0, DataRow source1, List<ProcessItemHandler> handlers)          
{
   DataRow target = source0.Table.NewRow();
   foreach (DataColumn column in source0.Table.Columns)
  {
      int n = column.Ordinal;
      ProcessItemHandler handler = handlers[n];
…

protected void Page_Load(object sender, EventArgs e)

{

if (Session["Cart"] == null)

{

get_data();

Session["Cart"] = dt;

}

else

{

dt = (DataTable)Session["Cart"];

get_data();

// Session["Cart"] = Session["Cart"] + dt;


}

}

public void get_data()

{

dt = new DataTable();

dt.Columns.Add("REF", typeof(string));

dt.Columns.Add("Description", typeof(string));

dt.Columns.Add("QTY", typeof(int));

dt.Columns.Add("Price", typeof(float));

dt.Columns.Add("Cost", typeof(float));

pro_id = Request.QueryString["pr_id"];

quanti = Convert.ToInt32(Request.QueryString["quant"]);

SqlConnection con = new SqlConnection("Server=.; Database=eclsc; Trusted_Connection=yes");

SqlCommand cmd = new SqlCommand();

cmd.Connection = con;

cmd.CommandText = "select ICEMACHINES.product_id,ICEMACHINES.sh_desc,ICEMACHINES.price from ICEMACHINES where ICEMACHINES.product_id LIKE @product_id union select GLASSWARE.product_id,GLASSWARE.sh_desc,GLASSWARE.price from GLASSWARE where GLASSWARE.product_id LIKE @product_id ";

cmd.Parameters.Add("@product_id", SqlDbType.NVarChar, 50).Value = pro_id;

cmd.Connection.Open();

SqlDataReader rdr = cmd.ExecuteReader();

ArrayList arRole1 = new ArrayList();

while (rdr.Read())

{

desc = (rdr["sh_desc"]).ToString();

id = (rdr["product_id"]).ToString();

unitprice = Convert.ToSingle((rdr["price"]));

cost = unitprice * quanti;

arRole1.Add(rdr["product_id"]);

arRole1.Add(rdr["sh_desc"]);

}

cmd.Connection.Close();

DataRow myrow = dt.NewRow();

myrow["REF"] = id;

myrow["Description"] = desc;

myrow["QTY"] = quanti;

myrow["Price"] = unitprice;

myrow["Cost"] = cost;

dt.Rows.Add(myrow);

dt.AcceptChanges();

DataGrid2.DataSource = dt;

DataGrid2.DataBind();


}