help with code

[newman]

Can anyone help me with code to do the following

I have a stored procedure that requires a date. What I
want to do is to write an application that runs that
stored procedure and prompts the user for date/s to be
entered to run the stored procedure.

Can anyone help??

Regards

Newman

 

[Herfried K. Wagner [MVP]]

I have a stored procedure that requires a date. What I
want to do is to write an application that runs that
stored procedure and prompts the user for date/s to be
entered to run the stored procedure.

0% related to Windows Forms, post this question to this group:

<
Web interface:

<http://msdn.microsoft.com/newsgroup...roup=microsoft.public.dotnet.framework.adonet>

 

[Martin Robins]

Whislt I agree that this is totally off topic ...

use DateTimePicker controls to allow the user to select the dates and then
....


SqlCommand command = new SqlCommand("MyStoredProcedureName");
command.Connection = new SqlConnection(...);
command.Parameters.Add(@"@startDate", SqlDbType.DateTime).Value =
dateTimePicker1.Value.Date;
command.Parameters.Add(@"@endDate", SqlDbType.DateTime).Value =
dateTimePicker2.Value.Date;
command.ExecuteNonQuery();


create procedure MyStoredProcedureName
@startDate datetime,
@endDate datetime

as

set nocount on

-- do something with your dates

return

Note that in this example I have not renamed the DateTimePicker controls
from the VS defaults.