Loren Bain's Q&A profile

• Windows Forms Problem binding a DataTable to a ListBox control

  I'm trying to bind a DataTable to a ListBox control. But i always get the error message: "The conversion of the type ' DataRowView ' to the type ' String ' it is not valid ." This message is Shown twice. When i bind the DataTable en when the DisplayMember is set. Afterwards everything seems to work just fine. When i change the Listbox into a combobox or datagrid the code works perfectly. ( ) How can i solve this problem. This is the code i wrote. Connectionstring and the objects are declared earlier. ================================             objCn = New OleDb.OleDbConnection(Connect ...Show All

• Visual Basic Do Express editions of VS2005 have support for Addins

  I have an addin that prints the source code of VS.NET projects. I am getting queries from users asking me if the Addin would work with their Express editions of VS2005. I would really appreciate if someone could tell me if the Addins can be integrated with the Express editions. It will save me a lot of time and effort downloading and installing each version. Thank you. Regards, Joginder Nahil www.starprint2000.com Hi Joginder, Add-Ins are not supported in Express.  Add-In support starts with the Standard SKU. Let me know if you have any questions. Joe The VB Team ...Show All

• SQL Server DatabaseMail setup problems

  I'm bust to setup a mail nothification system by using DatabaseMail. The setup of the database mail was ok. I'm able to send a test mail. After that I modified the SQLAgent's Alert system. I enabled the mail profile and as Mailsystem i choosed Database Mail with the mail profile the one I created in during the database mail setup. No I like to use this when a job fails or an alert is fired. So I created an operator. Give it the name SQLMAil and e-mailname  - first try a normal e-mail address vname.name@provider.be - second try the database mail profilename (SQLMAIL) I created also an alert theat make use of ...Show All

• Visual Studio Express Editions VWD Express beta 2 IIS problem

  Hi, i created a website which runs under a "File System" location and hence with the aps.net web server on a random port. Works all fine but now i want to host the site with the IIS. So i tried to create a website under the "http" path, something like 'h ttp://localhost/blabla' . I didn't changed something on the default generated stuff, just compiled and run it. I got the error "Unable to start debugging on the web server. The underlying connection was closed: An unexpected error occurred on a receive.". Ok, no problem i thought, disabled debugging in the web.config and run it again. The IE pops up and showed me a "Cannot find serve ...Show All

• SQL Server Single Parameter/Multiple ORs

  Trying to construct a SELECT statement in my dataset that looks something like this: SELECT column1, column2 FROM table WHERE (column1 = @parameter) AND (column3 > 0 OR column4 > 0 OR column5 >0) Report Designer re-constructs this as: SELECT column1, column2 FROM table WHERE (column1 = @parameter AND column3 > 0) OR (column1 = @parameter AND column4 > 0) OR (column1 = @parameter AND column5 > 0) and as a result, the report prompts me for the parameter three times. I only want the user to have to supply the parameter once. Any thoughts Thanks, Tim Are you using the gener ...Show All

• SQL Server MBSA "Identity"

  My Windows login is a domain administrator. I run MBSA and ask it to scan only my computer. I have removed Builtin\administrators from the sysadmin role in my SQL Server 2000 installation. The login is still there. MBSA is still able to get into my SQL Server and report that there is a guest user in Northwind and Pubs. It does not, however, report on the logins with weak passwords, which it did when Builtin\Administrators was a member of sysadmins. This leads me to believe that it does use the BuiltIn\Adminstrators login to access the SQL Server. Is this correct Thanks, Sharon Thanks. That's what I determi ...Show All

• Windows Forms whidbey winforms: MDI: why does childForm menuStrip appear in parentForm menuStrip?

  hiya, I have an MDI app. When I add a menuStrip to the childForms, all is well at design-time. However, 2 unusual things happen at run-time. The childForm menuStrip: 1)  disappears from the childForm 2)  appears at the rightHand side of the parentForm menuStrip Is this a bug Can I clarify anything many thanks, yogi thanks man. I'd have thought that the default would have been "false". Ah well, fixed now. cheers, yogi ...Show All

• Windows Forms Using the AxDHTMLEdit control in .NET

  Im developing a WYSIWYG .net component using the Microsoft DHTML activex control (AxDHTMLEdit).  The component needs to accept html content into its body element after it is instantiated, and also have stylesheets attached.I can do this, but only after I show a messagebox to the user. Unless I do this, the DOM of the control never sets itself up properly&nb ...Show All

• SQL Server Get local sql server name

  Hi, How can I get local sql server name Thank's Alexei Good for you. You have an escuse for using Microsoft.SqlServer.Management.Smo. http://msdn2.microsoft.com/en-us/library/microsoft.sqlserver.management.smo.database Using SMO is a nice experience (or I've been lucky). You will need to a reference to the microsoft....smo dll, of course.    #region "Add local SQL Server 2005 instances to tree"    DataTable dt = Microsoft.SqlServer.Management.Smo.SmoApplication.EnumAvailableSqlServers(false);    foreach (DataRow r in dt.Rows)    {     string sInstance ...Show All

• Windows Forms HTML viewing controls in Winforms

  Does anyone come across a winform control that allows HTML rendering Thanks, Serge. <a href="http://www.windowsforms.com/default.aspx tabindex=6&tabid=47&ItemID=10&mid=142">Like this </> ...Show All

• Visual Studio Team System error 32000

  Team Foundation Server Dual-Server Deployment ,while install Application Tier get the error: Error 32000.Failed to get CustomActionData. here is log file info: vs70uimgr: DisplayMessage_START:Error 32000.The Commandline '"Z:\Program Files\Microsoft Visual Studio 2005 Enterprise Server\widbloc.exe" -s datasvr -d CurrituckDB' returned non-zero value: 1. [06/16/05,23:57:14] vs70uimgr: DisplayMessage_END:Error 32000.The Commandline '"Z:\Program Files\Microsoft Visual Studio 2005 Enterprise Server\widbloc.exe" -s datasvr -d CurrituckDB' returned non-zero value: 1. [06/16/05,23:57:14] Setup.exe: AddGlobalCustomProperty [06/16/05,23:57:14] ...Show All

• Visual Studio Tools for Office Replacing text

  CAn anyone help me for replacing text in word xp after numerous occurences. for example replace "," with ";" only after 17 occurences of ",". Thanks or at least send me to the correct forum Hello, We have a few VSTO help topics that might help you accomplish this. Try "How to: Loop Through Found Items in Documents". You can find this topic at http://msdn2.microsoft.com/en-us/library/e7d13z59(VS.80).aspx . If you can loop through items and then place a selection at the 18th occurance of ",", then you can use info in the topic "How to: Search Fo ...Show All

• SQL Server Progress

  I have some SP's I run once a month and each SP takes a few mins to run and when I batch em together in one shot, I hate sitting there waiting for them to finish whats the easiest way to report back the status of the exec Ex: Set NoCount ON EXEC StatesUpdateZipTableUpdate 'AE' EXEC StatesUpdateZipTableUpdate 'AK' EXEC StatesUpdateZipTableUpdate 'AL' EXEC StatesUpdateZipTableUpdate 'AP' EXEC StatesUpdateZipTableUpdate 'AR' EXEC StatesUpdateZipTableUpdate 'AZ' How would I get it to report the results after each Exec In otherwords Id like to create a progress bar...... Just for Query Analyzer..... no bells and whistles ...Show All

• Visual Studio Team System MSTest not binding to dynamic loaded assembly

  Hi I've got a VS2005/C# Test Project which is a conversion of an NUnit project. Everything runs great from within the VS IDE, but when I try to run it using MSTest, an assembly which is dynamically loaded during the [TestInitialize] stage is failing to load. I'm getting FileNotFoundException. (MSTest is being run in the same folder as the test assembly, which includes the 'dynamic' assembly) This is the output from the Fusion log: === Pre-bind state information === LOG: User = 2000-1\Administrator LOG: DisplayName = Microsoft.VisualStudio.QualityTools.Common, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a  (Fully-spec ...Show All

• Visual Studio Team System Warehouse web service Server 500 error

  I am getting an internal server 500 error when invoking any of the warehouse web service operations--it would appear that the URL used to redirect to the results of the operation is incorrect. For example, when I invoke the ChangeSetting operation the URL is redirects to is http://localhost:8080/Warehouse/v1.0/warehousecontroller.asmx/ChangeSetting -- which is obviously an invalid URL. Is this a known issue I need to change the warehouse update interval--an hour is far too long for updates in my opinion, and I would like to make it shorter. ... also, if you're browsing to the web service via IE on the data t ...Show All