Inserting to SQL with Jquery datepicker.

Question

0.00/5 (No votes)

See more:

Good afternoon all. I have a question that I think has a simple answer and I just can't figure it out.

I have a form that the user fills out in which the data gets inserted into a SQL database. One example of a text box I'm using in the form is this:

<asp:TextBox ID="NameOfAgencyTextBox" runat="server" Text='<%# Bind("NameOfAgency") %>' Width="248px" />

I've recently discovered JQuery and found a really nice date/time picker that I've implemented into the form as so:

<script>
  $(function() {
    $( "#datepicker" ).datepicker();
  });
  </script>

ASP Markup

<input type="text" id="datepicker">

Obviously the picker works but it is supposed to be inserted into the field "DateOfIncident". If I construct my binding inside the input the application breaks ie:

<input type="text" id="datepicker" Text='<%# Bind("DateOfIncident") %>

Please can someone help me? Also, let me know if I need to clarify anything.

Posted 14-May-14 9:42am

Branden Coker

Updated 14-May-14 10:31am

v2

Add a Solution

Comments

j snooze 14-May-14 17:15pm

what is the error? Define "the application breaks".
Also curious as to why you aren't using an asp:Textbox for the date? Perhaps if you do that and bind to the serverside field instead of using an html element it will work? Just make the id of the textbox datepicker.

2 solutions

Solution 1

Check this out: jQuery-UI-DatePicker-Calendar-Example-in-ASPNet[^]

Posted 14-May-14 14:36pm

Peter Leow

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

DamithSL · Accepted Answer · 2014-05-14T16:04:00

Solution 2

try with CssClass

C#

<asp:TextBox ID="NameOfAgencyTextBox" runat="server" Text='<%# Bind("NameOfAgency") %>' Width="248px" CssClass ="date" />

then you can use class selector in your jquery

JavaScript

<script>
  $(function() {
    $( ".date" ).datepicker();
  });
</script>

Posted 14-May-14 16:04pm

DamithSL

Updated 16-May-14 16:51pm

v3

Comments

Branden Coker 15-May-14 8:30am

Thank you very much for your responses.

j snooze, this is the error I'm receiving:

0x800a01b6 - JavaScript runtime error: Object doesn't support property or method 'datepick'

I'll read the text you've supplied Peter.

I'll also look into your code as well DamithSL. Thanks a bunch guys as always it's a pleasure learning from the community. Cheers!

Branden Coker 15-May-14 10:12am

If I may ask, what is the
<pre>xmlns:asp="#unkown"</pre> for?

I'm getting the message "error creating control, server tag is not well formed."

DamithSL 15-May-14 11:04am

please remove that, it was added automatically when the code formating in this codeproject answer input area.

Branden Coker 16-May-14 12:11pm

This is what I've changed the code to:
<asp:textbox id="Textbox1" runat="server" text="<%# Bind("NameOfAgency") %>" width="248px" class="date" />

For some reason, it still says, "Error creating control, the server tag is not well formed" and there is a blue line under the entire string. Any ideas? I also copied the Script into my code as instructed. There is no problem with the script at the moment.

DamithSL 16-May-14 22:52pm

please change class="date" to CssClass ="date"

Branden Coker 16-May-14 23:35pm

Thanks a bunch DamithSL. I'll try that on Monday forgot to bring my work laptop home :\ As always I appreciate all of the help from you guys! Have a great weekend!

Branden Coker 19-May-14 10:17am

This is exactly what I'm trying currently and receiving "The server tag is not well formed"

<asp:textbox id="Textbox1" runat="server" text="<%# Bind("NameOfAgency") %>" width="248px" CssClass ="date" />

Branden Coker 19-May-14 10:22am

Thank you for all of your help! My server tag 'issue' was a typo I made myself.