SJROOKER's Q&A profile

• SQL Server Bootstrapping SQL Server Express

  Can someone tell me if there is a definitive description somewhwere re how to get SQL Server 2005 to install from the same CD as a VB application. Despite the help pages that I found not mentioning anything about copying the files into the Bootstrapper\Packages folder, I found this in the forums. However, whilst Windows Installer and .net framework install ok, it still bombs out with SQL. I discovered that the old machine I was using to test on was a P2 and it needs P3 to work. A friend has now tried it on a modern PC and it wouldn't install for him either. Don't have the error codes yet. Is there anywhere that lists exactly which files need to be where and any other little hidden secrets Regards, Rich ...Show All

• SQL Server Error on Attaching Database

  When attaching a database that was detached from another SQL Server instance. I got the error message below: Error 602: Could not find row in sysindexes for database ID 25, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes.  i am using SQL Server 2000 Thanks and Regards JonM wrote: Why would you be passing around databases between in sql2000 and sql2005 in the first place Detaching, moving, and attaching a database is a fairly rare occurrence to us. Jon, With all due respect, what's it matter the reason for doing so Whether it's a rare occurance or not, it's still a known issue that obviously many people have a problem with. Now, you asked for a reason, so here's my scenerio. I had a ...Show All

• Visual C# Iterations through a Dataset/datagrid

  I am new to C# and dataset/datagrid processing. When saving any changes, I need to know how to iterate through changed rows to evaluate column contents for validation. The information I have at my disposal does not show any examples. Any help would be greatly appreciated. Yep, the value in currentRow[currentColumn] is getting assigned, but still failing on the INSERT saying that the value is NULL. Should I be assigning the value to the Bind variable somehow It is almost like the column is not getting set to the bind variable of :CLIENT_CD. The insert statement associated with this data adaptor is something like this insert into tablea (client_cd) values (:client_cd). Client code is null ...Show All

• .NET Development Reading cells i .xml?

  I need to read colums and rows from an .xml document, but i simply can not get it to work. The table example looks some like this:         A        B        C 1    tA1    tB1    tC1 2    tA2    tB2    tC2 3    tA3    tB3    tC3 Now i need to read the cells and rows, and do following: Contens of ListBox1 = Colum A. When A1 (tA1) is activated i the listbox. Fill label1, label2 and label3 with the values from row 1 (A1("tA1"), B1(" ...Show All

• Visual Studio Team System TSQL Debugger is not working after installing "VSTS - Database professionals"

  Hi, After I have installed VSTS - Database professionals CTP5 I have found that TSQL debugger is not working any more. When I put breakpoint into the stored procedure and do "Step into Stored Procedure" the break point became disabled and the message is "The breakpoint will not currently be hit. Unable to bind SQL breakpoint at this time. Object containing the breakpoint not loaded." I'm absolutely sure that this was working normally before the installation of the CTP5. I'm guessing that something was done to the security settings by the installation package. I hope it is fixable. I'm running VS2005 and SQL Server 2005 Developer eddition and now SQL 2005 Express edition as second instance. CLR Stored p ...Show All

• Windows Live Developer Forums Localised Versions of VE

  In the online documentation of VE it mentions that it is available in 13 languages. How can you switch so that the maps are showing in another language This means the map place names and not any dashboard text. E.g London will appear as Londres if choosing a French locale etc etc.. (I've notice that google maps just use the local spelling) The current version of local.live.com has en-uk and en-ca versions. The team is continually updating the site and the control with more features, but as of this time, nothing has been announced regarding more localized versions. ...Show All

• Visual Studio Tools for Office chart.ChartWizard always failed in excel2k7

  For exmaple, chart.ChartWizard(range5, XlChartType.xl3DColumn, Missing.Value, XlRowCol.xlRows, 0, 0, True , "Chart" , _ "Category Type" , "Value Type" ) the above code worked well in excel 2k3, but always got exception in excel 2k7. The exception was, Unhandled Exception: System.Runtime.InteropServices.COMException (0x80020005): T ype mismatch. (Exception from HRESULT: 0x80020005 (DISP_E_TYPEMISMATCH)) at Microsoft.VisualBasic.CompilerServices.LateBinding.InternalLateCall(Object o, Type objType, String name, Object[] args, String[] paramnames, Boolean[] Cop yBack, Boolean IgnoreReturn) at Microsoft.VisualBasic.CompilerServices.NewLateBinding.LateCall(Object Inst ance, Type Type, St ...Show All

• .NET Development Open Text File with Encoding

  I am using System.IO.StreamReader to grab my data from a text file. The problem is I can't get it to use the right encoding so that when I later throw that data into a textbox it displays correctly. When I open the text file in Microsoft Word and use the 'OEM United States' encoding the file opens correctly. Is there a way to do this while grabbing the data and throwing it into my textbox Thanks in advance for your help! Sorry to restart this thread but I am unable to get the encoding to work using visual basic. I've tried even different encodings to see if they would work but alas they don't. Here is my code: Dim lines As Long = 0 Dim lineRead As String Dim rprtRead As String Dim report_ ...Show All

• .NET Development Visual Studio 2003.net Databases Connection not working

  I am using Visual Studio 2003.net and trying to get connected to SQL 2005. Is this even possible to do and if not what is the best way to connect to a database with Visual Basic 2003.net. Before I was able to make a connection with VB 2005 express edition and SQL 2005 express edition but this is seeming to be a “no way hosa” kind of thing. . You may be using Visual Studio Standard Edition. If this is the case I believe Visual Studio Standard Edition database tools will only work with Access and MSDE. If you try to connect Visual Studio Standard Edition Database tools to SQL 2005 or SQL 2005 Express edition it will display an error message stating that: It is only possible to connect to SQL Server Desk ...Show All

• Visual Studio Life without source safe?

  I have used source safe in the past and it was very helpful. I don't have a copy of it in the place i work right now. It's going to be a while before we get that in. I just want to know that if 2 developers work on the same project (saved at a shared location) and ALWAYS work in different forms. Will this cause any problems Thanks for your time!! I believe you need MSDN Premium (the one that comes with a Team Edition of VS) to get TFS Workgroup. I think there are also MSDN versions that come with SourceSafe but I don't know what they are. As far as non-MS products go, I'd try Vault (free for 1 user) or SubVersion (open source). ...Show All

• Software Development for Windows Vista Problems by defining parameters for the workflow

  Hi people, im new to the windows workflow foundation and i have some problems by doing the tutoirials of the handson lab. In the section part of the tutorial, the following is written: 1. In Visual Studio 2005 with the HelloWorldWorkflow project open, double click on the Workflow1.xoml file in Solution Explorer to open the Visual Studio workflow designer. 2. Right-click the workflow background in the Visual Studio workflow designer and choose properties to open the properties window. 3. Click on the Parameters property and click on the ellipses […] that appear. The problem is, in my propertie window there is no parameters property under activity. I only see Base Class, Description and Enabled a ...Show All

• Visual Studio Express Editions Is this possible???

  As part of my program I would like to set up an address book. I have created the form for this. My question is: can I connect/create a database for just this part of my program. I have never created a database but am looking forward to giving it a go. This programming thing is totally addictive!! The reason storing in a text file is not the best of ideas - is that it means you have to write more code to do searching, sorting, modification of records etc. For this reason a database is a better bet. As to how difficult it is - With databinding, this is not a difficult task. Many of the walkthroughs / examples and webcasts which cover databinding can be modified to basically store different fields for ...Show All

• Visual Basic prevent tabpage from changing while input is validated

  Greetings: I've got a tabControl with several pages, and the first page presents a summary of the stuff on the other pages. It is set up so that the user input on the back pages is validated on the textbox leave event. A problem occurs when the user goes from entering some invalid text in one of the back page text boxes directly to selecting another tabpage. The validation error messages get shown along with the summary page error messages, and it is not a pretty sight. I tried using a boolean flag in the tabcontrol.selectionChanged event to try to stop the selection change, but that doesn't work. I'm guessing that the selection change event gets fired before the textbox leave event. I've also tried using boolean flags to stop the ...Show All

• Software Development for Windows Vista Compiling multiple Workflows into a single assembly

  Hi guys, I know this was already mentioned but the link to the sample doesn't work anymore. I already know about CompilerParameters.GenerateInMemory but I'd like to extend the question a bit more. So here is the question again: How can I compile (in memory) multiple workflows (including code beside files) into a single assembly. Is it also possible to use streams instead of physical files as input for the compile method It would be useful if someone stores everything in a db. Thank you Vijay, your help is very much appreciated. Maybe I give some more background what I intend to do: I develop a designer based on the Designer Rehosting Sample. I want to compile workflows but want to store the ou ...Show All

• Visual Studio 2008 (Pre-release) rss feeds

  is there a way to add micorosft rss feeds to my website ...Show All