johnls's Q&A profile

• Visual Studio Team System no coverage result for website

  How can I get code coverage results against my website in my unit test projects I tried adding the website to my test solution and add it to test run config to be instrumented. But after doing that, my test case can't work fine and I'll notice the weird error message: Failed to connect to an IPC Port: The system cannot find the file specified. Anybody has any idea Hello Shu, Unfortunately, I am not sure that there is a workaround for the Beta2 problem, you are experiencing. I would recommend that you upgrade to Release candidate version. Just be sure that you fully remove the Beta2 before that (there is a t ...Show All

• .NET Development Reg : Better option to move data into my Db

  Hi, For my application, i have to move the other db structure into my db and check for changes. For this i am creating a connection to other db and fetching the data from there. Now these details are in my dataset. for moving the details into my db(MS SQL) i am using the following code: foreach (DataRow dr in ds.Tables[0].Rows) { i += 1; cn.Open(); string nullable = dr[4].ToString(); string defaultval =dr[5].ToString(); defaultval = defaultval.Replace("'",""); char chrnull = nullable == "YES" 'Y' : 'N'; string defaultvalue = dr[5].ToString(); ...Show All

• SQL Server Management Studio doesn't run!

  Hi, I recently installed SQL Express Edition on a completely clean installation of Windows XP SP2 with all updates until yesterday. I use default instance name (SQLExpress) and tested the instance in many ways; all seems to be cool.   But, when I installed Management Studio CTP Nov, installation process finiched without any proble, bu when traying to tun the application either from Start Menu or installation program files folder, it doesn't work!  None dialogs, console windows and even no processes on task list. Can anybody helpme Erik Castaneda segersall@hotmail.com Hi, I am having the same prob ...Show All

• SQL Server SQLXML4 didn't install for SQLExpress

  I just noticed that SQLXML4 did not install when I installed SQLExpress Advanced package (Mar 2006). Anyone know if I can install SQLXML4 separately for SQLExpress Advanced or do I need to uninstall and re-install the entire package Thanks, Paul Hi Paul, SQLXML4 is not included in SQL Express Advanced. To my knowledge is is not available as a separate download. Regards, Mike Wachal SQL Express team ---- Check out my tips for getting your answer faster and how to ask a good question: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=307712&SiteID=1 ...Show All

• Windows Forms Dataview rejectchanges

  Hi all, I have a dataview of tblUsers and I would like to rejectchanges() when a cancel button is clicked. The textbox has say a name in it 'Joe Bloggs' and I change it to 'Joe' then I click the cancel button but it does not revert back to the original. My code in the cancel button click is below. Dim dt As DataTable For Each dt In  ...Show All

• .NET Development Saving to a file using stream...

  I am trying to save some data using stream as a text file from 3 textBoxes using "\r\n". But when I read the data from the file, all of data is displayed in the first text box. How would I save the data separately from the textBoxes and when I read them, the data are in their corresponding textBoxes For example, I have name in first textBox, Address in second textBox and phone in third. But when I retrieve, All name address and phonenumber is displayed in the first text box. Any help will be appreciated. Thank you daras, without some code it is extremely difficult to understand what your problem might be. Try something like ...Show All

• Visual Studio 2008 (Pre-release) Sorting in ComboBox

  Hi, Can somebody help me sorting a WPF ComboBox by code and not by XAML. I think I have to use SortDescriptions, but I am not sure how to use it in ComboBox, as I don't have a property name. Or am I missing something -Karlekar ObservableCollection < Order > oc = new Orders (); mcv = ( ListCollectionView ) CollectionViewSource .GetDefaultView(oc); mcv.SortDescriptions.Add( new SortDescription ( "name" , ListSortDirection .Ascending)); combo1.ItemsSource = mcv; combo1.ItemTemplate= FindResource( "dt1" ) as DataTemplate ; There is an sample at ms-help://MS.MSSDK.1033/MS.W ...Show All

• Visual C# Print Solution

  Is there a way to print an entire C# solution or do you have to select one file at a time and print Thanks Steve 1)  C# doesn't have optional parameters, only VB.NET does.  This is why you'll often see far more methods in a C# project than a VB.NET project. 2)  You are correct, you could not have 2 methods of the same name both with a String as a parameter.  Each method would need a different set of parameters. ...Show All

• Visual Basic HotKey

  How do you register a hotkey. I want to make a screen capture program and I want the print screen button to take the image. I already have the screen capture code. You probobly dont need to know how it works, but here is what u need to copy in:  NOTE*** Make sure in your project settings, in refrences, imported namespaces, you have system.runtime.InteropServies selected Api Declerations and constants (top of the class, before any function) Private Declare Function RegisterHotKey Lib "user32" ( ByVal hwnd As IntPtr, ByVal id As Integer , _ ByVal fsModifiers As Integer ...Show All

• SQL Server need help designing database

  Hello I have a database which has to tables, Files and Sites. in Files i have a field called hash, which is declared as varchar. my question goes here, would it be better to declare hash field as binary or to leave it as varchar and if binary is better(faster) how can i search in binary field thanks. Say the Files table was Create Table ( id int primary key hash varbinary(200), ...) If your hash is really binary (like say CRC, MD5, SHA-1, etc), then I would make it a varbinary. Speed wise binary is a little faster since it does not have to evaluate a comparison according to collation rules. You can search binary fields like any othe ...Show All

• Visual Studio Express Editions errors

  I have done some programming in vb.net 1.3 and now I have opend it in vb.net 2005, there are quit a lot of errors now, in vb.net 103, there is none, some of the errors I understand, but there is some that I don't understand. Here is on of them cmd = New OleDbCommand(sql) 'setting cmd cmd.Connection = DB 'Setting Image Para If Prent.Image Is Nothing Then cmd.Parameters.Add( "@Image" , SqlDbType.Image).Value = System.DBNull.Value Else cmd.Parameters.Add( "@Image" , SqlDbType.Image).Value = bytImage End If in cmd.parameters.add it give me this when my mouse is over it. 'Pub ...Show All

• Visual Studio Express Editions Using information from a database??

  Hi, I have just started an application that will need access to a database( in this case an Access database). I'm very new to Vb and access for that matter, Before I really get started I was wondering a couple of things. 1. I have added a field from my database to my form which in this case displays names, is it possible to use what ever value is in the textbox in your program code. i.e i have added another textbox(not connected to my database) and would like it to output certain words depending on the name displayed in the text box from the database.. Is this possible 2. My ultimate aim for my application is for the user to be able to dec ...Show All

• Visual Basic Unhandled Exception Error

  I get a unhandled exception error when I start the Code Snippet Editor. Is this because I only use c# and have not installed the VB components in VS 2005 Pro   Andrew     See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box. ************** Exception Text ************** System.NullReferenceException: Object reference not set to an instance of an object.    at SnippetEditor.SnippetPathsManager.getLocalisedName(String name) in D:\Documents and Settings\lorenzom\Desktop\Snippet Editor 2005 RTM RC\Snippet Editor 2005\Helper classes\SnippetPathsManage ...Show All

• Windows Forms toolstripcombobox with scroll bar

  I'm using vb .net 2005 beta 2.  I have several toolstripcomboboxs in my app.  When there are enough items for the scroll bar to appear, clicking on the scroll causes the combobox to close.  The only way I can scroll the list is with the mouse wheel.  Is this a bug or do I have some property set incorrectly.  Thanks. I'm pretty sure there's no property for something like that.  Do you have any Click or MouseDown events associated to your combobox   ...Show All

• Visual Studio Tools for Office Assembly '[project name].DLL' must have a shared name to be installed globally

  I am trying to complete a setup package for my excel project in VSTO. I posted here, my project works great. Here are the issues I am having; Error Assembly [project dll]' must have a shared name to be installed globally. The project does use a strong name. I am trying to add the .dll for this project into the GAC file within the setup package. Error Assembly ‘[a dll from another project]’ must have a shared name to be installed globally.. Now I know this looks like the same error but the issue is different. The .dll that is associated with this error belongs to a project that has been added to my projec ...Show All