voss's Q&A profile

• SQL Server MSmerge_genhistory error-515

  Can't insert value NULL into column nicknames. This error generated when I try start sync. SQL Profiler is not helping w/ locating specific error. I tried to allow NULLS in nickname column, for this table, but this table gets dropped and recreated each time. Pls. advise on where to make correction. thx..bt Can you tell us what version of sql server you're using, including Service Pack # (if any) ...Show All

• Visual C# Convert

  I'm very new to c#, and want to be able to take a string from a textbox, convert it to int, do some calculations with it, then convert it back to string. Presuming A is the string value and b is the int value, what piece of code would perform the conversion, and then back again. thanks string a = Textbox.Text; int b = int.Parse(a); b = b * 2 + 7; Textbox.Text = b.ToString(); Cheers, Greg ...Show All

• Visual Studio Can't get VS2005 to step into T-SQL stored procedure for debugging!

  Help! I've tried and tried, but I can't get VS2005 to step into T-SQL stored procedure for debugging! I've attached to a server and connected to a database, I right-click on a stored proc and choose "Step Into Stored Procedure", it opens the parms window and I supply the parms, but when I click to proceed, it just runs the proc without opening the code and without allowing me to step into it. It is VERY frustrating. PLEASE PLEASE PLEASE help me! Bob ...Show All

• Visual C# Highlight multiple found word in RTB in C#

  hello, i have highlighted the searched word in richtext box. but, the thing i have to do is search multiple words at once and highlight them with different colors in rich text box in C#. i know the only the concept i.e. one should use the array for storing the words that are going to searched. but, i dont know the actual coding method as i am only a beginner learner of C#. plz help me by sending some code snippets pr the sites links. Here is a little example code that highlight a specific string: string wordToFind = "melp"; int index = richTextBox1.Text.IndexOf( wordToFind ); wh ...Show All

• Software Development for Windows Vista Embedding Explorer window inside an application

  The Shell in Vista build 5270 is great: it lets the user sort and search/filter by metadata like keywords, rating, creation date, and an application can add custom metadata for new file types. It's so perfect for my app, I want to use the existing Explorer UI and not have to develop my own! Is there a way to use a Vista Explorer window as a control or otherwise use it as a child window inside my application Is it possible to change the look of it ("skin" it) in any way Opening up an old topic again. I have implemented the CLSID_ExplorerBrowser and have successfully made it look just ...Show All

• Visual Studio Express Editions Linking a Word doc to an MS Access Report

  I have an existing form in word document and would like to find a way to link it with other Access Reports and be able to insert data from an existing Access form to the report. Also being able to Print the report Search any data from the report I appreciate your help in advanced. Thank you Thank you for your reply I am using Access 2002 and VB 6.3. I have no knowledge of VB programming but would appreciate the help if you can assist me with my limited knowledge. ...Show All

• Software Development for Windows Vista IWshRuntimeLibrary re-distributable?

  Hi. I just like to know if the COM file "IWshRuntimeLibrary" is re-distributable In other words, can I include this file in my installer and give it to people I want to make sure before I go ahead and do this. The reason I need this is because my application has an update feature and I would like to update the user's start menu pointing to the newly updated application and so far, this is the only way I found - by using the IWshRuntimeLibrary COM Component.   If there are any other, perhaps better ways, then please feel free to let me know.   Thanks! ...Show All

• .NET Development Garbage Collector and Memory Release

  When the garbage collector determines that an object is no longer required, does it actually release memory from the application or not I have noticed personally that starting another application leads to a drastic drop in memory held by managed applications. Does this mean that 1) garbage collection only takes place when there is memory pressure or 2) that garbage collection is internal to the application(only releases memory inside the memory already held by the application), and that memory release from the application back to the OS only takes place when there is memory pressure. NB: I think Microsoft need to come up with ...Show All

• SQL Server SSIS from Visual Studio 2005

  I've been using a server instance of VS2005 for Integration Services package design.  I recently installed a copy of Visual Studio 2005 on a workstation and found that the BI studio apps were absent.   Any idea where the BI studio apps can be found Jax, The BI project templates (and the Yukon components needed to run them) are installed by SQL Server Yukon, not as part of Visual Studio. You would need (with appropriate licensing) to run the SQL Server installation on your workstation and select at least Business Intelligence Development Studio. -Doug ...Show All

• .NET Development Implementing an IDictionary class

  I am working on a class, that implements IDictionary, and the problem is, IDicitionary requires one type of GetEnumerator, and it implements ICollection, requireing a different type of enumerator. I have three options, each generates it's own little error: The most obvious implementation (it gives an error complaining about two implementations of GetEnumerator differing only by return type) public class Configuration : IDictionary {    /*      implemention required, but [most likely] irrelevant code    */       public override IDictionaryEnumerator GetEnumerator()  &n ...Show All

• SQL Server samples database revisisted

  I still can not get the samples databases installed. I am tring to following step 3 from Ten Things You Need To Know To Get Started with SQL Server 2005 Samples which is 3 – To install the samples and sample databases from the SQL Server 2005 Setup, you need to click the Advanced button on the Components to Install page, then expand Books Online and Samples and select Samples. This only installs the Samples MSI on your machine. To complete the installation, you need to run the Samples MSI. You can do this from the Start menu: click All Programs, click Microsoft SQL Server 2005, click Documentation and Tutorials, click Samples, and ...Show All

• SQL Server Is this possible?

  Hey guys, I wrote a T-SQL query to retrieve all errors name and count the error for each error name based on some conditions. Assume that errors_name is a column name in Error table and the error_count is a calculated field. Here is my question; when I run the query, obviously, it displays the list of errors name and the corresponding errors count which only meets the where condition . However, what I need is to list all the errors name (even if they don't meet the condition) and assign a zero value to the error count column for those errors name that do not fulfill the where condition. Can anybody assist me Appreciate your ...Show All

• Windows Forms Datagrid Sort Problem

  I have the following code:         Dim al As New ArrayList         Dim cm As CurrencyManager = Me.BindingContext(dg.DataSource, dg.DataMember)         Dim dv As DataView = CType(cm.List, DataView)         For i As Integer = 0 To dv.Count - 1             If dg.IsSelected(i) Then ...Show All

• .NET Development HTTP GET inside Visual Basic .Net 2003

  I can only use SOAP and HTTP POST method for the Web Services request and response. How can I use HTTP GET method Hello Xa, Douglas is right. Take a look at the following article for more information: 819267 INFO: HTTP GET and HTTP POST Are Disabled by Default http://support.microsoft.com/ id=819267 Cheers, -Todd Foust ...Show All

• Visual C# Can this be done?

  My question is: how do I change the color of a progress bar By color I mean that intense green used to draw the blocks of the bar. I found a property in .NET Framework 1.1 called ProgressBarColor that is supposed to do that, but I did not find it in .NET 2.0. Did the programmers overlook it on purpose or by mistake The blocks are drawn using the ForeColor property however if visual styles are enabled for the app then the progress bar uses the settings from Windows irrelevant of what you set for the properties. Michael Taylor - 1/12/06 ...Show All