Comments by Member 13101003

Member 13101003 17-Apr-18 12:25pm View

Winform.... not tried

Member 13101003 15-Apr-18 13:57pm View

string query = "select count(*) from incidents where [resolved on] >= #" + dateTimePicker1.Value + "# and [resolved on] <= #" + dateTimePicker2.Value + "# ";

This is working

Member 13101003 15-Apr-18 9:21am View

How to know if or not the format is same?

Member 13101003 15-Apr-18 9:06am View

datetime

Member 13101003 15-Apr-18 8:49am View

i have a ms access db with a datetime column 'resolved on' ....In m c# application i have two datetimepickers.... datetimepicker1 is 'from date' and datetimepicker2 is 'to date'

my sql query is
string query = "select count(*) from incidents where [resolved on] > '" + dateTimePicker1.Value + "' and [resolved on] < '" + dateTimePicker2.Value + "' ";

im getting this error >> data type mismatch in criteria expresion

ms access column is datatime format long
datetimepickers format is long date

Member 13101003 15-Apr-18 7:58am View

im getting 'data type mismatch in criteria expression' error

Member 13101003 15-Apr-18 7:43am View

it is datetime only

Member 13101003 15-Apr-18 7:42am View

Deleted

how?

Member 13101003 14-Apr-18 11:32am View

can you select from the second table by sql query?

Member 13101003 27-Mar-18 11:52am View

can someone make a demo ?

Member 13101003 24-Mar-18 15:38pm View

grouping table?

Member 13101003 24-Mar-18 15:00pm View

sql

Member 13101003 24-Mar-18 14:37pm View

the second table is necessary because I need groups... it can be changed as weekly or fortnightly...

Member 13101003 24-Mar-18 14:35pm View

I want the data in the datagridview like this
item nov 17 dec 17 jan 18 feb 18
item1 5 3 6 3
item2 6 2 7 2

Comments by Member 13101003 (Top 14 by date)