|
How can perform following conversion (string to datetime)?
string s="January 1, 1986" to DateTime datatype
shahdat
|
|
|
|
|
string s = "January 1, 1986";
DateTime dt;
if (!DateTime.TryParse(s, out dt))
else
|
|
|
|
|
Dude try this
String s = "January 1, 1986";
DateTime t1 = DateTime.ParseExact(s, "MMMM d, yyyy", null);
|
|
|
|
|
Dear all,
I have a procedure that works nice I guess.
Exm-
CREATE PROCEDURE Insert_TeacherProfile
(@Ins_ID int, @Yr smallint, @Querter int, @Tcr_ID smallint, @Tcr_Nm nvarchar,
@Gender smallint)
AS
INSERT INTO TeacherProfile
(Ins_ID, Yr, Querter, Tcr_ID, Tcr_Nm, Gender)
VALUES
(@Ins_ID, @Yr, @Querter, @Tcr_ID, @Tcr_Nm, @Gender)
Now you can see the all field not allaw null except Gender(allaw null) field. But In the software when I pass no (null) value in Gender filed it show error. Anyway to pass null value in this query. I need two option, value or null anything I can be inserted. Is there anyway to do it inside this procedure?
If you dont understand tell me.
Thanks
|
|
|
|
|
WE have a SQL forum, but if you want to be able to pass null in then use isnull to change the nulls to a default value.
Christian Graus
Driven to the arms of OSX by Vista.
"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )
|
|
|
|
|
sorry I ve done mistake for posting in this section.
But my default is null also.
Thank you
|
|
|
|
|
NOt sure how you are passing a null value to the gender field - show us the code and we may be able to help - also what is the error you are getting?
___________________________________________
.\\axxx
(That's an 'M')
|
|
|
|
|
I dont wanna do it by coad thats why I want to know how to do.
thanks
|
|
|
|
|
soulidentities wrote: If you dont understand tell me.
It is not clear. Are you looking for solution to pass NULL to the @Gender parameter? If yes, you can do this in procedure level or in code level. In procedure level,
CREATE PROCEDURE Insert_TeacherProfile
(
@Ins_ID int,
@Yr smallint,
@Querter int,
@Tcr_ID smallint,
@Tcr_Nm nvarchar,
@Gender smallint = NULL)
AS
.... Or use DbNull.Value as parameter value from the code.
yourCommand.Parameters.AddWithValue("@Gender",DbNull.Value)
|
|
|
|
|
I know this coad that you mentioned.
i also using this coad. My need is by using this coad when it dones get any value from textbox the procedure automatically get null.
Is it possible??
|
|
|
|
|
well if you textbox entry is stored in an integer
e.g. int gender = SomeMethodThatConvertsTextToAnInteger(myTextBox.Text);
you could make gender a nullable int
int? = SomeMethodThatConvertsTextToANullableInteger(myTextBox.Text);
then when you pass that value to the SP (using the code supplied earlier in this thread) its value will be null.
Or you can say somethiong like
if (myTextBox.Text == string.Empty)
yourCommand.Parameters.AddWithValue("@Gender",DbNull.Value);
else
yourCommand.Parameters.AddWithValue("@Gender",myTextBox.Text);
___________________________________________
.\\axxx
(That's an 'M')
|
|
|
|
|
thanks but I have also done this method.
My original code is this that U have adviced but I want to do this job by procedure. SO that I dont have to code all this line or use if else.
Thanks anyway.
|
|
|
|
|
Sorry, I am not really following what you are trying to do. You must pass teh parameter to the SP (because you may give it a value) so you need to pass some value (even if it is null) to the parameter - there's just no getting away from that.
___________________________________________
.\\axxx
(That's an 'M')
|
|
|
|
|
Hi All The Subject Says It All! I Need Code So That I Can Track UPS, USPS, DHL & Fedex Package's In C#. I Have Tried A Few On Code Project But They Only Support Tracking Via 1 Courier! I Need An All In One For My Package Tracker App!
Things Im Looking For!
1. The Exact Status(examples: USPS(Processed), UPS(In Transit - On Time))
2. The Description Of the Status(examples: USPS(Your Items Where Delivered In ... On 4/4/04 @ 12:00pm)
3. if error is thrown i want the exact error! Like On UPS it would give something Like (No Tracking Info Available
if i think about something else i will update this post
Thanks In Advance!
|
|
|
|
|
The obvious way to do this is to see if these vendors offer a webservice you can call to get this info.
Christian Graus
Driven to the arms of OSX by Vista.
"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )
|
|
|
|
|
im a noobie so There Web service's do me no good if i can't code my app to use them
i can program basic apps the web service stuff is to advance for me! Can't Do XML Or Web Requests
|
|
|
|
|
Well, then you're screwed. Where did you hope to pull this information from, thin air ? Perhaps you need to buy a book or two and work through them. I assume this is not paid work, because if it was, you'd be a liar and a thief. So, choose someone simpler for your first project, and work up to this.
Christian Graus
Driven to the arms of OSX by Vista.
"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )
|
|
|
|
|
Hire a real programmer to do it, then.
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997 ----- "...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001
|
|
|
|
|
cworkman29729 wrote: Hi All The Subject Says It All! I Need Code So That I Can Track UPS, USPS, DHL & Fedex Package's In C#. I Have Tried A Few On Code Project But They Only Support Tracking Via 1 Courier! I Need An All In One For My Package Tracker App!
Things Im Looking For!
1. The Exact Status(examples: USPS(Processed), UPS(In Transit - On Time))
2. The Description Of the Status(examples: USPS(Your Items Where Delivered In ... On 4/4/04 @ 12:00pm)
3. if error is thrown i want the exact error! Like On UPS it would give something Like (No Tracking Info Available
if i think about something else i will update this post
Hi. This is rentacoder.com. We've noticed that you've posted a request into the wrong place. If you'd like somebody to write code for you, please apply here[^].
"WPF has many lovers. It's a veritable porn star!" - Josh Smith As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.
My blog | My articles | MoXAML PowerToys | Onyx
|
|
|
|
|
missing method expectation was unhandeled.
method not found...,system.object . system.windows.threading.dispatcher,invoke(system.delegate,system.object[])
i get this error after compiling Cosmos in QEMU. do u know what is that error?
can you help me with this?
thanks
|
|
|
|
|
What's wrong with you? You have posted this 3 times now. I have given a reply here[^], you haven't followed up. Colin gave another reply here[^], still you haven't followed up. What is the point in asking again and again?
|
|
|
|
|
I need help diplaying tha time on one of my windows forms next to my calendar. I need a code that will display the long time, hours, minutes and seconds. This is urgent please help!
|
|
|
|
|
I'll give you a head start: part of a DateTime struct is about time.
Now hurry and nit some code together.
|
|
|
|
|
txmxax25 wrote: This is urgent please help!
I'm sure it's not. If it was, you'd have used google, or perhaps even bought a book at some point.
Christian Graus
Driven to the arms of OSX by Vista.
"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )
|
|
|
|
|