public DataTable CreateTempTable()
{
DataTable dt = new DataTable();
DataColumn myDataColumn;
myDataColumn = new DataColumn();
myDataColumn.DataType = Type.GetType("System.Int32");
myDataColumn.ColumnName = "RequestNo";
dt.Columns.Add(myDataColumn);
myDataColumn = new DataColumn();
myDataColumn.DataType = Type.GetType("System.String");
myDataColumn.ColumnName = "BankCode";
dt.Columns.Add(myDataColumn);
myDataColumn = new DataColumn();
myDataColumn.DataType = Type.GetType("System.String");
myDataColumn.ColumnName = "BSB";
dt.Columns.Add(myDataColumn);
myDataColumn = new DataColumn();
myDataColumn.DataType = Type.GetType("System.String");
myDataColumn.ColumnName = "AccountNo";
dt.Columns.Add(myDataColumn);
myDataColumn = new DataColumn();
myDataColumn.DataType = Type.GetType("System.String");
myDataColumn.ColumnName = "AccountName";
dt.Columns.Add(myDataColumn);
myDataColumn = new DataColumn();
myDataColumn.DataType = Type.GetType("System.String");
myDataColumn.ColumnName = "CBAAddressee";
dt.Columns.Add(myDataColumn);
myDataColumn = new DataColumn();
myDataColumn.DataType = Type.GetType("System.String");
myDataColumn.ColumnName = "WBCAddressee";
dt.Columns.Add(myDataColumn);
myDataColumn = new DataColumn();
myDataColumn.DataType = Type.GetType("System.Boolean");
myDataColumn.ColumnName = "NameVariationRequired";
dt.Columns.Add(myDataColumn);
myDataColumn = new DataColumn();
myDataColumn.DataType = Type.GetType("System.String");
myDataColumn.ColumnName = "NameVariation1";
dt.Columns.Add(myDataColumn);
myDataColumn = new DataColumn();
myDataColumn.DataType = Type.GetType("System.String");
myDataColumn.ColumnName = "NameVariation2";
dt.Columns.Add(myDataColumn);
myDataColumn = new DataColumn();
myDataColumn.DataType = Type.GetType("System.String");
myDataColumn.ColumnName = "NameVariation3";
dt.Columns.Add(myDataColumn);
DataRow row;
for (int i = 0; i < dataGridViewOutstandingLetters.Rows.Count; i++)
{
if ((bool)dataGridViewOutstandingLetters.Rows[i].Cells[("LetterPrinted")].Value)
{
row = dt.NewRow();
row["RequestNo"] = dataGridViewOutstandingLetters.Rows[i].Cells[("RequestNo")].Value;
row["BankCode"] = dataGridViewOutstandingLetters.Rows[i].Cells[("BankCode")].Value;
row["BSB"] = dataGridViewOutstandingLetters.Rows[i].Cells[("BSB")].Value;
row["AccountNo"] = dataGridViewOutstandingLetters.Rows[i].Cells[("AccountNo")].Value;
row["AccountName"] = dataGridViewOutstandingLetters.Rows[i].Cells[("AccountName")].Value;
row["CBAAddressee"] = Session.cbaAddressee;
row["WBCAddressee"] = Session.wbcAddressee;
row["NameVariationRequired"] = dataGridViewOutstandingLetters.Rows[i].Cells[("NameVariationRequired")].Value;
row["NameVariation1"] = dataGridViewOutstandingLetters.Rows[i].Cells[("NameVariation1")].Value;
row["NameVariation2"] = dataGridViewOutstandingLetters.Rows[i].Cells[("NameVariation2")].Value;
row["NameVariation3"] = dataGridViewOutstandingLetters.Rows[i].Cells[("NameVariation3")].Value;
dt.Rows.Add(row);
}
}
return dt;
}
No comments:
Post a Comment