Dario Aznar's Q&A profile

• SQL Server Correlated subquery column referencing outer date range

  Any ideas how can I pass date range values from the where clause of an outer query to the inner correlated subquery ... without using a stored procedure because I am using Report Builder Using the simplified sql below I need the average freight charge between the dates for all of the ShipCountry's orders. (I have hard coded the dates for demo purposes only as it is these that I need referenced from the outer query's where clause.) select OrderDate, ShipCountry, ShipCity, Freight, /* how do I get to the outer query's date range */ (SELECT AVG(Freight) FROM Orders WHERE ShipCountry = O.ShipCountry AND OrderDate between '01-jan-1997' and '01-jan-2000') AS CountryAverageFreight from Northwin ...Show All

• SQL Server query

  hi, i want to achive the IIF functionality. example select iff(employee.empid is not null,'sdfsdf',iif(employee.deptid is not null,'dssdf','sdfsd')) as 'sdsd' from employee how to solve this. thank you You can use an IF in SQL. Its normally shown as IF EXISTS (SELECT * FROM Orders WHERE OrderNo = @OrderNo) THEN ...Show All

• Visual C# Versatility/Practicality of C#?

  Hey all, new to posting but ive been reading here for a few weeks. Anyway, on with my question (which probably has been asked in some way already)- How versatile is VC# compared to VC++ All I generally see are simple (*duck/cover* ) desktop applications. I've read that its possible to do game dev (including DX and OpenGL), but I have yet to find any engines done in C#. I have just looked at API's/engines/SDK's for games, but I have not gotten actually into manipulating/programming in them yet. I've done some basic reading on C# and I sort of want to get into it, but I plan on in a few years down the line working for Lockheed (or a defense contractor of some sort) or EA-Tiburon. I've been programming since I was probably around 10, ...Show All

• Visual Studio Express Editions need urgent help about access database and application!!!!!!!!!!

  hey guys i have a question: i am creating an application in which i am using an access database. I used the wizard to create the connections, data binding, etc. and the drag-and-drop-table method to display it in the form. the problem is that i am not able to (or i have not find a way to update the field of QuantityInStock) update the database. Note that i am only trying to find the code. here is my code: Public Class Form2 Dim tempInventario As Integer Dim tempInventarioenBodega As Integer Private Sub ItemsBindingNavigatorSaveItem_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Me .Validate() Me .ItemsBindingSource.EndEdit() Me .ItemsDA.Update( Me .ItemsDa ...Show All

• Visual Studio Team System Source Control Disabled

  I've been configuring (well trying to) security. somehow I've managed to disable the Source Control menu option under the Team project settings menu accress all projects. What have I done Sorry for the delay. I am still having this issue. I tried to replicate on another project, and having files checked out does not seem to be my problem. I'm still unable to change the options for one of my projects. ...Show All

• Visual Studio Express Editions How to use the BackGroundWorker??

  I have an application that pulls data out of a database based off search criteria that is set in a form. What I would like to do is have a backgroundworker setup (or something else that will do the following) that allows for more then one search to be done at a time. for instance.... I want to pull all the names of people that have a name starting with "j" and I start that search and the data starts to pour in. Then as that data pours in I want to start another search with the same form of names that start with "t" but I dont want to interupt the first search and I dont want to have to wait for it to finish. In my research I believe a BackgroundWorker is the object that can handle this so what I have done is setup a BackgroundWor ...Show All

• Visual Studio Tools for Office How to add dynamic controls to Excel Add-in

  Hello, I have an Excel Addin and i need to create dynamic controls on the worksheet. Can someone tell me if this is possible and/or give me a sample Dynamic controls I need to create are dropdowns, date control etc. The issue i am facing is I don't have a "Tools.Excel.Workbook/Worksheet" instance in Excel Addin app. Is this by-design or an i missing something Is there a work around This tool needs to work on Excel 2007, so Workbook solution is not an option. thanks, Shyam PS: I am using VSTO 2005 SE, with C#. Shyam, Cindy is right when it comes to Windows.Forms.Controls but we have two other options to use. The following VB.NET code shows these two options: Friend Sub Add_Cont ...Show All

• Windows Forms DataGridView KeyDown?

  (VS2005 - beta 2) Hello, is there anyway to capture a keypress or keydown event in the DataGridView   I know there's events called KeyDown and Keypress, but if the DGV is in edit mode, they never get caught.  My ultimate goal is to make it so pressing enter moves to the Cell to the right, instead of to the next row but I need to know what key is being pressed before I can do that. Thanks -Adam This is handy.  But I am having a problem if there is bad data in the last cell of the grid because the DataError event isn't firing when the base.CurrentCell is being changed.  Any ideas on how to fix that Thanks, Kevin ...Show All

• Smart Device Development context menu does not popup on datagrid

  Hi, I am developing a .net cf 2.0 application on a windows ce 4.2 machine. I am using visual studio 2005 and created my project as "Windows CE 5.0" project. Everything went fine except debugging, but yesterday i have came across a problem, tried to solve, searched the forums but could not find any thing... I have a datagrid (System.Windows.Forms.DataGrid) named "grdDetail" and a context menu (System.Windows.Forms.ContextMenu) named "pop" on form. I have choose "pop" on "grdDetail"s ContextMenu Property. I have built the solution and copied the executable to WinCE4.2 machine. "pop" did not popped up when i long clicked the "grdDetail". When i debug the application o ...Show All

• Visual Studio Team System what's the solution for inserting reference data?

  as we know many reference tables need data inserting before the systme run so in the DB projects, what is appropriate way to manage the script of inserting reference data The best approach is to add the reference date insertion to the Script.PostDeployment.sql script, whch is found under the Post-Deployment folder in the Solution Explorer. When you build and deploy the database schema, the post-deployment script will be run and insert the specified reference data. ...Show All

• .NET Development Need of a fast timer

  Hi, I was wondering if there were a faster timer than the control timer provided in the toolbox. I would like to take some value from a controller card at a rate of around 10-20 KHz. Or I was wondering if it is possible to have an infinite loop ( which stop when I press a buton), with a function which tells to do any events ( move mouse, paint, close...) that may appear Thank you for your answer, Eric hello dears, i need atimertick which repeat the process every 200 microsecond .what should i do i wrote my app with visual c#.net. plz help me very soon. i don't have enough time. ...Show All

• Visual C# Clone object ?

  Hello, How can clone all the properties from one object to another object For example, class A { private String name; private int age; private boolean status; ... } class B : A { private String address; } A a = new A(); (set all the properties for a) B b = new B(); How can copy all the properties from a to b Best regards, Eric   class A {   private  String     name;   private  int           age;   private  boolean  status;     protected void SetProperties( A clone)   {     this.name  = ...Show All

• SQL Server Cannot create new or change existing subscriptions

  We are having problems when creating new subscriptions or when trying to edit existing subscriptions. When editing an existing subscription, the report manager displays "An Internal error occured" message and when I look in the log the error says Only members of sysadmin role are allowed to update or delete jobs owned by a different login When trying to create a new subscription the report manager displays "An internal error occured" and the log says System.Data.SqlClient.SqlException: The schedule was not attached to the specified job. The schedule owner and the job owner must be the same or the operation must be performed by a sysadmin. We are running sql reporting services 2005 sp1. The report server database s ...Show All

• Visual Studio 2008 (Pre-release) Create ellipse where myEllipse.Opacity=.40 & Stroke.Opacity=1

  I want to create an ellipse in c# where the Fill.Opacity is less than 1 but the Stroke.Opacity of the ellipse is still 1. Also, I simply tried setting the ellipse opacity to .40 and the stroke to Black and I expected to get a gray border but it doesn’t show at all. What are the ways I can create a border around the ellipse where the fill has an opacity less than 1 Here’s me code: void DrawEllipse() { Ellipse myElippse = new Ellipse(); myElippse.Height = 10; myElippse.Width = 10; myElippse.Fill = Brushes.MediumBlue; myElippse.Opacity = .4; myElippse.Stroke = Brushes.Black; myElippse.StrokeThickness = 1; //myElippse.Stroke.Opacity = 1; //No can do: myElippse.Stroke is ReadOnly. Canvas.SetLeft(myElippse, 15); ...Show All

• Visual Studio 2008 (Pre-release) .NET WebService Studio and WCF

  Has anybody managed to get the .NET WebService Studio to generate a proxy assembly so that a WCF service could be tested All I get when I connect to an SVC endpoint (our WCF is hosted in IIS) is that the WSDL is successfully consumed, but the Proxy node looks like: //------------------------------------------------------------------------------ // <auto-generated> // This code was generated by a tool. // Runtime Version:2.0.50727.42 // // Changes to this file may cause incorrect behavior and will be lost if // the code is regenerated. // </auto-generated> //------------------------------------------------------------------------------ // // Assembly WebServiceStudio Version = 2.0.50727.42 // As a result, the I ...Show All