date to sum

Question

how to sum date in sql 2005..i jest selected from date and to date from date time picker

Hemant Srivastava · Answer

Try this: DateTime dtFrom; DateTime dtTo; private void dateTimePicker1_ValueChanged(object sender EventArgs e) { dtFrom = dateTimePicker_From.Value; } private void dateTimePicker_To_ValueChanged(object sender EventArgs e) { dtTo = dateTimePicker_To.Value; } private void btn_CalcDays_Click(object sender EventArgs e) { TimeSpan timespan = new TimeSpan(); timespan = dtTo - dtFrom ; MessageBox.Show(Math.Abs(timespan.Days).ToString()); }

SUNIL GUTTA · Answer

U mean what mate .. difference of days b/w the mentioned dates ? So use DateTime which is overloaded . .. ..

Sunny Sharma · Answer

Hi Maneesh Please explain how you want the Date to be summed up? Any Sample demo would be great.