Convert dd/MM/yyyy to sql server format

[Assimalyst]

Hi i have a value entered into an asp text box,
procedureDateTx tBx.Text, thet has the format dd/MM/yyyy. I need to
convert this into a format recognisable by SQL server in order to
properly query the database.

I've tried a few DateTime.Parse methods but can't get any to work.

The format of these values in the database is
yyyy-MM-dd hh:mm:ss.000

Thanks

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

What are you doing? are you using a SP or a query?

These are the steps:

1- Make sure the text is correct ! , why not use a Calendar instead of a
Textbox?

2- Convert the text to DateTime :
DateTime.ParseE xact( textbox.Text, "dd/MM/yyyy" ,
DateTimeFormatI nfo.InvariantIn fo);
3- If you are using a sp, it's easy :
command.Paramet ers.Add("@assig neddate", SqlDbType.DateT ime).Value =
DateTime.ParseE xact( textbox.Text, "dd/MM/yyyy" ,
DateTimeFormatI nfo.InvariantIn fo);

4- If you are using a query then yo ushould use a parameterize query:
string selectSQL = "SELECT * FROM table1 WHERE tehdate= ? ";
SqlCommand selectCMD = new SqlCommand(sele ctSQL, theconn);
selectCMD.Param eters.Add("@the date", SqlDbType.NVarC har, 15).Value =
DateTime.ParseE xact( textbox.Text, "dd/MM/yyyy" ,
DateTimeFormatI nfo.InvariantIn fo);

cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"Assimalyst " <c_******@hotma il.com> wrote in message
news:11******** *************@g 49g2000cwa.goog legroups.com...

Hi i have a value entered into an asp text box,
procedureDateTx tBx.Text, thet has the format dd/MM/yyyy. I need to
convert this into a format recognisable by SQL server in order to
properly query the database.

I've tried a few DateTime.Parse methods but can't get any to work.

The format of these values in the database is
yyyy-MM-dd hh:mm:ss.000

Thanks

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

What are you doing? are you using a SP or a query?

These are the steps:

1- Make sure the text is correct ! , why not use a Calendar instead of a
Textbox?

2- Convert the text to DateTime :
DateTime.ParseE xact( textbox.Text, "dd/MM/yyyy" ,
DateTimeFormatI nfo.InvariantIn fo);
3- If you are using a sp, it's easy :
command.Paramet ers.Add("@assig neddate", SqlDbType.DateT ime).Value =
DateTime.ParseE xact( textbox.Text, "dd/MM/yyyy" ,
DateTimeFormatI nfo.InvariantIn fo);

4- If you are using a query then yo ushould use a parameterize query:
string selectSQL = "SELECT * FROM table1 WHERE tehdate= ? ";
SqlCommand selectCMD = new SqlCommand(sele ctSQL, theconn);
selectCMD.Param eters.Add("@the date", SqlDbType.NVarC har, 15).Value =
DateTime.ParseE xact( textbox.Text, "dd/MM/yyyy" ,
DateTimeFormatI nfo.InvariantIn fo);

cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"Assimalyst " <c_******@hotma il.com> wrote in message
news:11******** *************@g 49g2000cwa.goog legroups.com...

Hi i have a value entered into an asp text box,
procedureDateTx tBx.Text, thet has the format dd/MM/yyyy. I need to
convert this into a format recognisable by SQL server in order to
properly query the database.

I've tried a few DateTime.Parse methods but can't get any to work.

The format of these values in the database is
yyyy-MM-dd hh:mm:ss.000

Thanks

[Lasse Vågsæther Karlsen]

Assimalyst wrote:

Hi i have a value entered into an asp text box,
procedureDateTx tBx.Text, thet has the format dd/MM/yyyy. I need to
convert this into a format recognisable by SQL server in order to
properly query the database.

I've tried a few DateTime.Parse methods but can't get any to work.

The format of these values in the database is
yyyy-MM-dd hh:mm:ss.000

Thanks

To "properly" query the database, use a Command object and store the
date in the parameters, using the DateTime type, and letting the
database objects handle the transition from .NET to the database.

If you need to rewrite it so that it can be used in a string to query
the database, use DateTime.ToStri ng("format here") and specify the
correct format, "yyyy-MM-dd HH:mm:ss.000" would probably do the trick.

--
Lasse Vågsæther Karlsen
http://www.vkarlsen.no/
mailto:la***@vk arlsen.no
PGP KeyID: 0x2A42A1C2

[Lasse Vågsæther Karlsen]

Assimalyst wrote:

Hi i have a value entered into an asp text box,
procedureDateTx tBx.Text, thet has the format dd/MM/yyyy. I need to
convert this into a format recognisable by SQL server in order to
properly query the database.

I've tried a few DateTime.Parse methods but can't get any to work.

The format of these values in the database is
yyyy-MM-dd hh:mm:ss.000

Thanks

To "properly" query the database, use a Command object and store the
date in the parameters, using the DateTime type, and letting the
database objects handle the transition from .NET to the database.

If you need to rewrite it so that it can be used in a string to query
the database, use DateTime.ToStri ng("format here") and specify the
correct format, "yyyy-MM-dd HH:mm:ss.000" would probably do the trick.

--
Lasse Vågsæther Karlsen
http://www.vkarlsen.no/
mailto:la***@vk arlsen.no
PGP KeyID: 0x2A42A1C2

[Adam Clauss]

"Assimalyst " <c_******@hotma il.com> wrote in message
news:11******** *************@g 49g2000cwa.goog legroups.com...

Hi i have a value entered into an asp text box,
procedureDateTx tBx.Text, thet has the format dd/MM/yyyy. I need to
convert this into a format recognisable by SQL server in order to
properly query the database.

I've tried a few DateTime.Parse methods but can't get any to work.

The format of these values in the database is
yyyy-MM-dd hh:mm:ss.000

Thanks

Use DateTime.ParseE xact and pass it the exact format you are giving it.

--
Adam Clauss

[Adam Clauss]

"Assimalyst " <c_******@hotma il.com> wrote in message
news:11******** *************@g 49g2000cwa.goog legroups.com...

Hi i have a value entered into an asp text box,
procedureDateTx tBx.Text, thet has the format dd/MM/yyyy. I need to
convert this into a format recognisable by SQL server in order to
properly query the database.

I've tried a few DateTime.Parse methods but can't get any to work.

The format of these values in the database is
yyyy-MM-dd hh:mm:ss.000

Thanks

Use DateTime.ParseE xact and pass it the exact format you are giving it.

--
Adam Clauss

[Stephen Russell]

"Assimalyst " <c_******@hotma il.com> wrote in message
news:11******** *************@g 49g2000cwa.goog legroups.com...

Hi i have a value entered into an asp text box,
procedureDateTx tBx.Text, thet has the format dd/MM/yyyy. I need to
convert this into a format recognisable by SQL server in order to
properly query the database.

I've tried a few DateTime.Parse methods but can't get any to work.

string SQL ="Select * from yourTable were yourDateColumn =
'"+this.procedu reDateTxtBx.ToS tring()

that is open for SQL injection but it will work. You could also have a SP
in the db where your :
exec yourProc procedureDateTx tBx.ToString()

[Stephen Russell]

"Assimalyst " <c_******@hotma il.com> wrote in message
news:11******** *************@g 49g2000cwa.goog legroups.com...

Hi i have a value entered into an asp text box,
procedureDateTx tBx.Text, thet has the format dd/MM/yyyy. I need to
convert this into a format recognisable by SQL server in order to
properly query the database.

I've tried a few DateTime.Parse methods but can't get any to work.

string SQL ="Select * from yourTable were yourDateColumn =
'"+this.procedu reDateTxtBx.ToS tring()

that is open for SQL injection but it will work. You could also have a SP
in the db where your :
exec yourProc procedureDateTx tBx.ToString()