|
I am wanting an XML output from a query of an SQL: database.
My initial idea was to do this via a dataset... but I wasn't sure if .NET or MSSQL had some whizz-bangery built in that alowed you to get XML direclty out of XML?
Any suggestions on the best method of achiving this ?
|
|
|
|
|
|
Depends on your usage. You could use a simple FOR XML cluase on your query. If you wanted to control the output based on a schema then it gets a little more difficult. I think using a DataSet would be the easiest to implement though. Again depending on your usage.
|
|
|
|
|
Hello, I have a big problem to print an html file directly to the printer. I
use an "AxSHDocVw.AxWebBrowser" object. Briefly, this is my code:
AxSHDocVw.AxWebBrowser myBrowser;
...
//this set of instruction prepare my document in html to be printed
string HtmlFileName = "Test.html";
Object o = new Object();
o = System.Reflection.Missing.Value;
myBrowser.Silent = true;
myBrowser.Navigate(HtmlActualFileName, ref o, ref o, ref o, ref o);
// when it is ready the callback goes here
private void myBrowser_DocumentComplete(object sender, System.EventArgs e)
{
myBrowser.ExecWB(SHDocVw.OLECMDID.OLECMDID_PRINT,
SHDocVw.OLECMDEXECOPT.OLECMDEXECOPT_DONTPROMPTUSER, ref o, ref o);
}
When i call it (ExecWB) it generates an exception "Trying to revoke a drop
target that has not been registered".
Someone know how I can solve this problem, or if there is a quicker o
simpler method to solve it?
Thank you,
Regards,
SD3
|
|
|
|
|
Hi!
All I want is to create a BHO (Browser Helper Object) which among the other things it does, it displays something onto the IE's statusbar. The problem is how to access the rest fields of the IE's statusbar.
IWebBrowser2 gives only access to StatusText which is the first field from the 7 (as I can see in my IE).
I want to add a small icon to a statusbar field and when clicked do some stuff.
thanks,
eLefas
-- modified at 5:27 Tuesday 18th July, 2006
|
|
|
|
|
Hi!
I've got a windows service that can be configured to use an access DB (for smaller installations) or a SQLServer DB (for larger installations).
The problem I'm facing at the moment is that usually after a (re)boot the SQL Server service isn't up and running completely at the moment my service is started.
Since my service is checking some values from the database on statup, it's choking regularly because SQL Server hasn't started my database yet.
Is there a way to influence the order in which services are started?
I've already tried to set my service's dependencies to make it depend on SQLEXPRESS, but to no avail. Looks as if SQLEXPRESS is already started, but my database hasn't been started yet.
Setting the options to restart the service after a failure doesn't work either - it only restarts the service when I shut it down via taskmanager for example, but not if the initial start of the service failed because the database wasn't available yet. 
The problem occurrs with SQL Server 2005, I couldn't experience this behaviour with SQL Server 2000. Seems as if SQLServer 2000 started faster so the problem couldn't arise.
Any other idea what I could try?
Regards,
mav
--
Black holes are the places where god divided by 0...
|
|
|
|
|
Here's a snippet of some code I use to make sure sql server is running (actually msde, but same diff) locally ... maybe it will help:
private void CheckLocalDBService()
{
ServiceController[] services = ServiceController.GetServices() ;
foreach ( System.ServiceProcess.ServiceController cont in services)
{
if (cont.ServiceName.ToUpper().CompareTo("MSSQLSERVER") == 0)
{
SplashScreen.SetStatus("Found SQLSERVER service") ;
if (cont.Status != ServiceControllerStatus.Running)
{
SplashScreen.SetStatus("attempting to start SQLSERVER service") cont.Start() ;
cont.WaitForStatus(ServiceControllerStatus.Running,new TimeSpan(0,1,0)) ;
if (cont.Status == ServiceControllerStatus.Running)
{
_hasLocalMSDE = true ;
SplashScreen.SetStatus("SQL Server Service successfully started") ;
}
}
else
{
_hasLocalMSDE = true ;
}
}
}
}
|
|
|
|
|
Thanks, I'll try this approach.
I thought adding a dependency from SQL Server to my service would eventually have the same effect, but unfortunately, this didn't work. The SQL Server Service had been started before my service was started (the event log entries prove this), but my database wasn't available yet... 
Regards,
mav
--
Black holes are the places where god divided by 0...
|
|
|
|
|
Hi,
I would like to know if it is possible to save a hashtable or an arraylist in the settings file?!
Thanks
|
|
|
|
|
May i know why u need this.
instead of u can serialize the hashtable object into some XML. and deserialze it whenever u need it.
|
|
|
|
|
Yes, you're right. But I wanted to use the settings file, because I already used it for other user settings and I thought it would be simplier to use only one config file!
|
|
|
|
|
A specified logon session does not exist. It may already have been terminated
this is the message that I am receiving when I am trying to map the other server. What usually is the solution or workaround for this one. I am stuck with it.
Any advice or ideas will help a lot.
Thanks
Dabuskol
|
|
|
|
|
Hi, all!!!
I created a simple WebBrowser, and now I need disable right mouse clicking, copy and select text in this WebBrowser.
If somebody knows how do it, please help me...
Thank's
|
|
|
|
|
Chek if there is a context menu property associated with the browser control. If yes, set the context menu property to null.This will disable right clicks
|
|
|
|
|
hi all,
my local ip is: 10.0.0.9 which i can find easily with reading some documents.
but i want to find how i will learn my outer ip ? (the ip i used when i surf the internet which is: 81.215.85.166 for my pc)
thanks in advance,
bye.
|
|
|
|
|
First of all never post valid ip addresses in the public domain, it can lead to some nasty things.
Since your using an router you'd have to either connect to the router and read the ip address from there or use a web site such as MyIPAddress.com to find it out.
You'd have to use an HTTPWebRequest to get the information, and then weed out your IP.
Unless anyone knows of a different way.
|
|
|
|
|
Look for a network class DNS. some of the methods are gethostbyname etc. You'll see one in there for retreiving your ip address.
|
|
|
|
|
Hi All!
Do you know about Multi Monitors.
I have a card Video have multi TV outputs.
I want to use only one PC to display to TVs.
pls, show me your solution.
Best regards.
---------------
I Don't want say no wealth.
|
|
|
|
|
|
Oh, Thank, I'm C# Developer.
I need a solution for my problem.
I want to write A software to control data thay display to Screen of TV by Card Convertor.
|
|
|
|
|
You need hardware, not C#.
|
|
|
|
|
No, I don't need hardware, I had hardware, But I have never software. Now, I have to develope a software. Do you know it. pls, send me source code if you have.
Thanks for your help.
Best regards.
|
|
|
|
|
Hello,
I have a problem with the SerialPort Control under VC# Express 2005.
In my application I have to read data from an external device through RS 232.
The process is built on a software-based handshaking which depends on the device.
The process has been implemented by me and works but unfortunately only the first time.
All data are donwloaded successfully as required.
The process is simple serialPort11.Open(), Handshaking, Data Download, Handshaking, serialPort1.Close().
The problem occurs with the second run, when the same procedure is executed again (using a button_onclick event), then the Port is opened again with serialPort1.Open() and with the first serialPort1.readByte() a TimeOut Error occurs.
Even if the Timeout is set to 10sec it does not help.
If the application is restarted and the process is again executed, then the data are read perfectly from the device. Hence it does not depend on the state of the external device, but on the PC (Soft and/or Hardware).
I have the feeling, that closing the SerialPort with serialPort1.Close() does not free all resources and possibly the hardware RS232 is not fully reset.
Has anyone had a similar problem and found a solution for it?
Can you rely on serialPort1.Close()? Are all resources freed?
I hope someone can help
Thanks a lot in advance
Best regards,
Carsten
|
|
|
|
|
Is there really no one who has discovered the same problem? 
C.
Regards,
Carsten
|
|
|
|
|
Hello Friends,
An unhandled exception of type 'System.NullReferenceException' occurred in Unknown Module.
Additional information: [Resource lookup failed - infinite recursion detected. Resource name: Arg_NullReferenceException]
Has anyone come across this ?? I am working with a GDI+ user control where i do a bulk of drawing, say atleast 500 MB of data. This drawing is performed in a seperate thread from the main control thread with proper interruption techniques to stop drawing in between.
The problem am facing is, it works perfectly in Win XP environment, no issues. When it comes to Win 2000 the above mentioned exception pops in regularly when i try to interrupt the drawing thread.
can any help me out of this?? Even some clues will be a great help cos the error doesnt give any clue 
Hariharan.T
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
