Sunday, November 16, 2014

Method to create and returns a DataTable with given object

  /// <summary>
        /// This method creates and returns a DataTable with given field
        /// </summary>
        ///<param name="lstFields"></param>
        ///<returns>DataTable</returns>
        public static DataTable CreateDataTable(object[] lstFields)
        {
            DataTable myDataTable = new DataTable();
            DataColumn myDataColumn;
            foreach (object obj in lstFields)
            {
                myDataColumn = new DataColumn();
                myDataColumn.DataType = Type.GetType("System.String");
                myDataColumn.ColumnName = obj.ToString();

                if (obj.ToString() == "pk")
                {
                    myDataColumn.AutoIncrementSeed = 1;
                    myDataColumn.AutoIncrement = true;

                }
                else
                    myDataColumn.DefaultValue = obj.ToString();
                myDataTable.Columns.Add(myDataColumn);

            }
            return myDataTable;
        }

No comments:

Using Authorization with Swagger in ASP.NET Core

 Create Solution like below LoginModel.cs using System.ComponentModel.DataAnnotations; namespace UsingAuthorizationWithSwagger.Models {     ...