Dan Miser's Q&A profile

• SQL Server Aggregate Function: AverageOfChildren

  I am using the Aggregate Funtion: AverageOfChildren for a Measure. I want to write a equivalent SQL query for the same. Any suggestions as to how can I ge the AverageOfChildren aggregation in a SQL query. Thanks.   ...Show All

• Visual Basic Task Scheduler COM Object

  Hello, I need to use the Task Scheduler API in a Visual Basic .NET program I am writing and I can't find the COM Library in the Add Reference dialog. What is the Component Name of the library that houses the Task Scheduler API Thanks in Advance. I don't think there is built-in support for that in the .net framework. However, Eduardo Morcillo has made something for that: http://www.mvps.org/emorcillo/en/code/shel ...Show All

• Visual C# Emulate mouse clicks and key typing

  hey ppl... how can i emulate clicks for example if i want to send a click to a specific locaiton i think i need to move the cursor with the Cursos property and then how can i send a right or left click ... and how can i emulate keyboard typing ,,, is there any API or something thx mig16 ...Show All

• .NET Development ClassDiagram

  First I need to now haw to represent a collection association in c# ClassDiagram Finally I write program how send mail in c# using SMTP. There aren’t any error in the compilation but mails don’t arrive at destination can you help me or give me another solution to send mail with out SMTP service If you could tell us what went wrong with your code or tell us about the exception and stack trace that would be better. ...Show All

• Visual C# How do you initialize structure?

  c# seems to complain when not all members of the structure is assigned. Anyway to give a structure initial values Hi, you can't initialize structure's fields/variables like you do with a class, you have to use functions or by accessing the field directly. class A { int i = 0; // ok } structure B { int i = 0; // error } ...Show All

• .NET Development Operator not valid for type 'DBNull' and type 'Integer'

  Not positive if I'm in the right forum, but if I'm not, I've no problem with this being relocated.   A page I had working at one point has decided to give this error: Operator is not valid for type 'DBNull' and type 'Integer'. I've commented out the last portion where it calls another sub to no avail, So the error is somewhere amongst this code: Public Sub add_click(sender As Object, e As System.Web.UI.ImageClickEventArgs) If Ses ...Show All

• Visual Studio Team System Reports for all the projects.

  Hello. My company currently is making java software and they have a freeware bug tracker called Mantis.  They put all the bugs in that software and they generate reports for all the bugs on all the projects. As far as I know team foundation creates some databases but the Portal created is ONE for ONE project. The question is: Could I make a report that joins me all the projects on team foundation server I need this because my company has s ...Show All

• SQL Server Bug: "ALTER TABLE *** WITH NOCHECK" does not work for SQL Server 2005

  I wanted to turn off 'Enforce Foreign Key Constrain' using SQL. However, it did not work on the SQL Server 2005 database. For example, running following SQL in Management Studio, and the result showed that 'Enforce Foreign Key Constrain' property for the newly created constraint was still enabled. ALTER TABLE [dbo] . [Tags] WITH NO CHECK ADD CONSTRAINT [FK_Tags_C hannelID] FOREIGN KEY ( [ChannelID] ) REFERENCES [dbo] . ...Show All

• Visual Studio Team System other recurring TFS errors in event log

  for some reason at about 3:15am this morning my TFS server started spewing the following sequence of errors: #1 ================================================== Soure: VSTF Source Code Control An exception has occurred in a Team Foundation component. Technical Information (for the administrative staff): Date (UTC): 5/6/2005 2:32:02 PM Machine: DPMSERV1 Application Domain: /LM/W3SVC/4/Root/SCC-4-127598594375000000 Assembly: Microsoft.Vis ...Show All

• Smart Device Development how to transfer data to PC

  Hi, i need to transfer some data  to computer via port some port... ActiveSync can by used. But impuls of transfer will come from PDA. And also i want to know how to copy files prom PDA to PC - also impuls from PDA. Everithing i want to do under .net CF. can you give me som advice Thank you. >I need to transfer some data  to computer via port some port... ActiveSync can by used. But impuls of transfer will come from PDA. ...Show All

• SQL Server Group Filter Not Working

  I'm developing a simple client application, using local reports populated from a local dataset, which is in turn saved and read from xml.  I am trying to set up a VERY simple group filter expression and I'm running into problems.  What I want to do is display all rows where a date column matches a parameter passed to the report.  I'm setting the filter up using something like this: Expression     &nbs ...Show All

• Visual Studio 2008 (Pre-release) Adding query results to a List, can it be done?

  I've been testing linq and I'm wondering if this can be done.  The code compiles fine but crashes when run. I'm trying to get LINQ to create a new instance of my class for each result set that I then add to a typed list using foreach.  Now, is it not working because my class does not implement IEnumerable or is it some other reason Here's the code snip I'm trying to get to work. using System; using System.Collections.Generic; ...Show All

• Software Development for Windows Vista Public Properties on Workflows

  How would I access from an ExternalEventService a public property exposed on the workflow instance I see how to pass parameters into the workflow on creation, but how would I access them while running Garick, You should pass these values as parameters with the CallExternalMethod activity. IE if your interface looked something like: [ExternalDataExchange] interface IFoo { void Bar(string prop1, int val2, Guid g); } ...Show All

• Visual Studio Team System Application locked - error creating configuration section handler

  I am using the patterns and practices Enterprise Library for .NET Framework 2.0, so the web.config files of my middle tier web services of my app contains configuration for the enterprise library exception handling and logging. For example: < xml version = " 1.0 " > < configuration >   < configSections >     < section name = " exceptionHandling " type = " Microsoft.Practices.EnterpriseLibrary.E ...Show All

• Visual C# Process

  Ok. In a button_click event, I start a Process to run a program on my desktop. And in another click event the Process method is supposed to start a different program on my desktop. But when I try to run it, I get the error message saying that the Process is already in use. Can someone tell me how to fix this. ...Show All