I have some XML doc loaded in a C# Web Service.
XmlDocument doc = new XmlDocument();
Code Missing to manipulate header (I would like to replace or manupulate all
Any idea on how to access and manipulate data within the doc header?
> I have some XML doc loaded in a C# Web Service.
> XmlDocument doc = new XmlDocument();
> Code Missing to manipulate header ...Read XHTML into XML
I need to read/parse XHTML aspx pages and look for certain tokens and
content. How can I use a XmlTextReader for this? If not, any other ideas?
Thanks in advance,
Jose Antonio Reyes wrote:
> I need to read/parse XHTML aspx pages and look for certain tokens and
> content. How can I use a XmlTextReader for this? If not, any other ideas?
If the pages are well-formed XHTML then it is possible to use XmlReader
(in .NET 2.0/3.0) or XmlTextReader (in .NET 1.x) to parse the XHTML
documents. You can also use the other XML APIs .NET provides so using
XPathNavigator and/o...VB Assigning Values to a Series of Strings
In the VB Editor, I need to assign each letter of a 13 character string
(named JobScope) to individual Variables (K1 through K13). I'm using a
For/Next Loop to extract the indiv characters but cannot figure out how to
define the Variable K(x) where x = 1 to 13. Any suggestions?
Try making K an array with 14 elements (VBA numbers the first element as 0)
Then you can use the method you're trying at the moment.
For X = 1 To 13
K(X) = etc.
The only other change you'll have to make is how you address the variables
elsewhere. E.g, K5 w...How to invoke the xml editor?
I installed vs2005 on a new xp pro machine, and installed everything
except C++. When I click on a file with a ".xml" extension it is
opened with IE. When I click file/Edit with XML Editor, it opens it
with Notepad. If I click File/Open With and select XML Editor, it
opens it with IE. So, where is the xml editor?
Can it be invoked from withing VS? Where?
* firstname.lastname@example.org wrote in microsoft.public.dotnet.xml:
>I installed vs2005 on a new xp pro machine, and installed everything
>except C++. When I click on a file with a ".xml" extension it is
>opened ...show XML schema and values
I have an XML document that looks like the following:
What I'm aiming to do is to show the data in a report as in the following
The "Field1-3"-elements can have any name, so I'm trying to get a table that
has in one result column the element name, and in the second colum...Making attribute which is a picklist a primary attribute/key
I have an entity with one attribute and is a picklist, I want it to be a
primary attribute but it does not give me that option, it shows only nvarchar
from the drop down list
Yes you are right, primary field can only be nvarchar. You may change the
schema name of primary attribute at first place but cannt change it's type.
PLEASE do click on Yes or No button if this post was helpful or not for our
Email for direct contact: imumar at gmail dot com
> I have an entity with one attribute and is a picklist, I want it to be a...edit multiple values
Hi, I have a price list sheet with item descriptions and pricing. The
information is all over, not in straight colums or rows.
Is there a way to have excel search out all the cells with $ values and
reduce or increase by a specific %. example : Icrease or derease ever cell
with a $ value by 20%
It can be done with a VBA macro, Post Back if you want more.
Hope this helps!
"Eddie" <email@example.com> wrote in message news:L0vbb.7310$I36.4654@pd7tw3no...
> Hi, I have a price list sheet with item descriptions and p...Moving a line chart data point revises data table value in Excel '
I recall a capability I used with Excel years ago that enabled me to create a
line chart from a data table, then move the plot points on the chart to
"smooth" the line, and the source data chart value would change with the
corresponding new plotted point.
I'd like to use that capability with Excel 2007 but can't find to activate it.
Any power users know how?
Ed, Microsoft decided that users didn't need that feature. More than
likely, they were tired of support calls asking why the values changed when
one dragged a data point...... No really, they took i...Offline synch using XML web-services
This is a bit long-winded. Can somebody read thru these 2 use cases, and
tell me if it is feasible ? :-
Use Case : Replication before Offline Synch
Scenario 1 : Oracle Server , MSDE client
1. User clicks on 'Go Offline'. System creates a MSDE SQL database in
laptop (client), gets the schemas of the tables in Oracle, creates
corresponding tables in client's MSDE SQL (mapping Oracle datatypes to SQL
2. Offline replication program reads in the tables of the server into a
typed datasets, converts the typed datasets into XML, and stores the XML in
the client. (XML serial...XML Serialization ... how to truncate <?xml...
While xml serializing object how can I truncate <?xml ...?> this line alone?
I need to send the serialized xml data to a web method ... since SOAP
already have <?xml tag there was some confusion
Any help would be greatly appreciated
> While xml serializing object how can I truncate <?xml ...?> this line alone?
Serialize to an XmlWriter created with XmlWriterSettings where you set
OmitXmlDeclaration to true.
Martin Honnen --- MVP XML
...error adding new Schema Field 04-21-04
When I attempt to add a new schema field to the "Lead" object in the
Deployment Manager, I get the following error:
"An error occured during the addtion of the new field. The addition
In the event log, I there are two relevant entries:
"dmLog: Failed to add new Picklist attribute (CFPsolution) to Lead
"dmLog: sp_repladdcolumn failed. - Timeout expired"
I've previously successfully added a pickup list called "Sector" with
9 values. Therefore I don't think I've exceeded the 8000 char row
Apart from...String to xml document
I was hoping someone can help me with a little problem I can't seem to find
any answers to.
I've got a form wich will be posted. On receiving the post I would like to
parse a formvar to a xml document.
The contents of this formvar (string) will be a valid xhtml document.
Can someone give me a startertip (or more :-)) on how to achieve this?
tnx in advance,
James van der Veen
> I was hoping someone can help me with a little problem I can't seem to find
> any answers to.
> I've got a form wich will be posted. On receiving the p...Beginner of XML
I am a beginner of XML.
I want to group some files together with a xml file. (it includes a text
file, and an image file and a video file)
Can someone show me some guidelines?
...Valid xml to read from an xml file?
I'm using vb.net, i get an error at the reader line saying the remote
server can't be found. Is the below even valid?
dim reader as XmlTextReader
reader = new XmlTextReader ("http://www.mysite.com/my.xml")
do while (reader.Read())
'do some action here
XmlTextReader uses System.Net.WebRequest under the covers -- see if you can
figure out how to create a connection that way. Usually there's some proxy
server information missing that you can enable if you use WebRequest
directly, and then pass the result of GetResponse()...Example eConnect XML documents
MSDN says the following:
Installing eConnect schema
When you include the schemas component of the eConnect install, the
installer places schema files in a schemas folder on your computer.
The following schema resources are available:
The install places the .xsd schema files in the directory c:\Program
Files\Microsoft Great Plains\eConnect9\XML Schema\Incoming XSD
Individual Schemas. The files in the directory contain the schema for
each eConnect XML document.
The install places a file named eConnect.xsd that contains the schema
definition for all eConnect XML documents. The install typicall...Saving DataSet as XML in ADO format using VB.NET
I am trying to convert a lot of web reports from ASP/VB to
ASP.NET/VB.NET. I would like to save my dataset in XML and then use
XSLT to transform the XML. The catch is I would like to have the XML
in the format that ADO uses versus the default format in which ADO.NET
uses. Currently, I am using ADO within .NET, but I am concerned about
the performance and it might improve if I used the native data
providers for .NET. I am not sure if I am missing something but how do
I save the .NET DataSet to XML in the OLD ADO format?
Thanks for you help in advance and it is most appreciated.
In the ...Previous value
In a detail section, is there a way to get the previous field value in the
I'm asking this because each current is calculated with the previous value.
The first a simple calculation based on current values.
looks like recursive code, but how to do without vba?
Thanks in advance for any good suggestion
I can't tell from your description how you (and therefore, how Access)
determines "previous". You'll need to be able to define that in a way that
you can explain to Access.
If you are trying to build a "running sum...Typed in value changes? #2
Hi Folks ,
I am sure that I must have done something screwy and changed some options
around but I have not been able to figure out what the problem is. The issue
is that whenever I type a value into a cell it automatically divides that
number by 100 and that is the value that is then displayed in the cell (ie
typing 3 into the cell results in 0.03 being displayed). This just happened
all of a sudden and it does not matter if I am in a file I previously created
or a new file and it does not matter what column or row I type the value in.
It is worth noting that if I open up previously...Picking matching value from a list
Suppose I have a pair of columns giving nicknames and full names, e.g.
John John Q. Public
Bob Robert F. Kennedy
Marty Martin Luther King
Abe Abraham Lincoln
Dick Richard M. Nixon
Is there a worksheet function which will accept the value of a nickname
from one cell along with the location of the above table, and return
the name from the second column corresponding to the matching nickname
in the first column?
E.g. I type "Abe" and the function returns "Abraham Lincoln"?
Seems like there should be, but I can't find it.
Have a ...linking to external file based on cell value
I am wondering if it is possible to set up a link within
excel that references an external file using a cell value
in the main spreadsheet.
this is the current setup
instead of the Jan04 in the link, I would like a cell
I tried this but it does not seem to work:
="[expense_allocation.xls]" & A1 & "!$G$5"
where A1 = Jan04
Any ideas would be appreciated.
Instead of typing it in, open up both files and select each cell as you're
creating the formula to make...eConnect RMALine null value error
I am working on a eConnect RMA project. When I sent the eConnect RMA XML
file to the backoffice by calling:
I got the following exception:
Microsoft.GreatPlains.eConnect.eConnectException: Sql procedure error codes
Error Number = 9911 Stored Procedure taFSRMALine Error Description = At
least one input variable contains a null value
This is my xml file:
<FSRMAType><eConn...XML variable for description on receipt?
Hi, I would like to add a description (actually all of those 3 extended
descriptions) to display on the printed receipt under the main description.
What is the variable to do that?
"Zorian" <Zorian@discussions.microsoft.com> wrote in message
> Hi, I would like to add a description (actually all of those 3 extended
> descriptions) to display on the printed receipt un...Notes Schema Name
Can anyone please tell me what is the notes schema name and whether or not I
can apply a java script on it - in the onload or onsave options in the form.
The schema name is Annotation. However it is not possible to customize the
onload/onsave event the way you can do it with the other entities.
However a callout is supported. You can write code for Create, Update,
Delete and Assign.
Hope this helps,
Merijn van Mourik
"Guy Shokrani" wrote:
> Hi all,
> Can anyone please tell me what is the notes schema name a...i enter value in one column the next column existing value turn 0
I am working same work sheet with two columns one is Anticipated Variation
cost and the other approved variation with corresponding total. when i enter
cost in approved variation the corresponding row in anticipated variation
column should auotmaticlly become zero.cna you help me out with the formula
"Bonnie" <Bonnie@discussions.microsoft.com> wrote in message
>I am working same work sheet with two columns o...Want to make excel to pull up a jpeg based on cell values
I want excel to pull up a jpeg based on a cell's value. It would inser
the jpeg into another cell.
An example: If A:25 has a value of 5 can exel grab 5.jpeg fro
somewhere and insert it into another cell, say C:25?
I assume the best place to put these jpegs for excel's use is o
fishbin's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2072
View this thread: http://www.excelforum.com/showthread.php?threadid=49195
Perhaps you can adapt this: