Preeteesh's Q&A profile

• SQL Server Optimizing Query to Run

  I'm trying to get a query to run which looks at completed orders that have not had another paid order in 180 days. The database I'm running it against is very large so I can't get it to complete. Where's what I've got: select Date =cast(cl1.cl_rundate as datetime(102)),count(cl1.cl_recno) as 'Completed Initials', cl1.cl_status as Status from dbo.vw_Completedorders cl1 where cl1.lob_lineofbusiness = 'aaa' and cl1.cl_rundate > '20060801' and not exists ( select cl2.cl_company from dbo.vw_Paidorders cl2 where cl2.lob_lineofbusiness = 'aa'and cl2.cl_company = cl1.cl_order and cl2.cl_rundate > '20060101' and datediff(day,cl2.cl_rundate,cl1.cl_rundate) < 180) group by cl1.cl_status, cl1.cl_rundate ...Show All

• Visual Studio Web.config/user.config renamed to x.config.exclude

  We use Visual Studio 2005 and the most recent incarnation of Visual SourceSafe. In order for my developers to have different connection strings on their development boxes, I elected to use the "file=user.config" attribute of the <appSettings> tag in the Web.config file (the information in user.config, when present, is used in place of the content in the tag itself. The whole point of this is for there to be a file outside of SourceSafe that can have different versions on each dev pc.  Only, when user.config is added to the same folder as the Web.config file, it is also added to SourceSafe automatically.  When, in Visual Studio, you choose "Exclude From Project", it just renames it to "user.config.exclude", which only ...Show All

• Visual Basic Help with Post Message

  Declaration: <DllImport("user32.dll", _ CallingConvention:=CallingConvention.StdCall, _ CharSet:=CharSet.Auto, _ EntryPoint:="PostMessageA", _ SetLastError:=True)> _ Shared Function Post( _ ByVal hwnd As IntPtr, _ ByVal wMsg As Int32, _ ByVal wParam As Int32, _ ByVal lParam As Int32) As Int32 End Function Constants: Public Const WM_LBUTTONDOWN As Int32 = &H201 Public Const WM_LBUTTONUP As Int32 = &H202 Sub: Sub LeftClick(ByVal Handle As IntPtr, ByVal XCoord As Int32, ByVal YCoord As Int32) Post(Handle, WM_LBUTTONDOWN, 1, XCoord + YCoord) ' Left mouse button down Post(Handle, WM_LBUTTONUP, 0, XCoord + YCoord) ' Left mouse button up End Sub Problem: This met ...Show All

• SQL Server delete multiple rows with 2 ids

  Hello All, I have a table: idSurrogate int identity id1 int id2 int id1 + id2 is a unique index I need to delete multiple rows from the table given a list of id1 and a list of id2 In other words @id1List = '10,20,30' @id2List = '1,3,5' I need to delete these 3 rows from the table 1) @id1=10 and @id2=1 2) @id1=20 and @id2=3 3) @id1=30 and @id2=5 I am a bit lazy today - can anyone help out with a delete sql stmt Thanks! Lazy...big time...I would never respond to this...but Delete from MyTable where ISEVEN(@id1list) = TRUE OR ISEVEN(@idlist2) = FALSE OR Delete from MyTable where @id1 mod 10 = 0 OR @id2 mod 10 <> 0 Write a UDF (User Defined Function) Adamus ...Show All

• .NET Development Inheritance Issues with base class parameter

  I have an abstract base class Person that my concrete Employee class inherits from. My web service take anything that can be cast to a "Person" as a parameter. When not using inheritance i modify my proxy autogenerated class and strongly type the parameter and it works fine. When i try the same, but this time using inheritance i get the following : "Use the XmlInclude or SoapInclude attribute to specify types that are not known statically." I have put two XmlInclude elements below the [WebMethod] of the service telling it about the concrete class and the base class. What am i missing I am using VS.Net 2005. thanks, Steven. You do not need to edit the proxy: adding ...Show All

• Windows Forms Connection String

  I'd like my app. to connect to the DB in the folder that will be in the user's computer when I install it. I don't want to have to change my connection string path everytime I install my app. on a new computer. Using ADO.NET, how do I make my app. to connect to the DB everytime it's run regardless of the app.'s location eg: Dim csWBoard As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:Projects\Whiteboard\WhiteboardDB.mdb" Will the above code work If not, what will This may sound stupid but, how do I go about doing that And maybe I should ask my question in a different manner: How do I make sure that when I install my app. on a new computer, the DB is installed automat ...Show All

• Visual Basic [OTP]help finding program

  im getting an error loading message and i need help finding the file that my computer cant find I would guess that this is a duplicate of the thread http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=810203&SiteID=1 In which case this problem isn't even related to a development or .NET issue. ...Show All

• Visual Studio 2008 (Pre-release) Hosting a WPF user control in VB6 applications

  Has anybody ever wanted to host a WPF user control in a VB 6 application If so how can this be done. I have seen how this can be done from a Win32 C++ application. So, the answer is yes and it turns out that it's not all that difficult, although there are some caveots Here's the details: 1) For this to work, you need to install and use the interop forms toolkit 2.0 which will be released later this month. You can check this link/forum for further details. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=604443&SiteID=1 2) This toolkit has a new feature that allows you to easily create an activex usercontrol built in .net that you can then add to your VB6 applications and use. 3) Us ...Show All

• SQL Server Beginner's questions

  Hello, I have two database servers that I am interested in sending messeges between them. I am not interested in security or encryption at this point, only a simple message sending and recieving. Can someone please provide simple scripts for object setup (certificates, queues etc) and message send and recieve a link to such a script will be great as well. I am just a bit lost understanding all the new concepts (certificates, service, service binding.....) Thank you I. Thanks but I was talking about the Begin Dialog Conversation and recieve commands. is it any different than recieving or sending a message localy ...Show All

• Windows Forms After running application (F5) Controls disappear from designer, now invisible

  I wish I could post my entire form on here for inspection. Anyway I will try to explain the best I can on what is happening. I developed this application using VS 2003. I have a form with a tab page with 5 pages on it, on each page I have a few controls including TextBoxes and NumericUpDowns that are binded to a DataView on my form from a method called from my constructor. My NumericUpDown controls are set to display tenths and have an increment of 0.1. In .NET 1.0 I had an issue that the value would not be validated correctly when I clicked off the control. For example.. I type in 15 as the value (at runtime). I click off the control it remains "15". However if I press the enter key it will actually accept the value a ...Show All

• Windows Forms Regarding changing Font size and the application getting crashed.

  Hello all, I am facing problem which is very strange.This is regarding the Changing the system language to Dutch(Netherlands) and dynamically chanfing fontfamily to "verdana" and fontsize to a floating point number then the application crashes.Can anyone help me regarding this. If font size is an integer it doesn't crash. Can you post the code that is causing the problem along with the details of the locale being used and the font information Additionally please provide any error messages and call stack information that is generated when the application crashes. Michael Taylor - 1/9/07 http://p3net.mvps.org ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Write Text over Triangle

  Hi... I am very new in DirecX Programming. I creeated a Triangle (with positionnormal vertices) and now I want to write something over it. After using postion normal vertices, I have a length for the Trinagle 0.5f. But for the position of the text I need interger values (in Rectange). What should I do Thanks.. objectPosition * world -> worldPosition worldPosition * view -> view/cameraPosition viewPosition * projection -> screenPosition Note that screen position is in the range -1<x<1, -1<y<1 and the y axis is +ve up, -ve down whereas pixel positions are +ve down so take the screen position and do something like (screenPosition.X +1) /2 * screen width and you ...Show All

• Audio and Video Development Problem with animation

  I tried to move div element with a button from one point in another. I use following code: document.getElementById('playButtonDiv').style.animateProperty("x", "0px;350px", 3); <div id="playButtonDiv" style:position="absolute" style:x="0px" style:y="0px" style:width="60px" style:height="60px"> <button id="playButton" style:width="60px" style:height="60px" style:backgroundImage="url( 'Images/PlayButton.png' )" style:contentWidth="scale-to-fit" style:contentHeight="scale-to-fit"></button> </div> I see that animation isn't smooth. How can I do smooth animation ...Show All

• SQL Server OLE DB connections

  I have .net 2.0 framework and SQL V 8.0 on my web server. I am trying to create a DSN and I am not given the OLEDB provider for SQL as an option for my list of providers. Is there a download that will add this What do I do to get it Alternatively you could check out all these connection strings; http://www.connectionstrings.com/ carrier=sqlserver ...Show All

• Visual C# Best way to achieve this?

  I need to run a loop to check if a file exists then delete it. Once its deleted it can stop looking. However, at the time the loop starts it may not exist, but it will evntually be created. do { delete(); Console.WriteLine("Checking"); } while (check() == false); private static bool check() { if (File.Exists(Environment.GetEnvironmentVariable("SystemRoot") + @"\myfile.dat")) return true; return false; } public static void delete() { if (File.Exists(Environment.GetEnvironmentVariable("SystemRoot") + @"\myfile.dat")) { File.Delete(Environment.GetEnvironmentVariable("SystemRoot") + @"\myfile.dat"); Console.WriteLine("Deleted"); } } I gave it ago and ran into some problems. private void mainForm_L ...Show All