cpaw88's Q&A profile

• SQL Server Sorting Vs Indexing

  what is the difference between sorting and indexing.. It depends. It is a performance and diskspace issue. The general answer for a database that is constantly being modified is never sort it, and always index it. Sorting is only valid with a fixed or read only database. Once you add a record the data file is no longer sorted. The time to read a sorted file also grows with the number of records. A indexed file has a finite maximum access time, typically around 4 disk reads to find the record needed. Think about a name and address data file that you will constantly access in alphabetic order but you are constantly adding new names as needed. This is a perfect canidate to index on the name field. If you relied on a sort it would ...Show All

• Visual C++ running created program

  I have created a program and compiled it, now how do I run the program so I can use it Marius Bancila wrote: F5 is for running it in the debugger. Ctrl + F5 will run it. and Don't forget to Set Break point in your Code to debug the app. Thanx ...Show All

• Visual FoxPro vfpencryption.fll

  hi all, i came across a library file to encrypt and decrypt from tis website.http://www.sweetpotatosoftware.com/SPSBlog/PermaLink,guid,23a74c5d-5173-420e-af23-22494d95a54c.aspx after i download the fll files i try encrypt but vfp prompt me invalid library file. set library to c:\windows\desktop\vfpencryption.fll. where is my error Thanks in advance. Some additional information regarding the file would be helpful in figuring out what is going wrong for you. You could also consider sending me a file and code that will repo the problem so that I might look at it... my email address is available on my website. ...Show All

• Visual C# Trouble adding WMI code to C# application

  Hi, I'm not sure where to begin but I am a system adminstrator who runs vb scripts for simple tasks. I would like to change these scripts from a command prompt to a nice gui screen for the other admins to use. Microsoft published the WMI Code Creator which was very helpful in making the code in Visual Basic Script but not sure how to use the C# version Basically I tried to enter this code into a very simple Windows form and made a single button to execute it. Can someone point me in the right direction :) Here's the code in Visual Basic Script. Just checks for the Application Management service start mode. strComputer = "." Set objWMIService = GetObject("winmgmts:\\" & strComputer & "\root\CI ...Show All

• Visual Studio Team System Problems Branching Database Projects

  I have some problems with Branching a Database Project in TFS. If I have a db project (let’s say Master) and now branch this as Branch1. I think both projects have the same ProjectID and will get the same run time evaluation DB (MASTER_<PROJECTGUID>). I think if i work in parallel (or after another) with these both projects it will mess up the (shared) evaluation DB. Is this a scenario which is supported on this product or am I trying to achieve things which are not supported Kind regards, Ralph Hi Gert, just to clarify the workflow. So after branching the Project I have to manually change the runtime validation database name in the <projectname>.dbproj.user file. I tested It and this works. Bu ...Show All

• Visual Studio 2008 (Pre-release) Extension method problem

  I'm currently build a project intend to take advantage of Extension Method for my model object. What I want to do is add a common method "Save" to all model object. Here is the static class for declaring extension method. public static void Save<T>(this T entity) { ... } I can pass the compilation for these code. However when I try to use this method in the controler code, the compiler raise an exception 'Polease.Enterprise.Common.Persistance.DataContext' does not contain a definition for 'Save' After that, I try to make thing much easier, change the extension method to public static void Save(this object entity) { ... } and then modify my calling code, the compiler still raise the same issue. I hav ...Show All

• .NET Development Xsd.Exe problem or my Xsd?

  Im trying to Read an Xsd in a DataSet, like: dsDataSet.ReadXmlSchema( @"\\test2.xsd" ); But its throwing an exception, like Exception: Type 'http://tempuri.net/test/ts:AddressLevelType' is not declared, or is not a simple type. Even throwing the above exception while Trying to convert the test2.xsd in to Class/DataSet using Xsd.Exe utility. Is it the problem with my XSD file Without seeing the content of your xsd file, it's hard to guess what the problem is. But first, please check this KB article: http://support.microsoft.com/kb/317611 ...Show All

• Visual Studio On Drillthrough opening a new window

  Hi, I have created Local Reports using Report Viewer in the VS 2005. In these reports i am using drill through for navigation from one report to another. Now the requirement is such that while drill through i need to open the second report in a new window .. Is it possible to open the drilled-through report in a new window by setting up some property... It will be a great help if i could get a code sample. Thanks in advance.. Regards, Shikha No there isn't a setting that allows you to do this but you can work around it. This would include adding parameter handling to your web page. The way you can do this is in your report you can jump to url and load the report and its parameters. =void(window.open('htt ...Show All

• SQL Server Calling a child package from the Main Package

  I need to pass variables from the parent package to the child package. I got this to work in a small test case. But in the actual project, I get an error when I try to do that. The parent package's log has this error : Error: Error 0xC0012050 whike loading package file "c:\.......". Package failed validation from the ExecutePackage task. The package cannot run.. There's nothing more to go on here in the log. Any ideas -chiraj I forgot to mention this. The more important reason why it started working is when I set the property "ExecuteOutOfProcess" to true. By default it is false. I guess there are some memory /thread issues and it was choking. -chiraj ...Show All

• .NET Development How to insert date into postgres

  Hi all, I had declared creationDate as "timestamp without time zone" in my postgres database. But when I wanted to insert the creationDate to the database, it gives me an error [0] {ERROR: 42703: column "creationdate" of relation "employee" does not exist} object {Npgsql.NpgsqlError} My code is as follow: today = DateTime .Now; NpgsqlCommand command = new NpgsqlCommand ( "insert into employee (username,password, email, dept, creationDate) values('" +NewUserID+ "','" +NewUserPwd+ "','" +Email+ "','" +Dept+ "','" +today+ "')" , conn); Int32 rowsaffected; try { rowsaffected = command.ExecuteNonQuery(); lblEr ...Show All

• Visual FoxPro System resolution

  Hi. How can I find out what the system resolution is, and how can I change it via FoxPro Thanks If the form is too short, the correct solution is to group your sets of controls in some logical way and place them in different pages on a PageFrame control. If the process of filling the form is formalized in a set of steps (e.g. step #2 must be done after step #1 and not jump to it directly), then you could use a wizard which is nothing more than a PageFrame with no page tabs showing and you control the page change programmatically. ...Show All

• Visual Basic How to call a javascript from a console application in vb.net

  I've created a vb.net console application which extracts data from a given webpage, using webrequest. 'Create webrequest Dim wrqUrl As WebRequest = WebRequest.Create(strUrl) 'Create webresponse Dim wrpUrl As WebResponse = wrqUrl.GetResponse() 'Create Streamreader Dim srUrl As StreamReader = New StreamReader(wrpUrl.GetResponseStream()) I then have some logic that reads every line in the stream and extracts any possible wanted data. This works fine.. but, I encountered a webpage (aspx) which I'd like to read where the content is determined by a javascript. How can I make my console application 'trigger' this javascript The script looks like this: <script language="javascript" type="text/javascript"> <!-- function __doP ...Show All

• Visual Studio Team System Proxy statistics website not available

  I have been logging about my proxy problems already in some other thread but haven't got that much response. ( http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1216865&SiteID=1 ) So this is a new post with a new problem that hopefully could lead to a resolution for the other problems as well. When I try to access the statistics page, I'm getting a login dialog and whatever account I use it always ends up in an "Access Denied" error. I installed Fiddler to find out what really happens. Fiddler shows a severe error with no response information. The properties of the failed session displays: SESSION STATE: Aborted === FLAGS ==== X-CLIENTIP: 127.0.0.1 X-CLIENTPORT: 4115 I have no idea where to go from h ...Show All

• Microsoft ISV Community Center Forums macro for automatically creating data labels in excel chart

  Hi all, I'd like to write a macro in for excel to create automatically a chart, i have no experience in this field. I use the following code: Sub Macro1() ' ' Macro1 Macro ' Macro recorded 8-6-2006 by CTW ' ' Keyboard Shortcut: Ctrl+m ' ActiveSheet.ChartObjects("Chart 1").Activate ActiveChart.ChartArea.Select ActiveChart.SeriesCollection(1).XValues = "=Sheet1!R1C1:R2C1" ActiveChart.SeriesCollection(1).Values = "=Sheet1!R1C2:R2C2" End Sub This code works well, but i want the following to do: every time pressing Ctrl+m I want the used data for the chart move 2 rows below, so I can visually scroll through the data. for example: Ctrl+m gives chart of: x value: Sheet1!R1C1:R2C1" ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Strange DX9 vertex glitch

  As seen in these two screenshots, Glitch 1 Glitch 2 In reality, I don't know what's even happening to my vertices. This doesn't happen from the beginning of the program execution, it happens randomly during the execution about a few minutes into running it. Once it happens, it will happen more frequently and sooner during the program execution when I re-compile and run.I just don't have a name for this. It happens to a handful of random vertices. I would like to think my vertex buffer is being corrupted, but when I use the D3D Debug tools, the problem doesn't happen at all.For more information, the first picture contains geometry that is rendered directly to the screen. In the second, I'm rendering geometry first to a render target, and ...Show All