ERK's Q&A profile

• .NET Development Q: How to: ControlParameter referencing across ContentPlaceHolders

  VS 2005 Beta 2, ASP.NET Master Pages, SqlDataSources Master/detail views using linked GridView/DetailView DetailView's SqlDataSource SelectParameters ControlParameter is linked to the GridView that provides the master data.  ControlId is set with the designer.   This works great when the SqlDataSource control for the detail view is in the same content control as the GridView control, but fails when the GridView is moved to a different content control area on the same master page.   That is, the Master page has two content placeholders: cphMain and cphFull.  The child page(s) provide the content for one or both placeh ...Show All

• Visual Studio RDLC Report Question on Data

  Ok I have a report I have created.I have an object Data Source lets say my car object. The car has a boolen property sold lets say......My report is bound to the Object Data Source of a list of cars.I have them grouped by region (a string property on the car object).How do I show only the rows(Using a table in the report) that are sold ,but in the group footer show the total number of car objects.For example, if I have a total of 10 cars,but 5 are sold the report should only show the 5 but in the footer total out all the cars One way of doing this is to define the table so that it shows the individual cars ...Show All

• Visual Studio Express Editions Crystal Report and VB 2005 express

  I have download the VB 2005 Express.  But I can not find the crystal report.  How Can I upgrade my project Thank you.   The crystal reports system does not come with the express products, you need to have the professional or team systems. Have a lok at the product line for the Visual Studio systems ...Show All

• Windows Forms VS 2005 RTM WINFORM DESIGNER BUG IS DRIVING ME CRAZY

  I have a project with various forms but when I try to view the designer for one of the forms I get the following error messages -even though the project atually compiles : I Have looked around and if you type "Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information. " IN GOOGLE you gets loads + a notification by Microsoft that says that they could not fix it before release http://lab.msdn.microsoft.com/productfeedback/viewfeedback.aspx feedbackid=d863064b-04e0-4b54-8f2e-55a43ba29163 now this leaves me STUCK. I wonder whether somebody has found a stable workaround!!. i get this silly ...Show All

• SQL Server deleting data using table prefix

  I can run a select to retrieve data using a prefix 'a' for the specific table involved. However when I try to run a delete using the same criteria it fails telling me Msg 102, Level 15, State 1,.......Line 1 Incorrect syntax near 'a' The Select statement looks like: select count(*) from schema.table a where a.customer_id=1234 The Delete looks like: delete from schema.table a where a.customer_id=1234 What am I doing wrong here and how can I prefix the table, because the command I want to run is much more complicated than the example above and it needs the prefix You can use the T ...Show All

• SQL Server CLR Performance

  We had a CLR function that was running in seconds under the April CTP - now it takes over a minute in the new Sep CTP.  We've determined that the bottleneck is in the following line: Dim SqlConn As SqlConnection = New SqlConnection( "context connection=true" ) Is there a new recommended way to open a connection Yes, you're sample is pretty much what I did to test the UD stored procedure.  I just think it would be in Microsoft's interest to send me a patch to test the fix in my environment.  Let me know. ...Show All

• Visual C# datetimepicker column in datagridview

  hy, maybe someone knows how to add datetimepicker column in datagridview thanks for any help All of this is from memory: The datagridview is the new construct for datagrids, correct In the datagrid days, you had to add the type of control you wanted to a column definition. Then the data itself was of that type. Once that was done the system knew to display the data in that style. Do a search on the internet for "How to display a checkbox in a datagrid". It will give you the same concepts. ...Show All

• Software Development for Windows Vista Custom Activities at runtime-debugging

  Hi, I have added designers to my custom activities. Nothing special, just colors and the like, and it works fine at design-time. But when it comes to runtime-debugging, like hitting a breakpoint in the designer view, the Live.Workflow.tmp*.xoml is missing all my custom activities completely. Error on my side or on the designer/runtime-viewer The designers are quite simple generics like: public class ScanActivityDesigner : ActivityDesigner { protected override void Initialize( Activity activity) { base .Initialize(activity); // Change the designer theme for this activity this .DesignerTheme.BackColo ...Show All

• Visual C# how long can a string be

  I have a pretty large text file, with very long lines. I am trying to read each line, match a particular field in that line (this is a comma deliminated text file) and then insert the coresponding field. I have done this and it works on most of the files. The problem is with the file that contains very long lines. It just screws everything up. It seems to either be having a problem reading the line as a string, or writing it back to a file. How long can a string be Is there some other method besides streamwriter/reader that can deal with very large lines of text Thanks. No, we can't safely assume that a Syste ...Show All

• .NET Development The best way to connect to a access database

  Hi. I am using vb.net 2005 prof. When i connect to a database (access) with a datasource (the build in way), and the program are running, it seems like it takes forever to load the database. Is VB really loading the intire database to memmory That would be a problem if it's at realy big database. I have changed the code, so i connect programmaticly and it is much faster, but why does vb load the entire database I was realy exited when i started vb.net, it was realy easy to connect, and work with databases, but it's no use, if vb is loading the entire database to memory. What is the best way to connect to at database Could anybody gi ...Show All

• SQL Server How do you get rid of parameters?

  i write  a sql statements and i was passing parameters but now i do not need parameters so i removed from my sql statements but when i run my report it still asking for the parameters but i make sure that there is no parameter expecting in my sql statements any help In report designer in layout mode, click on the report menu -> report parameters and remove the parameters you no longer want. Note: there are query parameters (on the dataset properties) and there are report parameters. The mapping between query parameters and report parameters can be modified on the dataset properties dialog. ...Show All

• Visual Studio Team System Change priority from integers to strings

  I've been customizing the Work Item template in the MSF Agile template. So far I've made good progress in implementing the states (Active, Closed etc) that we currenlty use. For Priority, we currently have High, Medium, Low, Memo but when I change the Microsoft.VSTS.Common.Priority type from Integer to string and added these values, it throws the following error when I import the template: Exception Type: Microsoft.TeamFoundation.WorkItemTracking.Client.Provision.ProvisionValidationException Exception Message: TF26038: Field type for Microsoft.VSTS.Common.Priority does not match the existing type. It was Integer, but now is String. ...Show All

• .NET Development Using DataReaders

  Im currently trying to retrieve info from the database so that i can eidt it. I have declared my reader as follows: Dim objReader As OleDbDataReader = objSelectCusDetails.ExecuteReader However when it compiles, it doesnt come up with any errors but jsut as the form is about to load, theres an unhandled exception at the line in blue above. anyone see why this is the case It's rarely (okay, never) a good idea to run code (especially data access code) with an execption handler. The reasons why this code would fail would fill a chapter in a book--kinda like the one I wrote. S ...Show All

• Visual Studio 2008 (Pre-release) App throws exception if property value is mis-spelled

  If I use the proper English spelling of "Grey", I receive a runtime exception that isn't very helpful. eg. < Canvas Background = " Grey "> FatalExecutionEngineError was detected Message: The runtime has encountered a fatal error. The address of the error was at 0x7f570c2b, on thread 0xb8c. The error code is 0xc0000005. This error may be a bug in the CLR or in the unsafe or non-verifiable portions of user code. Common sources of this bug include user marshaling errors for COM-interop or PInvoke, which may corrupt the stack. Granted the Xaml view does underline the word and provide a tooltip, if I hover ove ...Show All

• Visual Studio 2008 (Pre-release) Generate Proxy class with MSMQ

    I have a server class in a console application project, the app.config file is: < services > < service type = " ServicioWCF_MSQM.CalculadoraService " > < endpoint address = " msmq.formatname:DIRECT=OS:.\private$\MsmqTransactedQueue " binding = " msmqIntegrationBinding " bindingConfiguration = " CalculadoraBinding " behaviorConfiguration = " MatchAllEndpointBehavior " contract = " ServicioWCF_MSQM.ICalculadoraQueue " > </ endpoint > </ service > </ services > < bindings > < msmqIntegrationBinding > < bi ...Show All