|
<Message>
<Questions>
...
</Questions>
<Answers id = 1>
..
</Answers>
<Answers id = 2>
..
</Answers>
</Message>
If , we have to get the node corresponding to the Answers node with id = 1 ,
how can we do that?
Shankar C
|
|
|
|
|
A good idea would be to load the contents of your XML file into a dataSet and do your searching on the dataSet instead. This gives you the advantage of handling XML data as if it was an ordinary Database.
Regards,
Polis
Can you practice what you teach?
|
|
|
|
|
private void ImportXML(string path)
{
XmlTextReader reader = null;
try
{
reader = new XmlTextReader(Server.MapPath("../CheckList/"+strFileName));
}
catch
{
Response.Write("File Does'nt exists");
}
XmlDocument doc = new XmlDocument();
doc.Load(reader);
reader.Close();
XmlDocument docNew = new XmlDocument();
docNew.Load(path);
XmlNode oldCd = null;
bool Append = false;
XmlElement root = doc.DocumentElement;
oldCd = root.SelectSingleNode("//answers[@objectid=" + intValue + "]");
if(oldCd == null)
Append = true;
XmlNode CdNew;
XmlElement rootNew = docNew.DocumentElement;
CdNew = rootNew.SelectSingleNode("/answers[@objectid=" + intValue + "]");
XmlNode newBook = doc.ImportNode(CdNew, true);
XmlNode newNode = doc.DocumentElement.ChildNodes[1];
if(Append)
newNode.AppendChild(newBook);
else
newNode.ReplaceChild(newBook,oldCd);
try
{
doc.Save(Server.MapPath("../CheckList/"+strFileName));
}
catch
{
string strPath = Server.MapPath("../CheckList/") + "TempFile.xml";
ImportXML(strPath);
}
}
can u help me in another way to do this?
|
|
|
|
|
Load data from the XML document into a dataSet:
<code>ds</code>= new DataSet();
ds.ReadXml(fileName);
Create a new row based on the table of the dataSet
DataRow <code>drs</code>= ds.Tables["Table1"].NewRow();
drs["Message"] = "Hello World!"
ds.Tables[table].Rows.Add(drs);
Delete an existing row from the table
if (ds.Tables["Table1"].Rows.Count > 0)
{
ds.Tables[table].Rows.RemoveAt(this.dataGrid1.CurrentCell.RowNumber);
}
Search for a value
if (ds.Tables["Table1"].Rows.Count == 1)
if (ds.Tables["Table1"].Rows[0][ds.Tables["Table1"].Columns[0]].ToString() == "Hello World!")
MessageBox.Show("Found");
Save the changes to the XML file
ds.WriteXml(fileName);
Hope this will help you get the picture.
Regards,
Polis
Can you practice what you teach?
|
|
|
|
|
Thanx polis,
but can u tell about the ImportNodes method in the XML api?
|
|
|
|
|
ImportNodes method? Hmm... I am not aware of this one Shankar, sorry. XML API? What exactly do you mean by this?
Regards,
Polis
Can you practice what you teach?
|
|
|
|
|
In the System.XML namespace , we have a class called XMLDocument.
If we create an object for the above said class, we can call the ImportNodes method.
It's working correctly. but i need to know the correct usage for importnodes method.
|
|
|
|
|
Oh right. I just had a quick read on the MSDN[^]about the ImportNode() method. Well, it seems that all it does is to import specified XML nodes from another XML file into the one you are working with.
E.g.
XML File #1 (Current XML file you work with)
Nodes: FirstName, LastName, Age
XML File #2
Nodes: FirstName, LastName, Age, Address
By saying something like "....ImportNode(doc2.DocumentElement.LastChild, true);", it will append the Address node into your XML file #1.
Regards,
Polis
Can you practice what you teach?
|
|
|
|
|
|
hi all...
ParameterField paramField = new ParameterField();
ParameterFields paramFields = new ParameterFields();
ParameterDiscreteValue paramDiscreteValue = new ParameterDiscreteValue();
paramField.ParameterFieldName = "yazi";
paramDiscreteValue.Value = dt.Columns["Yazi"]; ***
paramField.CurrentValues.Add(paramDiscreteValue);
paramFields.Add(paramField);
r.rv.ParameterFieldInfo = paramFields;
r.rv.ReportSource = postaCeki; //this is the report object..
this code doesn't work. it blows on the *** row. i need to load crystal report parameter from datatable or datagrid but i can't  how can i do that?? many thanks...
|
|
|
|
|
Hi
PLs tell me how can i use TAPI with C#
In my application I have winform which contains Four Text box and one button
First button-- Tel no of server
Second button-- Server name
Third button --- UID of server
Foruth button-- PWD of Server
When i press the button it should connect with the database server through modem . I want to implement this using C#
Pls every one should share his thoughts for implementing this product,
I need to implemen urgently
waiting for the response with code in c#
regards
sanjeev 
|
|
|
|
|
well, there are two basic parts of this product,
first is to connect 2 pcs using tapi via tlephone line,
2nd is to make a messaging protocol which will connect ur aplication to the dtabase server on remote system. there should also a service running on remote system(server) which will recieve messages.
i can help u in 1st part that how can u connect to remote system using TAPI in c#. in few days i'll upload an article on codeproject regarding this. in meanwhile u can mail me n i can help u in this regard
so cheers
|
|
|
|
|
Hi,
I have already implemented Remoting connection of SQL Server Using C#
There are basically three textbox on WinForms and one Button First one is Address and Second one is UID and PWD of Server.
When the user press the submit button it connects with server and fetches all the Databases into Tree View
all the computers are connected on LAN.
I urgently need to Implement same thing Using TAPI in C#.
More one Field needs to Entered for Telephone no and it will detect modem of Computer Automatically after pressing submit button Please help me with the code (Connection with TAPI for dialup using modem in C#)
I have to start this application I am stuck now
Which sdk i should download
my email id is sanju10001000@yahoo.com
sanju10001000 and yahoo and com
Waitingh for your response
regards
sanjeev
|
|
|
|
|
Hi,
I need to Convert XML file into CSV file format
Pls forwad me the code for that in C# or vb,net
Regards,
sanjeev
|
|
|
|
|
I don't know about others, but I can only guide you to the right direction. I don't think that asking for the complete source code is a good idea.
I would:
1. Load the XML file into a table in a dataSet
2. Construct a new file on the disk giving it the extension .CSV
3. Loop through that table and copy each of its records into a new line of a text file by comma separating each column's content.
4. Save the file (close File streams)
5. Destroy dataSet
6. That's it
Hope this helps
Regards,
Polis
Can you practice what you teach?
|
|
|
|
|
Hi
I need to convert Xml data to Excel file.
Format of Xml is as given below
a.xml
---------
<newdataset>
<emp>
<eno>1
<ename>rajiv
<sal>10000
<emp>
<eno>2
<ename>manoj
<sal>2000
<emp>
<eno>3
<ename>sankar
<sal>4000
<emp>
<eno>4
<ename>Raj
<sal>6000
Waiting for the response with Code
Regards
sanjeev
|
|
|
|
|
Since Ms Excel can automatically load CSV files why don't you convert your XML file into a CSV one instead? (Now that I think about it, doesn't it load XML files automatically as well?)
Anyways, if you do decide to convert your XML file into a CSV one, take a look at these steps as they were suggested on the previous post:
1. Load the XML file into a table in a dataSet
2. Construct a new file on the disk giving it the extension .CSV
3. Loop through that table and copy each of its records into a new line of a text file by comma separating each column's content.
4. Save the file (close File streams)
5. Destroy dataSet
6. That's it
Hope this helps
Regards,
Polis
Can you practice what you teach?
|
|
|
|
|
can anyone help me out how to save word document using applicationObject
i need to save the current document to local location?( i am using addin for this within addin it shuld work)
|
|
|
|
|
Take a look here[^].
Regards,
Polis
Can you practice what you teach?
|
|
|
|
|
I got a problem with a C# app trying to access files/folders on a LAN
When I try a Directory.Exists(foldername) it always returns false.
Directory.GetCreationTime(folder.Name) gives me a System.IO.IOException: Could not find a part of the path.
I can access all files on the network perfectly but just not with my C# app.
Any ideas on how to fix this?
|
|
|
|
|
Can you be a bit more specific on the way use for trying to access network files through C#? E.g. a sample portion of your code?
Regards,
Polis
Can you practice what you teach?
|
|
|
|
|
After some debugging etc. It seems that its a custom windows service thats trying to access those files (Service is setuped to use my user account details instead of local account).
Basically when I tried Directory.GetCreationTime(path) (C# App which is called by the services at certain timeperiod), it results in that error. I have an other C# app (with no ties to the services) and it works fine.
Any idea how to fix this?
|
|
|
|
|
Is your service running under the Local System account? THe Local System account doesn't have any rights to network resources. You have to go into the Services manager and chagne the account it's running under to one that has rights to the network files your trying to get at.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Yes , I have done that. It stills gives the same error. The user acount which the services uses has no problem accessing any network resources unless I use that C# program with the same services.
|
|
|
|
|
If the application works as a normal application, the account you THINK your using isn't the one your actually using for the service. Did you include the Domain in the username portion? Like MYDOMAIN\useraccount...
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
