Search This Blog

Tuesday, March 22, 2011

Create DataTable Dynamically

        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