|
Yes, but I do not know what code is in your editor on line 103
Is it an XLS or an XLSX? How many rows?
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
XLSX 103 rows
|
|
|
|
|
xlxs 103 rows
|
|
|
|
|
What compatibility issues? Between different versions of Excel? The .NET framework? 32/64 bit applications?
There are multiple reasons why the error-code can be thrown, some of the are listed here[^].
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
I do not know anymore 64-bit PC . I am using Excel 2013 .
|
|
|
|
|
Kalay16 wrote:
I do not know anymore 64-bit PC . I am using
Excel 2013 . You can verify which version by looking at the about-box. If your PC is 32-bits, then all installed software is too.
I still don't know what code is at the line where you mentioned an error, nor what you mean with compatibility-issues. I cannot "solve" this, you'll have to; are you still trying to access values in a loop? With drawing?
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
Hello,
I face some challenges and would appreciate help in finding out how to handle it.
I am using XML serialization to save some data of an application. However, I would like to use the same XML file in a different application. I do not want to de-serialize the file; I just read it with XmlDoc.
The reading part of it works fine, however, in my other application I would like to execute same SelectNodes+Xpath queries - that's the problem. Any query, I do, doesnt work for some reason.
Here an example of my XML file:
="1.0"="utf-8"
<TestProject xmlns:i="http://www.w3.org/2001/XMLSchema-instance" z:Id="i1" xmlns:z="http://schemas.microsoft.com/2003/10/Serialization/" xmlns="http://schemas.datacontract.org/2004/07/Test">
<DicKeysWhichDirectlyReferenceMe xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays" i:nil="true" />
<IsCurrentlyLoading>false</IsCurrentlyLoading>
<IsLoaded>false</IsLoaded>
<IsProcessing>false</IsProcessing>
<ListsWhichDirectlyReferenceMe xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays" i:nil="true" />
<ObjectsWhichDirectlyReferenceMe xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays" i:nil="true" />
<name>UnknownTypeName</name>
...
A query like this just works, but doesnt bring a big benefit for course...!
XmlDocument doc = new XmlDocument();
doc.Load("test.xml");
XmlNode node = doc.ChildNodes[1];
XmlNodeList list = doc.SelectNodes("*");
However, a query like this doesnt work:
XmlNodeList list = doc.SelectNodes("IsLoaded");
XmlNodeList list1 = doc.SelectNodes("/IsLoaded");
XmlNodeList list2 = doc.SelectNodes("//IsLoaded");
I was already trying many things, inc. adding some namespaces, but I wasnt successful.
Again, I would be thankful for any help!
thanks and best regards
|
|
|
|
|
You need to drop down 1 level; e.g.
XmlDocument doc = new XmlDocument();
doc.Load( "test.xml" );
XmlNode root = doc.DocumentElement;
XmlNodeList list = root.SelectNodes( "IsLoaded" );
OR
XmlDocument doc = new XmlDocument();
doc.Load( "test.xml" );
XmlNodeList list = doc.SelectNodes( "TestProject/IsLoaded" );
|
|
|
|
|
hello,
I am working on a c # application has logged a database informix odbc, I put my connection string but when I run the application I get an error that says ERROR [28000] [SCO Vision] [ODBC Driver] Invalid user authorization specification.
I think you have to download the SCO ODBC VISION But its been a week since I'm looking for driver not found
Are you know what is this error has ?.
Thank you
|
|
|
|
|
According to the ultimate resource on connection strings http://www.connectionstrings.com/informix/[^], the ODBC connection string for an Informix database looks thus:
Informix 3.30:
Dsn='';Driver={INFORMIX 3.30 32 BIT};Host=hostname;Server=myServerAddress;
Service=service-name;Protocol=olsoctcp;Database=myDataBase;Uid=myUsername;
Pwd=myPassword;
Important! The parameters for user authorization are called 'Uid' and 'Pwd'.
You need to be wary of this as the IBM Informix OLE DB Provider connection string uses the parameter names 'User ID' and 'Password'.
The quotes are not part of the parameter name.
Best regards,
Manfred
"I had the right to remain silent, but I didn't have the ability!"
Ron White, Comedian
|
|
|
|
|
why delegates are used in c#
|
|
|
|
|
Because we can.
Because they are usefull.
Because they are function-pointers-on-steroids.
Because some things won;t work without them (or something very like them).
Google could tell you a lot more: it found this very quickly.
6 important uses of Delegates and Events[^]
In future, please do at least basic research, and not waste your time or ours.
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
This is the OP's first post on CP.
« There is only one difference between a madman and me. The madman thinks he is sane. I know I am mad. » Salvador Dali
|
|
|
|
|
I was fresh out of bed, and hadn't finished my first
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
Sorry, dude, but I think you are over reacting a touch. He asked a perfectly valid question, which might not be up to your high standards, but valid none the less. Just ignore the question if you feel the OP hasn't "Done Enough".
Take a look at Bill's answer to the same question, and you can see a huge difference between attitudes.
Everyone dies - but not everyone lives
|
|
|
|
|
They give .NET programmers a way to create a strongly-typed template for a type-safe function pointer for uses like:
a. passing a block of executable code as a parameter to a method
b. enabling late-bound evaluation
c. they are foundation of the multi-cast Event facility in .NET
d. they enable the easy implementation of callback methods from one object to another across namespace/scope boundaries
Many people have found value in author Jesse Liberty's explanation of Delegates: [^].
« There is only one difference between a madman and me. The madman thinks he is sane. I know I am mad. » Salvador Dali
|
|
|
|
|
plz help i want to make a project in c# widows form and i want to connect sqlserver2008 express data base my project is bus reservation system.
plz help me or send me project.
modified 14-Oct-14 15:11pm.
|
|
|
|
|
So, design your project, and get to work implementing it in C#, and, when you have specific questions, and code examples that illustrate those specific questions, please post those questions here, or on the QA C# forum.
May I suggest you remove your personal e-mail from your message: posting it here invites spam ... as you may know the web is full of site-crawlers run by spammers looking for e-mail addresses.
« There is only one difference between a madman and me. The madman thinks he is sane. I know I am mad. » Salvador Dali
|
|
|
|
|
Do you have a question?
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
We do not do your homework: it is set for a reason. It is there so that you think about what you have been told, and try to understand it. It is also there so that your tutor can identify areas where you are weak, and focus more attention on remedial action.
Try it yourself, you may find it is not as difficult as you think!
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
I have my system date time format set as "dd-MMM-yy" which outputs datetime as {16-Jun-08 8:30:00 AM}
i want to make sure that no matter what the datetime set on system/server datetime always shows it as MM/dd/yyyy
i googled a lot with setting culture but none is pointing towards a solution, all are offering solution to convert to string and then change the format but i don't want to change to string instead i want to change the datetime variable output to a specific format
any help is apperciated
|
|
|
|
|
nitin_ion wrote: datetime always shows Where?
I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)
|
|
|
|
|
whenever i try to get value from datetime it show system specific format.
this i want to change
|
|
|
|
|
Still not clear, but as you posted it in C# forum...
Custom Date and Time Format Strings[^]
I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)
|
|
|
|
|
My system date date shows 14-oct-14 so when i use a datetime variable it also give date in the same format.
I want to change it to some other format 'en-US'.
I can do that by
DateTime.Now.ToString("MM/dd/yyyy"
) but then it is in string
I want the DateTime it self to return in the specific format and not as string.
This is because my SQL date format is different and when i want to compare dates on SQL then i get issue.
|
|
|
|