How to get date from textbox and use it for SELECT Statement

Question

I made a programm, which shows a table from my database.

The Statement looks like that:

string sql = ("select CCase.RefNo AS Az, EventTemplate.EventCode AS
    Vorgang from ikaros.CCase join ikaros.Event on CCase.ID =
    Event.CCaseID join ikaros.EventTemplate on Event.EventTemplateID  =
    EventTemplate.ID where EventTemplate.EventCode='IRVB' and
    Event.EventDate ='2014-07-03' order by CCase.RefNo ASC");

Now with

Event.EventDate='2014-07-03'

I get the table of that Date which is given in the SELECT Statement. But I want give the user the opportunity to give a other Date in a Textbox. The Textbox should change the Date in the Statement.

I looked here:

Try 1

Try 2

But it's not the same issue which I have. If this is a duplicate and I was just to silly to find it, please tell me.

Answer 1

The added link in question shows your are using WPF So,

If your date is coming from TextBox then you should use TextBox.Text property to read date from user input like

var date = TextBox1.Text;

OR

If you used DatePicker then you can use DatePicker.SelectedDate.Value.Date property to read user input

 var date = DatePicker1.SelectedDate.Value.Date;

And then pass this to sql query like

string sql = ("select ... where EventTemplate.EventCode='IRVB' and
    Event.EventDate ='"+ date +"' order by CCase.RefNo ASC");

Note: Always use prepared statements (parameterized query) to prevent sql injection attack.

I m not sure that you are using ADO.NET but your paramterized query look like

string sql = ("select ... where EventTemplate.EventCode='IRVB' and
        Event.EventDate = @date order by CCase.RefNo ASC");

SqlCommand command = new SqlCommand(sql, connection);
command.Parameters.AddWithValue("@date", date);