DATE and TIME selecting and updating into the database

Question

0.00/5 (No votes)

See more:

iam doing an asp.net application with c# ,i need to insert the selected date value into the database and also display in the texbox. and the main problem is when i click the button then only the calendar should display and also i need to search for the date with the month in the calendar. help me out for SQL just say me the query for inserting the selected date and time into the database
. help me out

Posted 24-Oct-11 21:34pm

ashok_89

Updated 24-Oct-11 21:48pm

v2

Add a Solution

Comments

shek124 25-Oct-11 4:44am

Which Calendar control are you using?

1 solution

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)

OriginalGriff · Accepted Answer · 2011-10-24T21:42:00

Solution 1

SQL

SELECT * FROM myTable WHERE DATEPART(month, dateColumn)=DATEPART(month,'2011-04-21')

Posted 24-Oct-11 21:42pm

OriginalGriff

Comments

ashok_89 25-Oct-11 3:49am

help me out for SQL just say me the query for inserting the selected date and time into the database. the date and time should be selected from the calendar of the asp.net application
. help me out

OriginalGriff 25-Oct-11 3:54am

INSERT INTO myTable (dateColumn) VALUES ('2011-04-21')

What is the problem you are having to do this?

ashok_89 25-Oct-11 5:38am

thanks a lot i have done it and ,how to pass the date and time from one asp page to the other.

this is my emp.aspx page

protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
GridViewRow row = GridView1.SelectedRow;

String dt = GridView1.SelectedRow.Cells[1].Text;
String sal = GridView1.SelectedRow.Cells[2].Text;

Response.Redirect("empupdate.aspx?dt=" + dt + "&sal=" +sal);

my second file empupdate.aspx
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{

TextBox3.Text = Page.Request.QueryString["dt"].ToString();
TextBox4.Text = Page.Request.QueryString["sal"].ToString();

}
}

what i need to change to get the date and time value in the texbox3 of the empupdate.aspx

OriginalGriff 25-Oct-11 5:47am

The problem with that approach is that you have no control over what the user enters in the text box - it could well mess up your re-direct.
Instead, have you considered using the Session variable? http://msdn.microsoft.com/en-us/library/ms178581.aspx
It has the advantage that the Client address bar is cleaner too.

sabbi26 25-Oct-11 7:07am

to send data from one page to another the best way is using Session variables. instead of Querystring use session variable.