IvanHB's Q&A profile

• Visual Basic Performance diff Between vb and vb.net

  Hai, Can any one help me how to find the Performance difference between vb and vb.net for the same coding OR Can any one tell me, What is the performance diff between vb and vb.net Thanks in Advance The performance comparison depends on what you are trying to do. It also depends on whether you are using the .Net way of doing things or the VB way. One example would be the difference between FSO and System.IO for file manipulation. The best thing to do is to try several comparable methods and see for yourself the performance differences. One thing to note: Make sure to use the release build rather than debug build when ...Show All

• SQL Server Problem with numeric formatting

  I have a reports that use various sums to calculate totals. However if I enter this into the format field of textbox properties $#,###,###.##;($#,###,###.##) it gives unpredictable results. Some columns will format to 2 decimal places others will only format to the nearest dollar I though by explicitlty placing .## it would always go to 2 decimal places Cheers Damien C2 works great with currency, How about regular numbers without $ symbols ...Show All

• SQL Server Sending Database Mail

  Is there anyway to send mail through SMO, or any object model, or is the only way to send a message through Database Mail via sp_send_dbmail Thanks ...Show All

• Visual C++ Warning C4430 not being thrown in friend declaration

  class myClass ; class otherClass { public : otherClass ( int x ): valor ( x ) {} inline int sum ( myClass & obj ); private : int valor ; }; class myClass { public : myClass ( int x ): val ( x ) {} friend otherClass :: sum ( myClass &); private : int val ; }; inline int otherClass :: sum ( myClass & obj ) { return obj . val + valor ; } The above is a minimalist example to illustrate the problem at hand. Note how the friend declaration is not defining the return type of otherClass::sum() and yet Warning C4430 is ...Show All

• Microsoft ISV Community Center Forums VB code not working in Excel Macro

  The code below allows me to send an Outlook email with VBE. However, when I copy it into an Excel Macro, which is my objective, it does not work. How can I fix that (I have added the Microsoft Outlook Libray references): Module Module1 Sub Main() Dim theApp, theNameSpace, theMailItem, myAttachment, MessageBody, subject 'create a new Outlook Application Object, 'direct it to the proper NameSpace, 'create a new Mail Item and set the attachments collection theApp = CreateObject( "Outlook.Application" ) theNameSpace = theApp.GetNameSpace( "MAPI" ) theMailItem = theApp.Create ...Show All

• Visual Studio $ Dollar Sign in File Name

  Hello, Will the final release of VSS 2005 support dollar signs within file names.  I understand that VSS uses the $ as a special character, especially when it is the first character.  However, why can't a file named "CRCS$$01.DAT" be added to SourceSafe I have read newsgroup archives that indicate files such as this were supported in earlier versions of VSS, although not in 6.0d. Thanks. Hi David, There were some problems having files or folders with '$' character part of the name. The decision was that $ will not be allowed anymore as part of a filename. Same thing applies for '%' as part of ...Show All

• SQL Server SQL Server 2005 Express

  I have installed SQL Server 2005 Express locally on my computer and I've also tried installing some add-ons for simple database creation and manipulation rather than having to go through the command line.  The problem is I can't get the add-ons to connect to SQL Server 2005 Express.  Both programs are installed on the same computer and I have checked to make sure SQL Server is running.  I've tried both Windows and Mixed (Windows and SQL) authentication with no luck, but the errors coming back don't seem like it's connecting and just getting an invalid login, I keep getting errors saying it can't find the SQL server or the SQL ...Show All

• .NET Development Opening dBase file with extension other than .dbf

  Hi I'm trying to open a dBASE file with non-standard file extension using ADO and JScript. My code is as follows: var szDatabasePath = "C:\\Example\\"; var szConnection = "Driver={Microsoft dBase Driver (*.dbf)};DriverID=277;Dbq=" + szDatabasePath; var oDBConn = new ActiveXObject("ADODB.Connection"); oDBConn.Open(szConnection); var oRS = oDBConn.Execute("SELECT * FROM example#ven"); The output is as follows: C:\Example\Parse.js(14, 1) Microsoft OLE DB Provider for ODBC Drivers: [Microsoft][ODBC dBase Driver] The Microsoft Jet database engine could not find the object 'example.ven'. M ...Show All

• SQL Server Using MS Access 2003 Project with SQL Server 2005

  I continue to receive an error that states "The version of Microsoft Access doesn't support design changes with the version of Microsoft SQL Server your Access project is connected to. See the Microsoft update website for the latest information." I'm using Access 2003 that I ran a database through the Upzinging Wizard with a copy of SQL Server 2005. I have searched the Office Update pages and can't locate anything that helps, although I'm sure I'm probably missing something. Any suggestions Thanks in advance, Mike Duke Bill, Mike , I have similar related problem. I am using MSSql Express 2005 (I uninstal ...Show All

• Visual Basic How do I execute a form "FORM.VB"?

  How do I execute a form "FORM.VB" Michael yes great code dude iam a total newbie to thiss hehe :p is it also possible to open a forum but then not a new window well yes a new window but i can also click the other window now is there a way to open a new window and then disable the other window thanxs alot ...Show All

• Visual C# What is the use of "STTBF".

  Hi, Can any one tell the use of " STTBF ". What do you want todo, is STTBF a library, class, dll Normally STTBF stands for String Table stored in File it is just a file format. ...Show All

• SQL Server Disconnecting from engine does not closes database

  I connect Managment Studio to MSDE 2000SP4. Open database, open some object, then disconnect from engine (not simple collapse DB objects). In other programm try to drop database. Until you don't close MSSQL MStudio, database is in use. In older version collapsing DB objects in tree closes DB. Hi! I don't have access to MS from 2000SP4, but I can tell you that MS in SQL2005 have Disconnect command in context menu of the server node. I think this is what you need. ...Show All

• Microsoft ISV Community Center Forums Help with the application-defined or object defined error

    I am fairly new to programming I have a command button 1 in the spreadsheet however I keep getting an error message application-defined or object defined error.  I am not sure what this error means. What I want to do is set ninterval, rbedradius and xinterval to cell values shown below. I want to use a for loop and apply calculations. Later (not yet coded) want to put a condition on the third column of formulation. How do I get around this. Please give comments on how to improve my programming.   Private Sub CommandButton1_Click() Dim ninterval As Integer Dim rbedradius, xinterval, oneD As Long ...Show All

• Visual Studio Express Editions Is there a Visual Studio 2005 Express Edition?

  I was wondering if the free beta versions had a Visual Studio Express Edition where all of the other Express Editions could be used in one program instead of opening each one separately for each different code language So, I am to assume that the Express Editions will not integrate.  It's all fine, I very much plan to purchase Standard Edition anyway; however, only being able to currently install Express Edition Beta, it's been a bit hendering, considering I am working on a solution containing both C# and VB.  Honestly, all I need C# for is building and debugging, as I'm only coding a VB section o ...Show All

• .NET Development Using SerialPort class with win32 com handle coming from TAPI

  Hi, I've made serial and modem communication with .NET 1.x using a class implementation that uses PInvoke to drive the serial port; I've used also TAPI to drive the modem. The file handle coming from TAPI method "lineGetId" is passed to my SerialPort implementation class, so I can read and write data to the remote connected modem. Now that .NET 2 has its SerialPort implementation, how can I pass to it the file handle to do the modem communication Is there another metodology to do this thing Thanks, Alfredo ...Show All