|
Pete,
i went over to Q&A, and that wasn't me. Besides, the questions are quite different. He's trying to export to an XML file, while i'm trying to export data to a Typed XML Schema file. I can do the former, but have problems with the latter. I've seen the responses to that, and they aren't helpful to mine.
I humbly ask, pls is there any1 with a solution to my problem?
He who goes for revenge must first dig two graves.
|
|
|
|
|
|
No problem, Pete, just a misconception.
He who goes for revenge must first dig two graves.
|
|
|
|
|
Do you wish to create the schema as part of the xml production or is that defined already?
Without going near code, SQL Server has got various things in it to retrieve data in XML, using the FOR XML AUTO thing for instance. That is of course, presuming you're using SQL Server.
Regards,
Rob Philpott.
|
|
|
|
|
Rob,
Yes, i'm using SQL Server. The problem is that i'm supposed to pull several data from various tables, and the schema has been defined by my clients in one cumbersome XML schema file. The data includes names, addresses, sales agents (which could be multiple), contacts (phones and emails, which could also be multiple), and so on. So i'm supposed to bring all data relating to one person into an XML file.
That's my problem.
He who goes for revenge must first dig two graves.
|
|
|
|
|
Well, that could be a tricky thing to do depending on how the schema has been laid out. Probably the best approach is to see if you can use the FOR XML AUTO thing with appropriate joins to get your query response to validate against the schema, but then apart from that you might want to look at the XSD tool which could generate business objects from the schema which you'll have to populate manually through code.
Regards,
Rob Philpott.
|
|
|
|
|
Rob Philpott wrote: but then apart from that you might want to look at the XSD tool which could generate business objects from the schema which you'll have to populate manually through code.
I'm sorry i don't know about this.
He who goes for revenge must first dig two graves.
|
|
|
|
|
Ouch. Your choices are either to serialize your different objects out to a temporary location and then use Xslt to convert them, or you create a super class that contains the values and serialize that. If I were you, I'd go with the Xslt approach.
|
|
|
|
|
Ouch. Harder than i thought.
Pete O'Hanlon wrote: Your choices are either to serialize your different objects out to a temporary location and then use Xslt to convert them
i'm sorry, how do i do this? U mean i should write the data into an xml file, then manually use the xsl tool to conform it?
He who goes for revenge must first dig two graves.
|
|
|
|
|
Write to several XML files and then use XSL to form it into one.
|
|
|
|
|
Cumbersome. We've got little time for pilot mode so i guess i'll try it.
Thanx a lot.
He who goes for revenge must first dig two graves.
|
|
|
|
|
|
Thanx a lot. I think LINQ will help us achieve it.
He who goes for revenge must first dig two graves.
|
|
|
|
|
I have done similar things before using an sql data adapter. This produces a seperate file for xml schema though. I'm not sure if this is what your looking for.
SqlCommand cmd = new SqlCommand();
cmd.Connection = new SqlConnection(@"cnnstring");
cmd.Connection.Open();
cmd.CommandText = "SELECT * FROM Table1; SELECT * FROM Table2";
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
ds.WriteXmlSchema(@"C:\dat.xsd");
ds.WriteXml(@"C:\dat.xml");
cmd.Connection.Close();
|
|
|
|
|
how Access to the default page other Webhost
Example http://codeproject.com
Results defalut.aspx
Example http://byethost.com
Results index.php
Please Help 
|
|
|
|
|
Do you want to know what it will be called? Because you can't tell in advance. It could be "default.aspx", "index.html", "index.php" or something else, depending on the language it is written in.
Only going there will tell you - you can't determine the language in advance.
Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together.
Manfred R. Bihy: "Looks as if OP is learning resistant."
|
|
|
|
|
That's a setting of the web server. There, you can define a list of "default" pages which is searched up to the first match, which is then sent to the browser. Typically, you will not see in the browser which page was sent to you. But in case of server redirect, you will see it.
|
|
|
|
|
Thanks for your answer
I want to make a robot spider, not in my site on other sites 
|
|
|
|
|
In which case, by default, you don't need to know what the page is called up front - you can find that out once you reach the page. You hit the front page, and then start crawling out from that page. If you're hitting a site because you are following a link from another site, you could well find that you are in a page other than the default page anyway.
|
|
|
|
|
More tips
grateful![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
|
|
|
|
|
|
Just use GET / then. Remember to respect robots.txt instructions and meta headers!
|
|
|
|
|
Posting this in the correct forum might get you an answer faster.
".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
"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
|
|
|
|
|
Although he didn't make it clear in his original posting, it looks like this is the right forum as he's trying to write a web crawler.
|
|
|
|
|
Hi everyone!
I guess that's my first post on the site, but i ain't here for the first time...you guys've helped me many many times before what i'm really grateful for 
Now i have some problem which i can't deal with alone...
There is a camera connected to "Belkin hi speed usb 2.0 dvd-creator". I have a sdk for those devices written in C lang.
I need to display the video from the camera on a form in c# program, so i've imported the necessary functions from the sdk lib. It works fine, but...now i have to add some graphics on the view. Thing is, function that "displays" the video has a reference to a rectangle as one of three arguments (the rest is hwnd id and pointer to the device), so the only way to use the "live view" (with this function) is to point some defined rectangle. That would be ok, but i need to modify it...there is no (simple) way to get byte data of the video with this sdk.
I tried to use directshow to grab the video from belkin device, but the "live" view is "dead" after one second...even less. Guess there is something wrong with buffer management.
The only thing i can figure out now is to catch bitmap from the rectangle, add image and send it back, but there might be a huge loss of frames.
Do You know any way (or other way) of:
modifying such data displayed in a rectangle / obtaining video data from the belkin device ?
or
Do You know any kind of library that might be useful here? I guess there is some way to deal with the problem using directshow, but i am not familiar with it.
I've studied DXLogo sample from directshow samples but i still need to have pure data or compatible device.
I would be really grateful for any help
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
