Martin Kulov - MVP's Q&A profile

• SQL Server Urgent Sub Report Help Needed

  I have an urgent need to solve this issue. I have a report that has two sets of six sub reports. Here is what I have: Main Report Subreport1A Subreport2A Subreport3A Subreport4A Subreport5A Subreport6A Subreport1B Subreport2B Subreport3B Subreport4B Subreport5B Subreport6B I want to have a page break between the first set and the second set. The last subreport of the first set, Subreport6A, has a pagebreak at end =  true, so it should break. The problem is that when I export to Excel I am getting one sheet for the 12 subreports.   Which issue are you having problems with I found a way to get all of the subreports to come together and I also what was causing the error above ...Show All

• Visual Studio 2008 (Pre-release) Running application from installer

  Hi! I've made Installer to install my XAML application. On the last page i ask user whether he wants to run application immediately after installation exit. Application was opened using Custom action of type 210. When this action is executed i obtain error message "Application has encountered problem and needs to close". This ment that installer really tried to open file but got the error. But when i manually try to run my app (from directory to which i've installed it) everything works perfect. How can i solve this problem Please help me! That error message you mentioned doesn't seem like one of WPF's deployment error messages . Have you tried using the setup bootstrapper (setup.exe) that is created by V ...Show All

• Visual Studio Alternating the BackColor for Detail Rows in a Report

  Is it possible to alternate the BackColor for every other detail row, similar to a DataGrid in a Report If this is a simple table, you could use something similar to this: =Iif(RowNumber(Nothing) Mod 2, "PaleGreen", "White") (see also: http://msdn2.microsoft.com/en-us/library/ms157328.aspx / Formatting section) If this is a matrix, you will need to follow the approach discussed in Chris' blog: http://msdn2.microsoft.com/en-us/library/ms157328.aspx -- Robert ...Show All

• .NET Development CodeDom / Code Generator issue?

  I've discovered (a bug ) that has become a minor annoyance since our migration to the .NET 2.0 framework. We employ a code generator for the creation of many of our boiler plate classes (DAO / Domain Object type stuff)... which worked great under 1.1. When we upgraded to 2.0, I've noticed that the files it generates sometimes are not properly formatted. They still compile fine and, in fact will usually re-format if you open them in VS and then Ctrl-K, Ctrl-D, but the real issue is that if left in their original format, they really screw up our DIFF tool when compariing new minor revisions of files originally authored with the 1.1 generator. Here's what I mean: // The old way namespace ns1 { public class MyClass { private string m_st ...Show All

• SQL Server Connecting and Getting data from 8 tables in one sql statement

  Hi everybody, I like to get data from 8 tables to be loaded in a dropdownlist or combobox control. Desired Result is need to be filtered by Region, Company, ProjectOffice, Country, and Location and still get all rows from 3 tables after applying filters. How can this be done in one single sql statement I have 3 separate sql statements which needed to be only one. Select C.CompanyID, C.[Name] As 'Company', P.ProjectOfficeID, P.[Name] As 'Project Office', P.RegionID, R.[Name] As 'Region' From ProjectCompany E Left Join ProjectOffice P On E.ProjectOfficeID = P.ProjectOfficeID Left Join Company C On E.CompanyID = C.CompanyID Left Join Region R On P.RegionID = R.RegionID Order By E.ProjectOfficeID Select P.ProjectOfficeID, P.[Name] ...Show All

• SQL Server Dynamically changing task name displayed within ForEach Loop Container

  Does anyone know how to change the task name displayed within a ForEach Loop Container (or of the ForEach Loop Container task itself) based on a variable. I am pretty familiar with setting variable values during task execution and using expressions to alter task properties based on variables. I have tried using an expression to alter the value of the Name property of the ForEach Loop Container but the name of the ForEach Loop Container does not change during execution. Since the color of the various tasks change during execution, I would think that the task names could be changed as well. You can create checkpoints or if that does not fit your needs; you could write to a file or table on each iteration an the look at that. if you ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Vibrate the controller for 1 second?

  Hi, I've just starting playing around with XNA for xbox 360 and have a noob question I want to vibrate controller 1 for a single second. I know to set vibration on I can use the code: GamePad .SetVibration( PlayerIndex .One, 1.0f, 1.0f); and to turn it off: GamePad .SetVibration( PlayerIndex .One, 0f, 0f); But how do you set the length of time for it to vibrate I have experience in programming with C++ but have not yet had the chance to fully immerse myself into C#. Thanks Doing it that way measure actual time though, not game elapsed time which you might want to do. Using the gameTime parameter in the Update method allows you to measure actual elapsed game time. ...Show All

• SQL Server Problem conecting to the same DB from two applications

  Hello, I'm new to VB and SQL server. I have a windows forms application and a Web application that need to connect to the same database (Named WebCenter). But when I try to connect to it from the Web app while running the windows forms app this error message apears: Unable to open the physical file "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\WebCenter_Data.MDF". Operating system error 32: "32(The process has no access to the file because is being used by another process). Unable to open the physical file "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\WebCenter_Log.LDF". Operating system error 32: "32(The process has no access to the file because is being used by another process. ...Show All

• Visual Basic CREATING INSTALLERS OF A SOFTWARE

  If a make a software using Visual Basic 2005 and it has a database made in SQL 2005, how can I create the intaller so it will create de database and install de program in the client pc without too much effort from the client Do I have to use an installer software to create it or I can do it from VB Thanks for the help If the software is create using VB2005 - is the SQL database a SQL Express database or a SQL Server 2005 database - if its an express database you can simply create a click once deployment for this and the SQL express database will be installed on the client machine. Its really simple. If your wanting to deploy a database to a full blown SQL Server 2005 then the setup will be a bit more c ...Show All

• Windows Forms Editing datagridview

  Hi all. I need help on how i can editing datagridviews. My datagridview is binded to a dataset Datagridview1.datasource = dsCustomer.tables["customer"]; How can i save changes in rows and how can i cancel chages made to the datagridview I also need the datarowstate for each row. Is is possible to show old row and new row when cliking a button Thanks all. Lars Look at this : http://msdn2.microsoft.com/en-us/library/system.windows.forms.datagridview.aspx AcceptChanges() and RejectChanges() in the following link will save/cancel changes you made to a row : http://msdn.microsoft.com/library/default.asp url=/library/en-us/cpref/html/frlrfsystemdatadatarowclasstopic.asp DataRowVersion should gi ...Show All

• Visual Studio Team System Whether to start using Database Professional now or wait until production release?

  Ok, I used Database Professional at TechEd and can't wait to start using it at work. However, I'm concerned about using a CTP version since it's not even beta yet. Here's my situtation... We drastically need version control of our database because it is shear chaos right now. I have no choice but to implement a solution next week. I'm planning on scripting out the entire SQL 2000 database into scripts and put in Team Foundation Server. Then, I was going to purchase Sww SQL Deploy that can automatically run all scripts in a directory to automate our deployment to dev and qa databases. I've used a similiar method for Oracle and know others that have taken this basic approach as well. The major disadvantage to this approach is that I'm goi ...Show All

• Visual Studio Express Editions dataset fun

  i am looking for the quick and dirty way to work with the data set i can't seem to get it right. mds is my data set: Dim YES() As String = { "A" , "A" , "A" } Mds.Tables(0).LoadDataRow(YES, True ) Mds.AcceptChanges() Dim writer1 As New StreamWriter( "MDS.XSD" ) Dim writer2 As New StreamWriter( "MDS.XML" ) Mds.WriteXmlSchema(writer1) Mds.WriteXml(writer2) writer1.Close() writer2.Close() this part works fine (i think) i now have two files 1 with me schema (.xsd) and 1 with my xml (.xml) file with the information i put in it what am i suppoed to write to get that data back into my dataset later I tried: Dim reader1 As New ...Show All

• SQL Server Enumerate SQL Server built-in functions

  Hi I am trying to build a tree similar to the one in SQL Server Management Studio for the system functions in the SQL language. I would like to group them by type (e.g. string functions) and display information about the parameters and return types, etc. Is there a way to get these programmatically I would like to avoid typing them out by hand. Thanks Chris Hi Chris, I'm not sure this is the right forum for this question. You can retrieve this information from the sytem views. E.g.: select ob.name as func, parms.name as parm, parms.parameter_id as pid, ty.name as type from sys.all_objects ob, sys.all_parameters parms, sys.types as ty where ob.type = 'FN' a ...Show All

• Windows Forms Buffering Images HELP

  Im not sure if this is the right place for this post, if not I apologize in advance this is my first time on the forum. My question is - I am trying to write an Image Viewer program that reads the file paths from the file system and stores them in a list. Then it loads the first 25 images into an Image list(the 25 can be set to whatever I want.). That all works fine. The problem is when you get to the end of the 25 and its time to add more images. It works but is EXTREMELY slow. I cant seem to figure this out and have been playing with it for a while now. Any insight would be appriciated. Heres my code for adding to the buffer - public void vScrollBar1_Scroll( object sender, ScrollEventArgs e) { Thread addThread; i ...Show All

• Windows Forms Slow in form display

  Is there any method to speed up the display and rendering of Windows Form In my application, my Windows forms containing around 50~150 controls. There are also some navigation button to hide one form and display another one. The delay occur during form showing up. As I'm developing a POS, such kind of delay is not preferable. Is there any workaround to speed this up Thanks for your suggestion. I will try to remove some labels and make use of the Paint event. However, I got a lots of buttons in my Windows Form. How can I fix them I don't think it's wise to paint the button by myself as I'll lose a lot of default UI behavior (I mean the outlook). Meanwhile, will it hard to manage a Windows Form with both control and custom Paint event ...Show All