Answer Questions

• RichCa returning xml from a sqlcommand stored procedure

  I'm executing a sqlcommand through a dataadapter to fill a dataset. I want to return my results as xml and it's working, but it has a <Table> entry for every record it returns. Is there a way to change this to some other tag name Thanks. When you call DataAdapter.Fill there is a second parameter that sets the table name, you can name it anything you want: myAdapter.Fill(myDataSet,"MyTableName"); That was it! Thank you very much. ...Show All

• msebald XSLT problems with "cdata-section-elements" and "omit-xml-declaration"

  Hi All, Sorry, this is cross posted from the SQL server reporting services forum here: I'm using some xslt documents to transform the xml output of my reports in sql server 2005 reporting services, but have come across two curiosities where the xslt filter seems to behave unusually. Firstly, I need the final saved file to have an xml declaration, which I believe it should do by default. Even if I put omit-xml-declaration="no" in the xsl:output tag I don't get an xml declaration. At present we have a custom job that writes these declarations back into the xml after SRS has saved it. Secondly and more importantly, I need to have some of my output tags wrapped in CDATA sections. I've tried using the ...Show All

• Bryan7 send POST with certificates for ssl

  Hi, I want to send a POST request to a webserver. I want to attach a certificate to the request so that it can be posted on a https site. After this POST the server will send a response, I want to be able to view that response. Any idea how to do it http://support.microsoft.com/Default.aspx kbid=895971 There are a lot of threads about this and what can go wrong. Anyone Here is my code: I got this error: Unhandled Exception: System.Net.WebException: The request was aborted: Could not create SSL/TLS secure channel. I think the certificates are not added correctly...Hope somebody is able to help me! Dim cert1 As X509Certificate = ...Show All

• Dycker There is an error in XML document

  We are getting the error while calling the webservice of the Remote machine the decription of the error is: There is an error in XML document (1, 147611). at System.Xml.Serialization.XmlSerializer.Deserialize(XmlReader xmlReader, String encodingStyle, XmlDeserializationEvents events) at System.Xml.Serialization.XmlSerializer.Deserialize(XmlReader xmlReader, String encodingStyle) at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) at System.Web.Services.Protocols.SoapHttpClientProtocol.InvokeAsyncCallback(IAsyncResult result) InnerException -->System.Xml.XmlException: Unexpected end of file has occurre ...Show All

• Zath Error while unloading appdomain. (Exception from HRESULT: 0x80131015)

  hi, I am using Wiascr.dll in my project.According to my need it open a device selecting dialog box on client copmuter.It is running fine in vs2005 which use built -in web server.But when i run it on IIS. It give a following error at 5 to 10 mints. Error while unloading appdomain. (Exception from HRESULT: 0x80131015) System.CannotUnloadAppDomainException was unhandled Message="Error while unloading appdomain. (Exception from HRESULT: 0x80131015)" Source="mscorlib" StackTrace: at System.AppDomain.Unload(AppDomain domain) at System.Web.HttpRuntime.ReleaseResourcesAndUnloadAppDomain(Object state) at System.Threading._ThreadPoolWaitCallback.WaitCallback_Context(Object state) at System.Threading.Execut ...Show All

• QuantumMischief SqlBulkCopy.WriteToServer - more details from InvalidOperationException?

  Hi, I have a dataset with 100,000 records and 50+ columns. I am trying to bulk insert it using SqlBulkCopy. The data is originally coming from a text file and is parsed to the datatable. With a text file with 50 records, it works fine. But with 100,000, bulkCopy.WriteToServer() is throwing an exception, which looks like this: The given value of type Decimal from the data source cannot be converted to type decimal of the specified target column. So there is a problem with data truncation I am assuming... but HOW do I get more details on this What column and what row is causing this error Without this information, I'd go crazy trying chunks of this huge file untill I found the culprit and changed my format appopriately.. I ...Show All

• Frederik Vanderhaegen CSV Data

  Hallo, I want to create a comma seperated file of columns with specific length. How can i specify the length of each column and may be also define the type of the data. regards swingme A small issue with Nightmare_BE 's sample is that this doesn't append a new line at the end of each record. The following sample would do this: using (System.IO.StreamWriter writer = new System.IO.StreamWriter("data.csv")) { foreach (Record record in Records) { string line = string .Join(",", record.Values); writer.WriteLine(line); } } Yes, but as i readed the post he wants to write data using fixed le ...Show All

• Meadensi VB app stopped working when Iexplore 7 installed

  The following VB code used to work fine until Internet Explorer 7 was installed in Terminal Server running on Windows Server 2003: Dim ieProc as New Process ieProc.StartInfo.FileName = "iexplore.exe" ieProc.StartInfo.arguments = szHtmlPath ieProc.Start() tipically szHtmlPath = "templates\PickList.htm#12299#10:30 AM" please respond, produccion stoped. Thank you in advanced, Rafael. We have a very similar situation. Our application uses RoboHelp WebHelp. The generated javascript relies heavily on the location.hash data. Since installing IE7, it has stopped working. Location.hash is always empty. We have tried everything, but there appears to be no way around this! Other internet browsers work fine, but t ...Show All

• Simonsbs ftp sockets in c#

  hello sir, iam using ftp server(c#), thru my client ftp program is connected to remote server ftp. but iam unable to access like listing files in the remote host, uploading and directory creation and removing . Is that do we need any permissions for doing above operations. no iam not getting any error. i was written ftp client program in c# console application. it is not listing the file in the remote host What class of .Net are you using FtpClient Are you getting any errror And wheres your code You asked 1 question I asked 3 from you just to understand your problem . Best Regards, iam not getting any errors , but, it is unable to list the fil ...Show All

• enric vives Query an online database?

  Ok I am trying to write a program that will grab a list of all the AddOns that I have installed for World of Warcraft and then it will query at least one of the UI websites to see if a newer version is out and if so download it and wait for me to install it. My question is how can I get the information about the addon from the net I have read about Web Services a little bit and after search 2 out of the 3 I have found no documentation about a web service at all. Is there another route I can take Ok I will research that, but I have one more question. the three websites I am trying to use are wowinterface.com, ui.worldofwar.net, and cursegaming. So how can I find out if their website supports the XML feed ...Show All

• Jamie Thomson Updating Adds the same record to all rows in the Database instead of just one?

  Hello. I'm trying to update a single record in a database to add new data, but when I hit my update button and the event runs, it adds that record to ever record in the database overwriting the current data in the database. I'm not sure how to work around this problem. Any help would be greatly appreciated. Thank you. But if there's nothing in the record to compare then how do I use the where clause What I'm trying to do is add the record then save it to the database. So when I click my add button it adds a blank record. Then I entred the data and hit the update button to save that data to the database. I'm not sure how to use where when the new record is blank. You lost me on this one. Adding to the ...Show All

• Mekki Auto start PC application once HID attachment is detected

  Hi, I am developing PC communication program using MS Visual C# which communicates with USB HID device. Program is working but I wanted to change such that when the hid device is attached on the PC my PC communication program will start automatically. I would appreciate If anybody can give any useful information to get started with this. Thanks Michael, those were very useful topics for me to start with. Just to make sure i am going on the right direction: So, I have to write a VBScript which on each Win32_DeviceChangeEvent will query Win32_USBControllerDevice and Win32_PnPEntity and then know if my device is connected by comparing the DeviceID and then start my PC program (that i intended to ...Show All

• AnthoDesigns Best Practice: Activity status

  I'm back again! For me this is a bit hard to grasp/tackle. My application has a UI and several other classes. I know that no class should interact with the other if its not needed, which is fine. I know about these things. If I have a class doing some work (not the UI), I want to be able to notify the UI of the status/activity that is going on in this work. Is it correct for me to say that I should create events which would be raised from this class, so that the UI will catch it and display the status to the user Obviously this "work" class knows nothing about the UI class, nor does it need to. All it needs to do is its work and then display the status of what its doing, wherever this status is displayed is none ...Show All

• novastar22 how to calculate remaining time when downloading a file

  Can any one give me a code in C#.Net to above question. hi i m developing an application for downloading a file from internet,so i want code in c#,for to find remaining time and download a file from internet. Please give the solution ,or if possible then send me code in c# for to calculate the remaining time when download a file See WebClient class in MSDN, See its function DownloadFileAsync and hook an handler to ProgressChanged event and calculate the estimated remaining time based on % completed in how much time, how much bytes have been transfered in how much time. So now you can do some estimation on what may be the remaining time. See MSDN for more help on WebClient class under System.Net namesp ...Show All

• rajshekar XML Serialization of Custom Classes and Web Services

  Hi All. I am stucked with xml serialization. I am having one custom class and one Web service which is having one web method to return instance of my custom class. But when proxy class is created for my web service, properties of my custom class are not exposed as properties but are exposed as fields. My custom class looks like this: <Serializable()> _ Public Class Trade public m_TradeId as integer public m_TradeName as string Public Property TradeId() as integer get() Set() End Property Public Property TradeName() as string Get() Set() End Property This class instance is returned through Web service web method. But the proxy which is generated for the webservice is not exposing Propert ...Show All