|
Hi,
Thanks for you response.
Below is sample template document, in this Date, Name, Age, Address are merge field. I have to convert this template document to XLS.
<Date>
<Name>, <Age>
<Address>
Dear <Dr./Mr./Ms. Last Name>:
Below is the sample XLS for above template. (We created this manually)
<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:fo="http://www.w3.org/1999/XSL/Format"
xmlns:ibex="http://www.xmlpdf.com/2003/ibex/Format">
<xsl:template match="InvitationContemplateInfo">
<fo:block margin-left="0.785in" margin-top="0.7in" margin-right="0.88in" color="gray" font-family="'Times New Roman'" font-size="11.5pt" letter-spacing="0.15pt"><xsl:value-of select="//Date"/>
<xsl:if test="//Name[. != '']"> <xsl:value-of select="//Name"/></xsl:if>
<xsl:if test="//Age[. != '']"> <xsl:value-of select="//Age"/></xsl:if>
</fo:block>
</xsl:template>
</xsl:stylesheet>
Like this we have to create for all different kind of template documents dynamically.
Thank you once again.
Know is Drop, Unknown is Ocean
|
|
|
|
|
Have you tried the XML/XSL forum, you may have more luck there.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Hi People,
Let me be straight, I want to interact with a webserver from a DotNet Client. The web server is a Postgre Server and the server-side scripting language is PHP. The DotNet client is built in C#. I am actually new to this type of a concept but I was wondering whether it is actually possible or not. Its almost 5days now that I am not able to come up with any solid solution. I will be very much thankful if anyone can guide me out of this problem.
Thanks in advance
|
|
|
|
|
Assuming the server uses standard HTML to communicate then you should be able to access it through a client written in any language you like.
arj_agt wrote: Its almost 5days now that I am not able to come up with any solid solution.
A solution to what? Perhaps if you describe your problem someone may be able to offer some words of advice.
It's time for a new signature.
|
|
|
|
|
Thanks to all of you for your tips and advice. I have figured it out.
|
|
|
|
|
It's fairly simple. Server to Server communication is a Solved problem. I believe they came up with a human readable data interchange format to facilitate this sort of task in the late 90's. It's called XML and you can deliver it using either Restful calls or webservices and both languages can make and receive requests from each other across the Internet as well as share data in an interoperable format.
|
|
|
|
|
As mentioned, it would help if you described what the problem is.
Since your client and server are on 2 separate machines, if one sends information in a format the other can handle, it really doesn't matter what languages or operating systems are used on either end.
CQ de W5ALT
Walt Fair, Jr., P. E.
Comport Computing
Specializing in Technical Engineering Software
|
|
|
|
|
HI ALL,
I am trying to use a dll made in C#.net(using framework 2.0) in to vb.net proj in framework 1.1 visual studio 2003
WHen I am trying to do add reference i am getting below error
"ADd reference to dll could not be added.This is not a valid assembly or COM component.ONly assemblies with extension 'dll' and COM components can be referenced.Please make sure that file is accessible,and that is valid assembly or COM component.
BUt when trying to add reference it in vs2005 proj in C#.net its successfully added.
ANy help will be greatly appreciated.
Ankit Aneja
"Nothing is impossible. The word itself says - I M possible"
modified on Tuesday, July 20, 2010 9:34 AM
|
|
|
|
|
You cannot use a 2.0 compiled .DLL in a 1.1 project. With those versions of the .NET Framework, you cannot load two different versions of the .NET CLR in the same process at the same time, like you're trying to do.
If you cannot recompile the 2.0 .DLL under 1.1 because you used stuff that isn't available in 1.1, you have no choice but to upgrade your 2003 project to Visual Studio 2005, or higher, and write in under .NET 2.0, or higher.
|
|
|
|
|
hello all,
I want to deserialize an xml file.This xml has one attribute as xsi:type="value". When i do deserialization xml without this xsi:type thn it works, but when I include this an exception occures.
Please help is there any idea behind it.
Thanks in advance...
|
|
|
|
|
Can you elaborate more by posting here your
xml file or with some sample data, to understand
the scenario?
I think your xml file is not pure, contain
some invalid data that's why it is failing
during serialization.
HTH
Jinal Desai - LIVE
Experience is mother of sage....
|
|
|
|
|
<?xml version="1.0" encoding="utf-8"?>
<PARAMS>
<PARAM xsi:type="VALUE" SEMANTIC="DATA">
<SHORTNAME>PARAM_0</SHORT-NAME>
<DOP-REF IDREF="DOP_MDiffAccelMap02RowAxis"/>
</PARAM>
</PARAMS>
this is the xml file generated..
|
|
|
|
|
Ok, I have dig our more and I found this[^] link.
According to this this is (content xsi is generated serialized xml.
So can you give me the exception or error you are receiving during deserialization?
HTH
Jinal Desai - LIVE
Experience is mother of sage....
|
|
|
|
|
It is not giving a specific exception.When I run code of deserialization it halts and give a general exception like deserialization fail and indiacte at the line whcih contains xsi:type.
|
|
|
|
|
Refer this[^] link, it will resolve your problem.
HTH
Jinal Desai - LIVE
Experience is mother of sage....
|
|
|
|
|
I have same problem as in the linke given by you. Bt I am not getting how it will solve...
plz help..
|
|
|
|
|
Just go through whole article, the resolution is below related questions links.
HTH
Jinal Desai - LIVE
Experience is mother of sage....
|
|
|
|
|
sorry to disturb u again....
I am not able to find related questions links.
|
|
|
|
|
This code might get you on the right track:
XmlSerializerNamespaces namespaces = new XmlSerializerNamespaces();
namespaces.Add("", "");
namespaces.Add("xsi", "http://www.w3.org/2001/XMLSchema");
XmlSerializer serializer = new XmlSerializer(typeof(MyObject));
serializer.Serialize(File.Create("all.xml"), customers, namespaces);
|
|
|
|
|
hello
I have serialized that objects into xml. But problem is in desrialization due to "xsi:type=VALUE".
I have also serialized using code given by U bt still deserialization is problem.
Plz do needful...
Thanks in adv.
|
|
|
|
|
Did you deserialize with the code given? Also, my code is a starting point for something to try. Attempt variations of namespaces, etc.
|
|
|
|
|
I think given code is for serialization not for deserialization because u used serialize() method instead deserialize() and also create an *.xml file. If I am wrong then plz guide me.
Thnx in adv...
|
|
|
|
|
Hello all
Im comparing two data tables(with same structure)and i want to insert the row difference into the first table
eg
table 1 table 2
ColA ColB ColC ColA ColB ColC
A B C A B C
C D A A A A <---new row
D A C C D A
D A C
as you can see , 2nd row in table 2 is new and I want to insert the difference into table1
|
|
|
|
|
There isn't any automated way to achieve the same.
You need to do it manually.
Just loop datatable for the number of rows for the
datatable has greater rows. i.e.
DataTable1 contains 5 rows
DataTable2 contains 6 rows
then write
for(i=0;i<<DataTable2.Rows.Count;i++)
{
for(j=0;j<<DataTable1.Rows.Count;j++)
{
for(t=0;t<<DataTable1.Columns.Count;t++)
{
}
}
}
Then manually compare each row and each column. You need to take two flags.
First flag set when the column of DataTable1 is not matched with DataTable2
for particular row.
Second flag set when there is new row in DataTable2 not matched with any row
of DataTable1.
And accordingly you can take actions.
HTH
Jinal Desai - LIVE
Experience is mother of sage....
|
|
|
|
|
The first thing to try is an INSERT...SELECT...WHERE statement, but that won't work in all cases.
If I have to resort to programming, then depending on the situation (number of rows and columns etc.), I might just throw all the rows in table 2 at table 1 and see what sticks.
0) Ensure that table 1 has a unique index that covers everything that needs to be covered.
1) Set up a parameterized INSERT command for table 1 (this requires a second Connection)
2) Open a DataReader against table 2.
3) Iterate the DataReader
3.1) Set the parameters
3.2) In a try/catch, Execute the INSERT, and ignore (or log) duplicate exceptions
This allows the database to check whether or not the row exists so you don't wind up checking it twice. The big sticking point is the index -- how much data will need to be in the index?
You may also want a Transaction.
Edit: Oh, wait, you meant DataTables? Why would you need to do that?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
