Add DateTime Input to Database Asp.Net C#

Question

I'm creating a datetime picker using code

<div class='input-group date'>
                    <input type='text' class="form-control" id='datetimepicker'/> 
                    </div>
<script type="text/javascript">
        $(function () {
        $('#datetimepicker').datetimepicker({
        viewMode: 'years'
        });
    });
  </script>

which allows me to create a datetime input. For the backend code, I am able to add fields to the database for asp:textbok's, asp:labels etc, but not for this input. Here is an example of others I am adding

cmd.Parameters.AddWithValue("@jobList", jobList.Text);
        cmd.Parameters.AddWithValue("@jobCriteria", jobCriterta.Text);

When I try to do this for datetime, the option for the ID=datetimepicker does not appear and I'm not able to add whatever datetime is in that input to the database.

Cheers in advance for any help I'm sure it's simple!

Add runat atrribute in your date input control ... runat="server" — Mohammad Arshad Alam
– Mohammad Arshad Alam, Commented Mar 11, 2016 at 3:09

sujith karivelil · Accepted Answer · 2016-03-11 03:25:35Z

2

If you want to access an html control in the back end you need to give the attribute runat="server" along with the tag definition.

<input type='text' runat="server" class="form-control" id='datetimepicker'/>

Then change your script as like this:

$("#<%=datetimepicker.ClientID%>").datetimepicker({
        viewMode: 'years'
        });

After adding this to the tag you will get datetimepicker in the back end. and you can access it's value to do the rest of operations. and one more suggestion use .Parameters.Add() instead for Parameters.AddWithValue()

edited Mar 11, 2016 at 3:25

answered Mar 11, 2016 at 2:59

sujith karivelil

29.1k7 gold badges60 silver badges89 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Stuart Over a year ago

Thank you for this I was able to access it. However, it stopped the jquery from working

Stuart Over a year ago

brilliant, thank you. Quickly, why would you suggest .add() instead of .AddWithValue()?

hexaium · Accepted Answer · 2016-03-11 03:00:04Z

0

Replace the input tag with TextBox server control.

<asp:TextBox ID="datetimepicker" runat="server" ClientIDMode="Static" />

Remember to set ClientIDMode as "Static" to make sure jQuery code can find the textbox correctly. Then the backend C# code can also use this textbox as web control object.

answered Mar 11, 2016 at 3:00

hexaium

565 bronze badges

2 Comments

Stuart Over a year ago

thanks for this although an error appears saying "the field datetimepicker's type system.web.ui.htmlinputtext is not compatible with the type of control system.web.ui.webcontrols.textbox

hexaium Over a year ago

This should be because Visual Studio did not change the type of datetimepicker to WebControls.TextBox in the backgroud. Switch the editor of ASPX page from Source to Design should trigger the change and then your can compile your code correctly.

Collectives™ on Stack Overflow

Add DateTime Input to Database Asp.Net C#

2 Answers 2

2 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related