hrubesh's Q&A profile

• SQL Server Alternating Row Colours

  When applying grouping or drill-down the alternating colour does not reset. If I use this code as an expression for background colour in a simple report with no grouping, it works great: = iif(RowNumber(Nothing) Mod 2, "White", "Gainsboro") Grouping or Drill-Down goes screwy. Any ideas This should do the trick. http://www.microsoft.com/technet/prodtechnol/sql/2005/technologies/rch7rptslnpatternrecipes.mspx ...Show All

• .NET Development Shutting down network computers?

  I suspect that I once again have someone leeching of my Wireless router again and I can't connect and lock it for some reason. So I thought perhaps I could shutdown the computer who is leeching off my network As a lesson :P There are probably a lot of software out there that could do this but it would be nice to learn how I could create such software. ProcessStartInfo thePSI = new ProcessStartInfo("shutdown.exe"); thePSI.WorkingDirectory = Environment.GetFolderPath(Environment.SpecialFolder.System); thePSI.Arguments = "-s -f " + storedVars.arguments + " -m \\\\" + storedVars.computerName; Process.Start(thePSI); Doesn't work other than on my computer ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Where is the download?

  It is 12:48 pm here (GMT + 1)... in Nuku'alofa (GMT + 13) it is tomorrow... So where the hell is my download link :-D it's past 9 am over here (Netherlands). By my calculations it should be past midnight Pacific Time... I'm bored of cleaning my Holy Grail, let's get this show on the road!! ...Show All

• Visual Studio Team System Changed file warning on each test

  I have a solution containing an ASP.NET project and a DBPro project. I configured a second database for my unit tests, but now whenever I run one of my aspx file to debug I get the following dialog: http://www.cryptpad.com/screenshot.jpg I don't seem to be able to 'unconfigure' the deploy database, and there doesn't seem to be an option to not deploy on each solution build. Anyone know how to stop this P.S. The specified file is not 'included' in the project. To avoid building the Database project on every build you should be able to configure VS to only build depended-on projects when starting to debug. Tools->Options : Projects and Solutions : Build and Run Check "Only build start ...Show All

• SQL Server SQL 2005 x64 Setup Fails

  Below is the error message receive when installing SQL 2005 (x64) enterprise edition. Failed to install and configure assemblies c:\Program Files (x86)\Microsoft SQL Server\90\NotificationServices\9.0.242\Bin\microsoft.sqlserver.notificationservices.dll in the COM+ catalog. Error: -2146233087 Error message: Unknown error 0x80131501 Error description: The transaction has aborted Has someone seen this before Any pointer is appreciated. Thanks. I've got this exact same issue, is there any resolution or confirmed workaround Been through two complete OS/SQL re-installs with the same results, also on x64. ...Show All

• .NET Development Merge multiple tables int one DataView

  Hello. Do i have a way to merge info from several DataTables into one DataView. I assume that all data tables belong to the same DataSet. No, Parent goes up a relationship between 2 tables in a dataset. Look at the link above. The opposite is Child(relationship_name). Charles ...Show All

• Visual Studio Team System urgent: Connection Problems

  Hi I have this major problem: I used to use sql 7.0 with vb6 thru this line of code connection: .ConnectionString = "Data Source=" & SQL_SRV & ";User ID=sa" & ";Initial Catalog= NorthWind" //no password Through an executable file, i was able to run my program from different stations (LAN network; database sql at my station) Lately, i shifted from 7.0 to sql 2005. With the following line of code connection: .ConnectionString = "Data Source=" & SQL_SRV & ";User ID=sa" & ";Password=****" & ";Initial Catalog= NorthWind" or through windows authentication: .ConnectionString = "Data Source=" & SQL_SRV & & ...Show All

• SQL Server Problem Creating configuration table

  Hi I tryied creating my first package in SSiS and i am lost in problems. Firstly , i am not able schedule the package with the connection to JDE sustem.how ever if i run it through GUI it runs fine. Secondly, when tried to create configuration table, it say, " Could not complete wizard actions" , Also it says, cannot insert configuration information into the configuration table". Some time back i was able to create it, but now it some how not creating. Can any help me in this regard.I need to move it to production by 2 days.. Please help me ...Show All

• Windows Forms Datagridview advanced search and filer

  Hello I would like to know how can i perform an advanced search/ filter in a datagridview. Including "Match whole word" , "Match case" and regular expressions. I have a datatable bound to the grid. Can i use datatable.select or bindingsource.filter thank you, Horea hi,this is A "Filter Dialog for a DataGridView", This is a dialog window that allows filtering a DataGridView. It can build filters with any depth of parentheses.I hope this will help you. http://www.codeproject.com/dotnet/filterdialog.asp ...Show All

• Visual Studio Custom editor coloring

  I've managed to get custom colors working and my custom colors to appear in the options dialog list, but the editor windows are not always updated after the colors are changed in the VS options window. I have to exit and restart VS in order for the new colors to be used. The docs for Colorizable item allude to something more that needs to be done to support this. In the Remarks section: "The ideal place to construct an array of custom colors is in the constructor of your implementation of the LanguageService class. If you support customiztion of the colors, then you would initialize this array in LanguageService.CreateDocumentProperties after the DocumentProperties object was created." Why would I initialize this arra ...Show All

• Visual Basic problem with listbox and do while

  I am attempting to do a do while to remove a specific selected item from a listbox using a do while loop,so far I have tried altering the code and have ended up with this which does not work either,I have concluded that I do not know what I am doing Dim intSelectedIndex As Integer intSelectedIndex = Me .lstLeft.SelectedIndex Do While intSelectedIndex >= 0 intSelectedIndex = Me .lstLeft.SelectedIndex Me .lstLeft.Items.RemoveAt(intSelectedIndex) Loop the problem is that if I tell it to intSelectedIndex = Me .lstLeft.SelectedIndex -1 it removes items all right except that it removes all the items up to the selected item and not the item it was supposed to thanks ...Show All

• SQL Server variables as column names?

  I am using SQL Server 2005 and I'm creating a stored procedure that, in turn, creates some tables. The column namen in those tables will change depending on the input the user gives the stored procedure. I am having trouble getting the column names to be dynamic, however. Is this even possible If so, any tips Here is a small example (that doesn't work) of what I'm trying to do: DECLARE @ColName varchar(25) SET @ColName = 'Column1' select foo as @ColName from bar Thanks, Cam. I'm not sure I completely understand, however. I understand dynamic SQL, although I'm not sure how I could use it with a column name. Could you provide a real simple example based on the simple bit of SQL I provided ...Show All

• Visual Studio Tools for Office Stack overflow in calling Range.InsertXML()

  I'm using Range.InsertXML() to display an xml blob on a particular area on the document. The xml blob comes from the database and I use recursion to insert all records on the word document. I'm getting a stack overflow error when the records gets too big (50+ pages). I saw a thread on stack overflos in excel and it suggests using Application.EnableEvents set to false before calling a method. Word don't have this event. Any ideas how to prevent this error I must have not asked my question clearly. I'm trying to determine what process is causing the stack overflow. Are these 175 records all in the single xml blob Or are you retrieving 175 separate xml blobs If the latter, are you combining them into one Word ...Show All

• Windows Forms making Class problem

  there are 4 forms (same fields) i want to create a class which can use all forms. i want to access all texboxes in this class without ByVal for example public function clear() txt_Name.text="" end function ...Show All

• SQL Server Problem with a view (not a simple one)

  Hi, I have a table that is something like this: Products ----------------- idProduct as int, idPart1 as int, idPart2 as int, idPart3 as int then other table, which is something like: Parts: ---------------------- idPart as int, partName as VarChar(30) Now, some products only take one part, but others will take as many as 3 parts. Since it's a relatively small number I thought it would be better to put 3 different idParts on the product table and have two of them allow nulls, instead of creating a Master / Detail kind of thing. My question is, how do I create a view with something like: v_Products ----------------- idProduct as int, namePart1 as VarChar(30), ...Show All