Answer Questions

• obsid How can I save dataset as an xml file???

  Hi I am trying to save the dataset as xml file (one row from the table).Saving xml is fine but it look like the following (the below is flat xml file without root nodes and child node) But I want the data to go under xml Root Node, child node, children node and so on. My question is How can I save the dataset as xml file with Root Node, child node, children node and so on Please help !!! Urgent!! < xml version="1.0" standalone="yes" > <MS> <SDLTID>1</SDLTID> <UTRN>303783jMJ</UTRN> <TransPropertyType>01</TransPropertyType> <TransInterestCreated>FP</TransInterestCreated> <TransEffectiveDate>2006-04-05</TransEffectiveDate> and so on..... ...Show All

• Chayodyn Problem in calling .vbs file and getting output

  I am using System.Diagnostics. Process class to call a vbs file and want to get out put from that file(whatever it echo on standard output) from a code behind of an asp.net 2.0 application. Code is: System.Diagnostics.Process p = new System.Diagnostics.Process(); p.StartInfo.FileName = this.Page.MapPath(this.ResolveUrl("Script/ALI.vbs")); p.StartInfo.UseShellExecute = true; p.StartInfo.RedirectStandardOutput = true; p.Start(); p.WaitForExit(); System.IO.StreamReader sr = p.StandardOutput; txtComments.Text = sr.ReadToEnd(); Now the problem in above code is that if I set UseShellExecute = false , it says on executing Start() that its not a win32 application. OK if I set UseShellExecu ...Show All

• _hunter Computed Columns in TableAdapters

  Hello, I'm very frustrated with the TableAdapter created by the dataset designer in Visual Studio 2005. Here's my problem: My select statement is just a select * from X. Some of the columns are computed columns, and should not be included in the update or insert commands. However, they are. I can't seem to get it to not include these columns in the update and insert commands without removing them altogther. This problem did not exist in 2003. Any advice Thanks, Bryce Hi, If I am not misunderstood your question then what you want to do is auto update to database using dataset. If this is the requirement you can update the insert and update statements of adapter so that whenever datase ...Show All

• sridhar kumar.j How to access COM interface of a running C# program?

  Hello everyone, I am trying to access the COM interface of a running C# object. Is it possible to do so I can create a new instance of the object with objNameVettLateBound = Activator.CreateInstance(objTypeNameVett); and call the exposed methods of that object without a problem. I was wondering if it was possible to grab an already running instance of that object Thank in advance. Guessing a bit: you'll need to associate the object you get with an instance of a Runtime Callable Wrapper so you can use managed code to call the COM interface methods. Try using Marshal.GetTypedObjectForIUnknown(). If that works, you shouldn't need reflection anymore either... Google for " Running Object Tab ...Show All

• Wesley Wong Memory managment with extern

  I am using an extern method in my code. The method gets a string and decrypt it in a buffer and return it to me as string. My question is since this is a static method that returns a value ,how does the method relese the buffer from memory because it can't release it before the return and can't after Thanks Avi Hi, did you write that function If yes, change it to get preallocated buffer and the length of that buffer and have it return the number of bytes written to that buffer like so: size_t yourConvert(const char* in, char* out, size_t cbOut); If it is a function of a library the library should provide you with a function to free memory which it allocated internally. See its do ...Show All

• Sammy32 How to hook SqlDataAdapter to a SqlConnection

  I have a bunch of files with tabular data in them. The files are of a proprietary totally non-standard format. I'm trying to move the data from the files into an SQL database. Each file will reside in a separate table in the database eventually with the table name set to the name of the original disk file and the field names and types all determined at run time. I created a class that loads files off the disk, creates a dataset with a DataTable for each loaded file in it, and stuffs the dataset tables with the info from the disk files. During this process the field names and datatypes are determined, keys are applied and foreign relations applied to the dataset also. This part works fine and I am able to view the dataset using ...Show All

• testorp Initializing Arrays

  If I create an string array should I initialize it whit String.empty or there is not performance and memory issues if I dont initialize it Kenny kymaita wrote: If I create an string array should I initialize it whit String.empty Only if that's waht you want the values to be, and you're not happy with the default value (null). kymaita wrote: or there is not performance and memory issues if I dont initialize it Explicitly initializing the elements will be slower than not doing so. Lepaca wrote: The results are substantially equals... Well I don't see any use of arrays in your code so I'm not sure why that is relevant. Your code is simple enough to b ...Show All

• cwlaualex Import Data from Sybase into a Recordset

  Hello,   I'm trying to import Data from a Sybase Database with a VB 2005 Application. Everything works fine, the only problem is, i receive wrong data  out of Datafields which contain the style money (Currency). Trying different version of code as follows:  Dim Price as Decimals = rs1a. Fields( "NW_Cur_PreisBrutto" ).Value Dim Price as Double = convert.toDouble(rs1a.Fields ( "NW_Cur_PreisBrutto" ).Value) Any Ideas what's wrong thank you, for taking time and give me a hand. Wolfgang   Zlatko, thx for your help. the latest MDAC was allready installed on my machine. The only thing i can do now is search for another OLDEB provider Wolfgan ...Show All

• bxchan Web Service Proxy Support in the .NET Framework 2.0. Problems Resolving Host Name. .PAC

  We have an Proxy Auto-Configuration (PAC) file that uses the isInNet function to determine if the current request should be directed to our proxy server for external requests or be a direct connect if connecting to an internal server. We have a .net 2.0 client application that makes a call to a webservice. If the webservice’s url is configured with the host name (http://WebServer/WebServices/simple.asmx) we get an “The proxy server could not handle the request” error message. If we configure the webservice url to use the IP address (http://169.12.50.5/WebServices/simple.asmx) the webservice call works fine. If we remove the configuration for the .PAC file on the client machine both urls will work for the ...Show All

• erick_the_redd Serializing a DataGridView component

  I have a DataGridView displayed on my GUI that I manually populate (i.e., there is no ADO.NET involved). How can I easily persist the data that I place in it when the app closes and repopulate the grid with the persisted data when the app opens thx in advance, todd The method outlined in the link seems kind of complicated... All the data stored in my grid is computed. I don't have any business objects nor binding objects. It seems like a waste of resources to loop thru all the cells in the grid, get each cell value, copy it into an instantiated class (that I don't need), copy the object to a generic list (that I don't need), and then call the serialize method on the generic list. What I want ...Show All

• Ron A. Buckton How to connect to a SQL Server Database using VB.NET

  How do I connect to a SQL Server Database using VB.NET code You need to use SqlConnection class for it. Here are some examples how to connect to and work with SQL Server from VB.NET http://support.microsoft.com/kb/308055/en-us http://support.microsoft.com/kb/306574/en-us ...Show All

• KarlShare Trouble with attaching data into a database

  I have just started using Visual Studio and I am trying to program an application to send information to a SQL database. I keep getting this error message and cannot figure out how to fix the problem: System.Data.SqlClient.SqlException was unhandled Class=20 ErrorCode=-2146232060 LineNumber=0 Message="An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)" Could someone please help me fix this error Thank you, Anthony Ostrem ...Show All

• Dedy Susanto is guaranteed message delivery possible in .net remoting?if possible how?

  any vb.net sample codes regarding certified messaging in remoting... Well, no. People have built channels over MSMQ to achieve something like this ( http://www.codeproject.com/csharp/msmqchannel.asp ). There is also reliable messaging in WCF. ...Show All

• steff111 Is this a bug , any one can tell me?

  I found a bug when I am programing: when I use like this: " ".IndexOf(" ") is returns -1,when it should return 9; but " ".IndexOf(' ') is OK. and belows all worked well: " ".IndexOf(" "); " ".IndexOf(" "); " ".IndexOf(" "); My environment is : Windows XP SP2(English Edition + Mutil-Language Pack) + .NET Framework v2.0.50727+Visual Studio 2005 PS: It works well in javascript. Maybe it's because I'm french and I misunderstand a bit your answer. Could you please provide a walkthrough of what happens in both cases: with '' versus with "". Thanks. I do, though in the opposite way than this thread originally reported it (since the claim then was that returning -1 was th ...Show All

• Eric66 datetime insertion problem

  i'm using sql server 2005 under asp.net 2.0. when i try to insert values of table columns , i get the error : {System.Data.SqlClient.SqlException: Incorrect syntax near '.2007' when i debug the sqlQuery, i see it is : INSERT INTO ASILTER_INBOX (tarih_saat,kimden,kime,konu,govde,atac,okundu,silindi) VALUES (16.02.2007 17:44:18,'ALISNMZ','ASILTER','Naber','OOo o 0o0 o OO oooo!','','false','false') the tarih_saat column is datetime at the database. could anyone reply to me, i need a quick help. thanks. You may need to change your date format and you definitely need to encapsulate your date values in single quotes, like this: INSERT INTO ASILTER_INBOX (tarih_saat,kimden,kime,konu,govde,atac,okundu,silindi) VALUE ...Show All