Answer Questions

• Tom Morris How do you fix the error "Syntax error in UPDATE statement"?

  Guys, I need your help to fix this error since it's been bugging me for 2 weeks already to find a solution in the internet or book that won't work properly.  I tried fixing the update statement command but still shows the same error. Below is the source code: Public Sub changePassword( ByVal uName As String , ByVal pWord As String ) Try 'change the user's password Dim conn As System.Data.OleDb.OleDbDataAd ...Show All

• Ben Pryor Why does SqlDataReader implement IDisposable...

  ...when its Dispose method is private I assume there's more to this than meets the eye, but what is the point in implementing an interface with only one member and then hiding the member Doesn't that defeat the purpose of implementing the interface I've tested calling     CType(MySqlDataReader, IDisposable).Dispose and it closes the reader and also closes the connection if I specified that CommandBehavior when I called Ex ...Show All

• MSMC List Folders in ListBox??

  I wanted to know if someone could get me on the right track.....What i want to do is i want to list some folders in a listbox and when the selectedindex changes it shows the files in the folder in another listbox.....Any help on where i can get started...... Add two ListBox controls on your form, one lbFolders one lbFiles Populate your Folders listbox in your constructor(or on load or whever you want it initialized) like so: public Fo ...Show All

• Mainiac007 Tcp buffer

  Hi, Client applications for my application are sending about 1500 short messages/second via Tcp sockets (local sockets, I mean on local host). Besides, my application is running on more than 60 PC, routing commands also via Tcp sockets. I fight againt my colleagues (programmers of these client applications) asking for using ACK but they did'nt want. So, I rely on the Tcp buffer and read (and handle commands) as fast as I can this Tcp stream. Wh ...Show All

• MikeAtOpco How to use System.Net.Mail.SmtpClient via SSL and Authentication?

    Below is my code, and is just blocked there. There is no any error message. '=============================================>         Dim msg As String = "---"         Try             Dim strAddress As String = " xxx@xxxx.com "             Dim s ...Show All

• robbrianius CDO.Message failure when email username contains trailing dots

  I have a SQL2000 SP3 server and a stored procedure similar to this: CREATE PROCEDURE Usp_SendMail @To varchar(100) = '"Administrator"<hi@test.com>', @From varchar(50) = '"Server"', @Subject varchar(50) , @Body varchar(1000) , @Format int = 1 AS DECLARE @object int, @hr int EXEC @hr = sp_OACreate 'CDO.Message', @object OUTPUT EXEC @hr = sp_OASetProperty @object, 'To', @To EXEC @hr = sp_OASetProperty @object, 'From', @Fr ...Show All

• rcodyr Exception: Unable to read data from the transport connection

  Hi, We've written code in C#.Net (Microsoft .Net Framework 1.1) for a Windows service to download the .csv files from different sites over GPRS connections through FTP. The Service runs on mulptiple threads to connect to multiple GPRS modems (as of now we are using 3 GPRS modems/connections) to collect the files from different sites at the same time. It all download files and works fine for some time. But later after some time any one of t ...Show All

• Raiden_S Is this a bug of ASP.Net 2.0 ? when I use relative paths in SqlXml class!

  Is this a bug of ASP.Net 2.0 when I use relative paths in SqlXml class! I can run Part 1 correctly in ASP.net 2.0, but when I run Part 1, I get the following error, why Is this a bug of ASP.Net 2.0 Could not find a part of the path 'C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\~\App_Data\InitializeBookmark.xml'.   //--------------Part 1------------------------ DatabaseBase myDatabaseBase = DatabaseHelper.GreateDatabaseOject(); ...Show All

• Joe Sango Socket crashes on AccessViolationException when the peer side aborts (net2.0 beta2)

  Hi,   I experienced a weird problem with socket on my machine. On my colleague's it works like a charm.  When I have socket, waiting for incomming data (after I called BeginReceive) and the peer side aborts - eg. I kill the telnet.exe who I used as a client, the socket throws AccessViolationException on unknown module. The crash itself is in > imon.dll!20b0cd39()   did anyone experienced something similar, or it' ...Show All

• G.Lakshmi How are interpreted . and , in numbers in XML and in .NET ?

  hello, i would like to know if this is "XP Regional Settings" dependent thank you Normally numeric data is stored in a region-independent manner in XML.  The .NET frameworks provide an XmlConvert class that does the string to/from data conversions for you. ...Show All

• Dave the Zionist Moving database table details to a table in my application

  Hi, I have a problem, i want to move the information of the tables such as the fields and constraints and every related information to a local table. i am to the use that local table in my application. so the details from the database should be exactly matched. This must be working with any database. There should also be an edit option to set the relationship manually (Eg. to set the foreign key relationship manually). can anyone help with ...Show All

• globim Unmanaged code to managed code

  Is there any way to convert unmanaged dll to a managed one Hi Johansson, I have got a COM dll that I need to use in my .net application. I was looking for a way to avoid the overhead of marshaling/unmarshaling. If it is becoming a serious problem with marshaling you can rewrite the COM class to not be so chatty and require less calls to do what it need to do. If you have ...Show All

• RobertHernandez Odd generic list problem

  Ok, here's a very strange problem that I encountered today: List<OptionQuote> cache = _optionQuoteCache[q.Quote.Fundamentals.ExpirationDate];                                      OptionQuote prev = cache.Find( delegate (OptionQuote quote) { return (quote.Sym ...Show All

• alka mehndiratta Convert C# to VB

  Hi Could someone convert if (iMessage.Substring(i,1).Equals( "a" )) { tmpString+=(( char )29).ToString(); } to VB.NET /nOrphf Hi, Code in VB.NET If (iMessage.Substring(i, 1).Equals( "a" )) Then       tmpString += Convert.ToChar(29).ToString() End If   Regards, Vikram Hi, I ran the code in C# and VB now and I get the same output in both cases. I ...Show All

• zoomkat Help on what's the best way to accomplish the following...

  I like to define a standard behavior to create a plugin entry point in my project (C#, .NET Framework 2.0).  Since I can't find any reference to create a .NET DLL assembly entry point (Like the DllMain in C++); so I assume it doesn't have a global entry point.  My first shot at it is to try using custom assembly level attribute.  The goal of this is to enforce a certain way to create plugin in my project. So defined ...Show All