CalendarExtender

Question

0.00/5 (No votes)

See more:

Hi,
I have used TextBox with ajax calendarextender.
I have One Save Button whose behaviour is submit.
when I click on it, Data is Saved into DB.
But Date is stored as Null, Whenever I click on Button Date Disappears, and
is null or length is zero when I insert into DB.

Can anyone help? I think I need to Change Behaviour for CalendarExtender something something.

I am new to Asp.net Please Help.

Thanks in Advance

Posted 27-May-10 9:18am

prathameshpitale

Updated 27-May-10 13:16pm

Henry Minute

v3

Add a Solution

3 solutions

Solution 2

When i click on save Button, Value Disappears from textbox which is calendarextended.

So when execution Reaches CommandStatement, I Find value is Not Present in Textbox..

I Have Only fewLines of Code.

if (db.Insert("insert into JOBCARD values(0,'"+TextBox1.Text+"','"+TextBox2.Text+"','"+TextBox3.Text+"',"+Session["UserID"].ToString()+",(select firmid from FIRM_MASTER where NAME='"+DropDownList4.SelectedItem+"'),'--','false','--',0,0,(select srno from db_users where username='"+DropDownList1.SelectedItem+"'),(select srno from db_users where username='"+DropDownList2.SelectedItem+"'),(select srno from PURPOSE_MASTER where certpurpose='"+DropDownList5.SelectedItem+"'),(select id from CATEGORYMASTER where CATEGORYNAME='"+DropDownList3.SelectedItem+"'),'"+TextBox9.Text+"')"))
            {
                Label10.Visible = false;
                db.filldatasource("SELECT jobid,jobno,jobtitle,jobdate FROM JOBCARD where iscomplete='false'", ref gridview1);
                TextBox1.Text = "";
                TextBox2.Text = "";
                TextBox3.Text = "";
                TextBox9.Text = "";
                TextBox1.Focus();                
            }

Posted 27-May-10 9:29am

prathameshpitale

Updated 27-May-10 13:17pm

v2

Comments

William Winner 27-May-10 16:46pm

You do realize that by marking the answer as solved, most people won't even look at it, right?

So, something is obviously going on before it gets there. Go through and debug it from the first line in your button click. Something in your code is resetting the textbox. But again, without that code, we can't help you.

YATINSUKALE 2-Jul-12 2:41am

i want to store calender extender value in sql then how can this i do

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)

William Winner · Accepted Answer · 2010-05-27T09:23:00

well, since comments aren't working...

you need to give us the code you're using to save it.

My guess is that you're trying to convert a string to a SQL Date type and not including the #. If the column type in the database is a Date type, you need to surround your date value with # like "#1-2-2010#" or SQL won't read it correctly.

But again, without the code, I'm just guessing.

sainath437 · Accepted Answer · 2010-05-28T02:52:00

try this it may help you..

HTML

<asp:TextBox ID ="txtdateofbirth" runat ="server" ></asp:TextBox>
   <asp:CalendarExtender ID ="dateofbirthextender" runat ="server" TargetControlID ="txtdateofbirth" PopupPosition ="Right" ></asp:CalendarExtender>

In code behind just add:

C#

DateTime d = DateTime.Parse(txtdateofbirth.Text);

CalendarExtender

3 solutions

Solution 1

Solution 2

Solution 4

Add your solution here

Preview 0