Mariant's Q&A profile

• SQL Server Is there a function like SUBSTRING but for integers?

  I'm wondering if there is a function in SQL that works like SUBSTRING function but for integers. Like for example if I have a number like 20010112 and I want to cut it to the first for digits so that it reads 2001 You use LEFT function. SELECT LEFT(20010112, 4) You should get 2001 This function works on string too. ...Show All

• Visual Studio Express Editions Q: how to set a break

  hi, when you have a great amount of regular processes its some how freez your project and doesn't show the reslt untill it all done for example Private Sub Button1_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click For i As Integer = 1 To 1000 For S As Integer = 1 To 1000 Label1.Text &= (i + S).ToString & vbNewLine Next Next End Sub so how can i set a restrect for this process not to continue unless the label show the result , or to wait 1 second between one proccess and another is there any idea thx Hi, To get the pro ...Show All

• SQL Server Am I missing something???

  So I'm using the new Microsoft SQL Server Management Studio (aka Enterprise Manager)... 1. So I load it up, add a few sql servers to it. Mess around, close it, open it again and lo and behold it didn't bother to keep any of my settings or any of the SQL Servers that I had added and anoyingly asks me for login information to add another one.  Unless I'm missing something, you just threw out one of the best parts of Enterprise Manager. Please someone tell me how to fix this so that it works the way it should. (and someone else, i.e. Microsoft, make it the default behaviour to add and save any sql servers and bring them up the next time, t ...Show All

• Visual Studio Express Editions Unload equivalent

  I have just picked up VB 2005 Express and made the mistake of thinking I could brush up quickly on some old VB6 skills and get a simple program coded quickly. I have, what to me is a fairly basic question. How do you code an "Exit" button. In VB6, the code was simple - "Unload Me". What is the VB.NET equivalent Help please!!!! Exactly, although if you're talking about the startup form, close() does eventually cause dispose to be called. Dispose() will release all resources allocated to a form...although letting the form go fully out of scope will do the same as well. For the mos ...Show All

• Visual Studio Team System Problems with Performance tools

  Im having a few problems with the performance tools I created a performance session that uses sampling  - that seemed to work ok When I create one using instrumentation, when I launch it, I get the message that "A project with an Output Type of Class Library cannot be started directly". Well its not a class library project - its the same one that worked for sampling! Once I get this error I cannot find anyway of getting the Launch button to be enabled again - the only way I could get it to be enabled again was to restart Visual Studio And how do you delete a performance session from the treeview   Andrew ...Show All

• Visual Studio Does VSS 2005 have Netsetup?

  Does VSS 2005 have a netsetup or equivalent I much prefer that installation tool versus toting and inserting a CD at every client box. Mike No, it doesn't, but as Rothariger said, you can install it over the network. VSS2005 doesn't create by default a new database like VSS6 did when you installed from CD, so there is no need for a "netsetup" tool that will just copy and register the binaries. Alin ...Show All

• Visual C++ Visual Studio 2005 MFC Applications on Windows 98

  Hi, I am tring to build a unicode app to work on win 98/nt/xp. Built a sample MFC application in Visual Studio 2005 Team suite Beta 2. A unicode dialog app with a button. When run on windows 98 it shows this message.  Installed VCredist_x86 and .NET framework 2.0 latest versions downloaded from web. Also coped mfc80u.dll to the exe folder. Microsoft Visual C++ RuntimeLibrary Runtime Error! This application has requested the runtime to terminate it in an unusual way.  Please contact the application's support team for more information. I tried with Express Edition and Windows Forms it works in windows 98. Thanks, ...Show All

• Smart Device Development Linker Question..

  In my eVC 4.0 project the Linker automatically searches for libraries such as: aygshell.lib I migrated the project to VS2005 using the Wizard. The VS2005 no longer automatically searches aygshell.lib. I had to add it to “Additional Dependences”. If I build a simple project using the Wizard defaults (MFC) I notice that aygshell.lib is automatically searched. My question is: How is the automatic searching of libraries controlled. It must be some option, I am overlooking. Thanks JEK Hi, The default wizard generated MFC project has following piece of cod ...Show All

• Visual C# text with style (Word 9.0 interop)

    Hi lo all, I'm using the Word 9.0 interop (out of necessity!) to generate a Word catalog from a normal document with bookmarks that I use for a template. I'm running this against Word 2000. I can write out my data just fine, but it doesn't seem to copy the style information... so I'm trying to assign that manually. Here's the relevent code (limited to just the "PRE" section of the template, because it's all the same): try { alTemplateRow = (ArrayList)htTemplate[sField]; Word.Style sPRE = (Word.Style)alTemplateRow[1]; Object osPre = sPRE; ioWord.Selection.TypeText((string)alTemplateRow[3]); // next line blows u ...Show All

• Visual C++ Stopping the program while running in a loop

  When my program in in a loop and the user wants to stop the program, what command should I use so that the program understands that the user is entering a key Right now if the user hits a key, the program goes in the Not Responding mode until it finishes the loop Restructure your program if it is a WinForm to have the processing in a seperate thread and create an event for the keypress (or cancel button) that will kill the process. If it is console application, check for keyboard input inside the loop if it will hit that section each time, or do the above suggestion by creating a seperate thread and have ...Show All

• Visual Studio Catch On Properties Change Event

  Hi Everybody, I am trying to catch the act of changing the value of a property but i didnt find the method. This property also changes the source of a link. So could be the event raised by changing the value, the event raised by connecting the source of a link to another shape, without using the mouse, Or the event raised by adding a link to a shape, without using the mouse. Does anyone know how to do it Luiz, It is possible to respond on a property change by using some custom code. You can create a "ChangeRule" that will provide you with a hook to implement your code. Have a look at the "customization guid" (Ex ...Show All

• .NET Development Sending a html page as an e-mail using Net.Mail.MailMessage

  I have a .net page that sends an email but i want it to send a html page as the body. Is there anyone that knows how to do this in VB Hello, I am trying to do this but sending current page as an e-mail body. This is a web form that users will fill some fields and send form with the information thery entered. Is this possible Thanks, Gus G. ...Show All

• Visual Studio Team System Team Explorer in Team Suite Edition

  Hi there, I cannot find Team Explorer in View menu of VS 2005 Team Siute which I've installed recently. Does it need to install the Team Foundation Server Yes, to get the client pieces you need to install Team Explorer from Team Foundation Server.  Note Team Explorer and Team Foundation Server are only in Beta at the moment. Brian ...Show All

• Visual C# Windows Service .NET 2.0 MissingManifestResourceException

  I have a simple windows service that was created in vs2005, it uses the FileSystemWatcher class to watch for directory changes, and if an error occurs it logs it to the event log. I have used the new Resources designer to define a few common errors I would like to write to the event log. Other than my machine, all clients that are testing are getting the MissingManifestResourceExcepti on that is being written to the eventlog, System.Resources.MissingManife stResourceException: Could not find...Make sure"SOXFileSysProperties.Resources .resources" was correctly embedded or linked into assembly "SOXFileSysWatcher" at compil ...Show All

• Windows Forms SQL parameter query using INSTR

  Hello. I am using the dataset designer to create my SQL queries for a VB project, but cannot figure out how to create a query that will filter my records properly. I am using an Access database. In a nutshell, I cannot get my SQL query to distinguish between 0,1 and 10. Here is my query: SELECT ID, Word, Definition, Source, Unit, Chars, Cat, WordType, Context, Literal, Ant, Syn, ConfusedWith, OnList, Audio0, Audio1, Audio2, Audio3 FROM Vocab WHERE (Instr( ,OnList)>0) is a string that reflects what the user selected. It could be any numbers, 1 through 10, in a string format. ie. "7,8,9 10" or "0,1,9,10&q ...Show All