Problem with Date

Question

Post reply

Problem with Date

Viewing 5 posts - 16 through 19 (of 19 total)

You must be logged in to reply to this topic. Login to reply

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 1

I'm trying to see both sides of the fence here... looks like I'll have to keep using the procs .

David Burrows SSC Guru Points: 65142 More actions · Answer 2

if u say my code is not very secure i agree since i am very new to this. But please let me know what else I can do

As suggested, use stored procedures, or at least parameterized queries, e.g.

Dim sqlcomm1 As New SqlClient.SqlCommand

sqlcomm1.Connection = dbconn

sqlcomm1.CommandType = CommandType.Text

sqlcomm1.CommandText = "update D_task_det set str_date=@date,status='In_Progress' where pno=@pno and flag='0' and task=@task and status='Pending'"

sqlcomm1.Parameters.Add("@date", Now.Date())

sqlcomm1.Parameters.Add("@pno", pno)

sqlcomm1.Parameters.Add("@task", lbltask.Text.Trim())

sqlcomm1.ExecuteNonQuery()

Far away is close at hand in the images of elsewhere.
Anon.

Chaitra SSC Enthusiast Points: 189 More actions · Answer 3

Thank u david. Now I changed the enableviewstate property of all controls in that page to true and readonly property of textboxes where we have date to false. Now it is working. But I have see that date textboxes should not be edited. What can u do?

Jeff Moden SSC Guru Points: 1004362 More actions · Answer 4

Thanks, Gail

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Vince De Piante SSC Journeyman Points: 82 More actions · Answer 5

Give them a calendar to pick the date from.

Check the date (isDate()) prior to writing

Return an error message if it is not a valid date

Users are never expected to type in a date. Give them a calendar.