Comments by Member 14089908

Member 14089908 6-Jan-20 0:44am View

@Chritian thank you for your comment. As i already said, i am new to C# so please share the sample code if you have.
Thank you!

Member 14089908 9-Jun-19 13:29pm View

Hello Richard,
Could you please give the sample code.
Thanks

Member 14089908 9-Jun-19 8:05am View

You means i can do like this?
DataRow[] rows = table.Select("ShiftStartDateTime >=#"+d1+"#"+"AND ShiftEndDateTime <=#"+d2+"#");
Thanks

Member 14089908 8-Jun-19 13:33pm View

I only have problem in the following code.
DataRow[] rows = table.Select("ShiftStartDateTime >=#"+d1.ToString("yyyy/MM/dd hh:mm:ss tt")+"#"+"AND ShiftEndDateTime <=#"+d2.ToString("yyyy/MM/dd hh:mm:ss tt")+"#");
Do you have any suggestion?

Member 14089908 24-Mar-19 3:33am View

nice article, it solved my problem. Thanks

Member 14089908 14-Dec-18 22:48pm View

Thanks RickZeeland for you time, i tried you solution but giving me an error. "Specified cast is not valid".

DateTime d = Convert.ToDateTime("4/12/2018 22:53");
IEnumerable<datarow> selectedRows = dt.AsEnumerable()
.Where(row => (row.Field<datetime>("Shift Start") >= d) && (d <= row.Field<datetime>("Shift End")));

foreach (DataRow row in selectedRows)
{
Console.WriteLine("{0}", row[0]);
}
Please help me out.
Thanks

Member 14089908 14-Dec-18 22:32pm View

Thanks Richard for your time. Actually i want to search within Shift Start and Shift End please at table give bellow.
ID | Shift Start | Shift End
1 | 4/12/2018 7:00:00 AM | 4/12/2018 23:00:00 PM
Now i want get all the values within 4/12/2018 22:53 this date and time.
Thank you very much.

Comments by Member 14089908 (Top 7 by date)