|
Thanks - seen better ways to do this (than wrapping it in COM/ATL server) now with Excel 2008?
I remember I done ATL server way back don't like this. You've got to marshall data into BSTR and all that (even thrown out the book now), just don't like the mechanism.
For example, this looks about right: http://www.c-sharpcorner.com/UploadFile/jodonnell/Excel2003fromCSharp12022005021735AM/Excel2003fromCSharp.aspx[^]
This article shows you how to generate Excel doc with C#, setting cell value via Excel object model and all. But still to call say C# component/dll from Excel VBA code... seems like COM is the only way?
But
dev
|
|
|
|
|
COM isn't ideal, but I don't know any other options unfortunatly. The example you posted seems to be about replacing VBA in Excell with C#. I doubt that you're looking for Excell-automation-article's, so that's not going to help either.
Seems COM is the way to go, sorry 
I are troll 
|
|
|
|
|
haha - COM is still alive afterall.
dev
|
|
|
|
|
Eddy Vluggen wrote: COM isn't ideal, but I don't know any other options unfortunatly.
Neither do I, and I've looked in the past. On the plus side as long as you keep your types within the allowed values on the .net side (this doesn't cause any sort of compile time error, the method's just not exposed in COM) all you really have to do is to tell the compiler to make it a com class. From proof of concept testing, it's reasonably painless.
Today's lesson is brought to you by the word "niggardly". Remember kids, don't attribute to racism what can be explained by Scandinavian language roots.
-- Robert Royall
|
|
|
|
|
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?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
