Zydeco's Q&A profile
Visual Basic Detecting MDAC
Hello Everybody, 1. I need to detect the version of MDAC that is running on my m/c using Visual Basic Programming.Is there any way of doing this within VB (using Win API). 2. I came across a tool called "Component Checker" that detects the MDAC version.Is there any way of integrating it within a VB application. Any help will be very much appreciated. Thanks in advance. SK. This code will do what you want: Dim x As Object = CreateObject("MDACVer.Version") Debug.Print x.Build Debug.Print x.Major Debug.Print x.Minor Debug.Print x.Qfe Debug.Print x.String ...Show All
SQL Server Poison Message Sample in BOL
Hi, We've been trying to diagnose a problem with service broker's poison message detection and tried to run the sample script in BOL to see how it solved the problem. It appears the example doesn't seem to work correctly, IF (@messageTypeName = '//Adventure-Works.com/AccountsPayable/ExpenseReport') BEGIN DECLARE @expenseReport NVARCHAR(MAX) ; ...Show All
.NET Development databinding drop downs
I have multiple dropdowns with either "yes", "no", or "n/a" as list items. In the database I stored these as integers, 0 = no, 1 = yes, 2 = n/a. Anyway, I am trying to bind dropdowns on my form to these values. What I did so I could have display and value members was create a table with two columns: list_value int list_text varchar(50) I populated the table with: list_value list_text 0 No 1 yes 2 & ...Show All
Windows Forms Simple Drawing Question for Windows Forms
Hey, I have been working on this for a long time, and so far, no one can help. I have a Windows Form Application written in C++. On the Windows Form is a Button called "Draw" an Up and Down Box, and then a Panel called "Screen". The Up and Down Box has the items "Line" and "Rectangle" in them. The user ...Show All
Windows Forms vb express and sql server express
Hi, I am trying to use the combo "vb express and sql server express" to know in advance what these two products will be like; I haven’t done anything yet because I am unable to create a Data Source. When I open the New Data Source wizard and try to create a Data Source, I always get these error: An error occurred while retrie ...Show All
Visual Studio Team System VS .NET 2005 Standard + VSTF Client = ?
Can you use VS.NET 2005 Standard edition plus the VSTF client to code team projects If it is possible, what problems are there Since static analysis is not part of the standard edition, I guess there would be issues if you had that check-in policy enabled. Are there other issues that I am missing Team Explorer will integrate into VS 2005 Standard. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=120971&SiteID=1 If you have that check-in policy enabled on the Team Project, then a user that lacks the necessary binaries to run it will get a policy failure for that policy and will have to override it. Buck ...Show All
.NET Development Combining two ICollections into one IDictionary
Given two ICollections, where the first one contains strings, and the second one contains Objects, is there a standard way to combine them into one IDictionary where the strings from the first provide the keys, and the Objects from the second provide the values An example would be a ConnectionStringBuilder class. It contains two ICollections, .Keys and .Values. I would like to make one HashTable out of those. Right now I CopyTo() an array for both and then loop through one array and use the indexer to extract keys and values and use those to build up my HashTable. Any tips Thanks in advance! I mean that you ...Show All
System Center Event Count vs. Transaction Count
In the Transaction Latency report, what is the difference between Event Count and Transaction Count Cheers Dave Dave: I assume your question refers to the Excel Export (Detail), Transaction Latency by Origin Site report. The Transaction Count is the number of transactions of the Transaction Class that originated at the Origin Site. The Event Count is the number of individual actions (Disk Read, Network Send, CPU Use, ...) for the same Transaction - Origin Site combination. Glenn ...Show All
Visual Studio Team System Can the test cases in the test project be merged into one document?
Hi, I have a test project with test cases in VSTS. Is there any way or work around to put them together and have one document to contain all of the test cases I want Thanks, Leon 1.You can add a Query to selcet all test cases what you want put them into one doncument from your Team Project. 2.Then select all and click "View -> Open Selection in Microsoft Excel". After step 2 you will get an excel file and you can save it. ...Show All
Visual Studio Express Editions Language pack
Where could we find a language pack (french) for CD installation thinks Fred ...Show All
Visual Studio Error: Report Parameter 'Value1' is read-only and cannot be modified
I am using VB 2005 RC and SQL 2005 Dev Edition I am trying to drill-through from one report to another passing the Value1 id field as the parameter. Report1 is a basic list of a table. Report2 is a view generated data from four linked tables. Both reports work like a charm on their own. In Report1, I select the column properites and link via jumping to Report2 using Parameter Value1 and defining the Report Parameter in Report2 as Value1. I set the "Internal" checkbox and Allow Null (since setting a default gives me an error). I run the form with Report Viewer and it loads Report1 with no problem, I click on the ...Show All
Visual Studio Team System Code Coverage loses it's mind
Please refer to http://lab.msdn.microsoft.com/productfeedback/viewfeedback.aspx feedbackid=FDBK40689 . I'm now seeing this on other code - non-generic code, so I doubt the original problem has anything to do with generics. Has anyone else seen this kind of behavior Is there any solution available Having the coloring completely scrambled makes code coverage quite a lot less useful! Update: Here's the new link on Connect: https://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx FeedbackID=122653 Hey Carl, I just went and took a look at the MSDN Feedback issue that you filed. Looking at the n ...Show All
SQL Server Uninstall SQL 2005 CTP
After installing SQL 2005 CTP I could not run Reporting sevices. SO, I have removed the whole thing. I used Add/Remove Programs for that. And was a mistake. Now when I am trying to use sqlbuw.exe I am getting an error message: "Component fail to uninstall". How can I completely remove SQL 2005 from my computer Thanks Dan; I've got a Win2K3 box destined for SQL2005 Standard Edition. It's got SQL2005 June CTP on it now. I want to remove that and install the Sept CTP Standard Edn. Are there any issues I should be aware of before I start Right now in the Add/Remove I can see the VS Dev Env, a ...Show All
SQL Server Error evaluating expression
Greetings my SQL friends. Why do I get an error message saying that the following expression won't evaluate "Select * from Price_grp where price_grp_id >= " + (dt_str, 10, 1252) @[User::MIN_PRICE_GRP_ID] + " and " + (dt_str, 10, 1252) @[User::MIN_PRICE_GRP_ID] + " > 0" Thanks for your help in advance. Hi friends, I have solved the problem now. I didn't change the code but I got it to evaluate in the end. I don't know what I did to fix it but perhaps there was some issue with the spaces. I don't know... ...Show All
Windows Forms Search for a value in a DataGrid Column.
How do you search for a value in the first column of a DataGrid For example, the first Column of my DataGrid is Called InspectionID. It's a hidden Column. Lets say the InspectionID is 50, I wish to search or scan or interogate the first Column called InspectionID to find which ROW has the value of InspectionID = 50. Then I need to make the DataGrid select that row. Keep in mind that the DataGrid may have 1, 5 or 50 rows of data. You will need to delegate the search to the DataGrid data source. For instance, if the dataGrid is bound to a BindingSource that supports searching ( ie, if BindingSource::SupportsS ...Show All