DataTable mDT_RptHead = new DataTable(); mDT_RptHead = mDBHelper.GetTable("Select * from rptpo_head"); mDBHelper.ExecuteSQLNonQuery("delete from rptpo_head"); DataTable mDT_PoHead = new DataTable(); mDT_PoHead = mDBHelper.GetTable("SELECT * FROM PO_HEAD WHERE PO_NO='D0003' AND PO_DATE =CONVERT(DATETIME,'13/11/2011',103) and profcen_cd='1'"); if (mDT_PoHead.Rows.Count > 0) { DataRow newRow = mDT_RptHead.NewRow(); mDT_RptHead.Rows.Add(newRow); foreach (DataRow row in mDT_PoHead.Rows) { foreach (DataColumn col in mDT_PoHead.Columns) mDT_RptHead.Rows[0][col.ColumnName] = row[col]; } }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)