|
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 )
|
|
|
|
|
|
Wow - one more worthless and lazy clown doing work they are not skilled to do, who expects me to do their job for them, and who doesn't like me for refusing to be at their beck and call. Boo hoo. How ever shall I live ? Oh, wait, I've made something of myself in life, which is why I am more than happy to offer free help on these forums to people who deserve it. You just got added to my other list, you ignorant retard.
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 )
|
|
|
|
|
|
I notice he's too dumb to even spell it right.
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 )
|
|
|
|