Answer Questions

• luca82 Web Form ADO 'Where Clause' error on embedded quotes in variables

  I have a problem with a dynamically created 'where clause' when the user enters a search variable with a 'single quote' embedded in it. I've tried to incase the variable with chr(34) to no avail. The temp_surname below has an error when a name like D'Souza is entered. where_clause = where_clause & " Surname LIKE " & chr(34) & temp_surname & chr(34) oRS = cnnMeet.Execute("SELECT * FROM [Members]" & where_clause & " ORDER BY Surname, GivenName") The error page lists the line as follows; 'Select * From Members Where Surname Like 'D'Souza' Order by Surname, GivenName' Any ideas I've tried a number different options with the appendage of double quotes and nothing seems to ...Show All

• BuddyBoy2006 is this a memory leak?

  one of my customers put my program through the performance monitor, and found out that my application was eating up memory. my first thought was what GC GC!!! well, i guess it's possible. i've tried various profilers, including memprofiler and automateqa. the realtime monitor shows a zigzag pattern of increasing memory usage. my application communicates with a device through the serial port. i'm stressing the application by having constant stream of data coming in, and the app parses data and displays it to windows controls. now, if i just leave the application running, it will just keep eating up memory forever. however, if i manually call GC.Collect, i am able to retrieve all of the memory that it was eaten. now i'm confused, if ther ...Show All

• Territorial Musings Memory management for unsafe code

  Hi, It is known that Garbage collector does the memory management for managed code. i have a code that reads 1 billion rows of an event file (.evt). I m parsing each record of the evt file one by one using UNSAFE code. Due to a large no. of rows, my application used to crash, so i used GC .Collect(); & called it after some specific no. of rows have been read. My problem was resolved My question is who does the memory management for unsafe code Is it the garbage collector which i m calling. I m saying this because my memory mgmt problem was resolved after i added the GC.Collect statement.   That's *not* unmanaged code, just unsafe. The C# compiler cannot generate unmanaged code. The ' ...Show All

• Joshua Garvin When will x64 mixed mode debugging be supported

  I've found posts that indicate "Orcas Timeframe" Is this true and when will that be Thanks NIK OK, thanks for the info. This is the thread that I picked that idea up from http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=54877&SiteID=1     Unforunately, no. Visual Studio will not have x64 interop-debugging until after orcas. What sort of posts indicate that I'd like to correct the rumore before it gets out of hand. FWIW, some vague technical comments as to why this restriction exists are here . ...Show All

• Jonathan Allen Display autonumber

  I have a main form with an add new button that calls another form called frmNewBooking. My booking table has a primary key named bookingID that I want to display to the user every time he/she adds a new booking. Is there a way to display the generated bookingID in txtID on frmNewBooking when the form is 1st shown and everytime the user adds a new booking Note: Access DB used. Please do not refer me to: ms-help://MS.MSDN.vAug06.en/WD_ADONET/html/d6b7f9cb-81be-44e1-bb94-56137954876d.htm I just tested this, and it doesn't give me any problems. Just now, there was two records in my DB, with 73 and 76 respectively as my autonumber values. I deleted the last record (76) and re-run my app. and the ...Show All

• Alvin Kuiper webclient image upload

  I have a web application running on server A that allows users to upload files to server B. I use webclient to do so and it works very well from my dev pc to upload to server B. However, it doesn't work from server A. There was no error message or throwing exception. The file just didn't upload. Any idea Mariya, I have sent the 2 capture files over. Hope you got them. Try connecting to it and uploading a file from another machine (the same machine from which WebClient failed) but use another ftp client: for example the build in ftp.exe in Windows or a third party one like CuteFtp for example. If that succeeds then we have a problem and I'll ask you to get a net ...Show All

• sangminny Read .dbf files (DBase4) from .NET

  Hi! I have serveral .dbf files that i need open from my app. I can open it with MS Acces ... Could i open this files with OleDB I have view db4o , but i try it and ... although connect ... dont retreive any result in any query, and think that this software isn't for .dbf files xD Some idea Regards. Hi!   Your Dbase IV DBFs may be compatible with the FoxPro and Visual FoxPro OLE DB data provider, downloadable from msdn.microsoft.com/vfoxpro/downloads/updates . Use the "free table" option in the setup - just point the data provider to the directory where the DBFs reside. Thanks Cindy :) I will test it. Regards. ...Show All

• Syri Retrieving data from Excell 2003 - Could not find installable ISAM.

  I am trying to access some data in a Excel 2003 file and import it to a dataset using a oledb provider.Here is the code : string cnxString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=C:\\TEST.xls;" + "Extended Properties=Excel 8.0;"; this.excelConnection.ConnectionString = cnxString; this.excelConnection.Open();I keep getting this error :A first chance exception of type 'System.Data.OleDb.OleDbException' occurred in System.Data.dllSystem.Data.OleDb.OleDbException: Could not find installable ISAM.I have search everywhere there is a space between data and source. I have read the KB articles but nothing seems to be doing it. Any help would be greatly appreciated.Thanks. ...Show All

• donkaiser how to download a file ?

  Sir, I want to know that how to download a file from URL using C#.NET. I do a coding for the application about Download Manager,but at the time of downloading a file ie to save the file, the file is saved at its specified location ,but all files are corrupted. So tell me that what type of coding i can do in C#.NET. 1) I develope the application for download manager on a PC, on which XP Service Pack2 is installed. Sir the coding for the download manager i used is as follows private void button1_Click(object sender, EventArgs e) { WebClient client = new WebClient(); string name1 = saveFileDialog1.FileName; this.saveFileDialog1.InitialDirectory = System.Reflection.Assembly.GetExecutingAssembly().Location; this.sa ...Show All

• greenmonkey Excel Error in Save as Type...

  i had an application which exports an xml file to excel file, in this process no problem occurs and the process is done the way it is expected to..but when i tried to save the file in microsoft excel, the default save as type in the save dialog box shows html file..is there any way this can be resolved any help will be highly appreciated.. The question is about Excel not about "XML and the .NET Framework". You may find better help in Office news groups and forums. I tried to repro the behavior and by opening stylesheet in XML format and then calling "Save As" dialog. It offers me "XML Stylesheet" as default format. I use Excel 2003. I suggest you save your stylesheet in XML format by Excel ...Show All

• Can-Ann Com Exception is unhandeled while executing ExecuteReader

  hi i get following exception when i execute my code "COM object that has been separated from its underlying RCW cannot be used." code is as follow: private string conString; OleDbDataReader dr; OleDbDataAdapter da; OleDbConnection con = new OleDbConnection (); OleDbCommand com = new OleDbCommand (); OleDbParameter id = new OleDbParameter (); OleDbParameter name = new OleDbParameter (); public bool IsCompanyExist( string namee) { bool exist = false ; strOleDb = "Select strCompanyName from tblCompanyMain where strCompanyName = @strCompanyName" ; this .com.CommandText = strOleDb; this .con.ConnectionString = this .conString; this ...Show All

• Jacco Mintjes How to get ICorDebug being used by Visual Studio?

  Is there any way to do this (from add-in or macro) IcorDebug is too poor for that task too. Unfortunately, ICorDebug can't enumerate all objects in the target (although it's high on our Todo list). The Profilers (like CLR Profiler, Tutorial , Download for .NET 2.0 ) are much more suited for analysis of object usage across the managed heap. The best solution I've found is to use EnvDTE80.Debugger2.GetExpression2() to inject my code into the debuggee process. This way is a bit wicked, but it works :) I'm trying to dump values of all objects existing in the debuggee process. Unfortunately, EnvDTE API is too poor for this task. ...Show All

• rdeter Exporting to Excel using Response - Why so big?

  Hi, I'm using Response to export an Excel file, it's working fine, but the file size is huge: 28Mb. When I open it on Excel and click 'Save as...', the default format is HTML. Then, I change it to XLS format and save. Surprise: the file size now is 7Mb!! Any comments Code: Dim txtExcel as String = GetExcel() 'Returns a HTML table Response.Clear() Response.BufferOutput = False Response.Buffer = False Response.ContentType = "Application/vnd.MS-Excel" Response.AddHeader("Content-Disposition", "Attachment; Filename=MyHugeFile.xls") Response.Write(txtExcel) Response.End() If you have not upgraded to SP2, then do so, it will help greatly. Also, any type of special fo ...Show All

• Purusothaman A How to execute a Transact-SQL statement against a SQL Server database?

  I want to execute sql statements in my application, other then INSERT or DELETE , statements that would return not only the number of rows affected but also a messages from server. For example I want to execute: " use MyDatabase go BACKUP DATABASE MyDatabase TO DISK = 'd:\backup\MyDatabaseData.bak' with FORMAT, password = 'MyDatabasePass', mediapassword ='MyDatabaseMediaPass' go " and I want to have result like on server: " Processed 4592 pages for database 'MyDatabase ', file 'MyDatabase _PRIM' on file 1. Processed 424 pages for database 'MyDatabase ', file 'MyDatabase _WDATA' on file 1. Processed 768 pages for database 'MyDatabase ', file 'MyDatabase _INDX' on file 1. Proce ...Show All

• Khenat.Ram Console app as remotable object

  I thought I'd post this question here as I couldn't find a more suitable forum: I'm trying to run a console application as a remotable object but have realised that as a console app doesn't produce a DLL then I'm unable to add a reference to it for the remoting server. Is there a way to achieve this For code reuse, As mentioned in the last post, you can use a dll and reference it from both the console app and the service. If for some reason you have to spawn a console process, you still need to define a dll with the remote interface and link it to both the Console app and the service. Please look at remoting samples at http://samples.gotdotnet.com/quickstart/howto/doc/Remoting/quickstart.asp ...Show All