Dynamically add a new column to dataset or data table in c#

Dynamically add a new column to dataset or data table in c#

 

System.Data.DataTable dtIncremented = ds.Tables[0];

        DataColumn auto = new DataColumn("AutoID", typeof(System.Int32));

        dtIncremented.Columns.Add(auto);

        //auto.AutoIncrement = true;

        //auto.AutoIncrementSeed = 1;

        //auto.ReadOnly = true;

        //auto.Unique = true;

       // dtIncremented.Columns.Add(auto);

        //dtIncremented.PrimaryKey = new DataColumn[] { auto };

        dtIncremented.BeginLoadData();

        DataTableReader dtReader = new DataTableReader(ds.Tables[0]);

        dtIncremented.Load(dtReader);

        dtIncremented.EndLoadData();

//foreach (DataRow dr in dtIncremented.Rows)

       // {

       //     dr["AutoID"] = dtIncremented.Rows.IndexOf(dr);

     //   }

If u had any trouble just ask, Happy to help u :)
Stay Tune...
Have a nice day... 'N happy Coding :)

Datatable with auto increment option

Datatable with auto increment option c#

        DataTable dtDuplicatelist = new DataTable();

        DataColumn auto = new DataColumn("AutoID", typeof(System.Int32));

        dtDuplicatelist.Columns.Add(auto);

        auto.AutoIncrement = true;

        auto.AutoIncrementSeed = 1;

        auto.ReadOnly = true;

        auto.Unique = true;

        dtDuplicatelist.Columns.Add("ClientID", typeof(string));

        dtDuplicatelist.Columns.Add("CurrentLoanServicer", typeof(string));

        dtDuplicatelist.Columns.Add("CurrentServicerLoanNo", typeof(string));

        dtDuplicatelist.Columns.Add("NameOfOriginatingLender", typeof(string));

        dtDuplicatelist.Columns.Add("Noofrec", typeof(string));

        dtDuplicatelist.Columns.Add("OriginalLoanNumber", typeof(string));

        dtDuplicatelist.PrimaryKey = new DataColumn[] { auto }; // Setting as primary key Then only it will add autoincrement to the Column

        return dtDuplicatelist;

 
If u had any trouble just ask, Happy to help u :)
Stay Tune... Have a nice day... 'N happy Coding :)

select records from particular week days Or datepart in sql

select records from particular week days Or datepart in sql

SELECT AgencyId,CreatedOn FROM Agencies -- List All Records

SELECT AgencyId,CreatedOn FROM Agencies WHERE (datepart (dw, CreatedOn)) IN (7,1) -- List records Only on saturday and sunday

SELECT AgencyId,CreatedOn FROM Agencies WHERE (datepart (dw, CreatedOn)) NOT IN (5,2) -- List all Records EXCEPT Thuesday and Monday
 

If u had any trouble just ask, Happy to help u :) Stay Tune... Have a nice day... 'N happy Coding :)