Tim Whtiley's Q&A profile

• SQL Server Query performance

  I have a query as follow Select product.name, vendor.name from product join vendor on product.vendor_key = vendor_key Vendor_key is the primary key on Vendor Table If I want to increase the performance should I use Stored Procedure or create index for the vendor_key on Product Table The first thing to check is that both tables have indices on the linking columns. Vendor(Vendor_Key) is a PK, so it is automatically indexed. Does Product(Vendor_Key) have an index ...Show All

• Windows Forms wildcard in table adaptor problem

    Hello  I have come across a problem today when working with data sets/table adapter in vs05 for use in ASP.net. SELECT  ws_Agent.Telephone, ws_Agent.Email, ws_Agent.Name, ws_Agent.AgentId, ws_Agent.forename, ws_Agent.surname, ws_Agent.Acc_PcentreID, ws_ProfitCentre.ShortCode, ws_Branch.Name AS branchname, ws_Branch.ManagerId,             ws_Branch.Fax AS branchFax, ws_Branch.Telephone AS branchtelephone, ws_Branch.Address1, ws_Branch.Address4, ws_Branch.Postcode, ws_ProfitCentre.Telephone AS PCentreTelephone,             ws_ProfitCentre.Status AS PCentreStatus, ws_ProfitCentre.Fax AS PCentreFax, ws_Pr ...Show All

• Visual Studio 2008 (Pre-release) varchar(max) causing a FormatException to be thrown

  I have a weird problem when using varchar(max) on the table columns using linq. If i write (as an example): [Column(DBType="varchar(128) NOT NULL", Name = "strTest", Storage = "strTest")] i have no problems, but if i use the following [Column(DBType="varchar( max ) NOT NULL", Name = "strTest", Storage = "strTest")] i get a FormatException thrown telling me that the 'Input string was not in the correct format' has anyone had a similar problem Thanks I have also noticed that if you use sqlmetal to create the classes you need for linq and have a field of varchar(max) in any of the tables, sqlmetal will place (as an example): [Column(DBType="var ...Show All

• Visual Studio Consuming a webservice

  what are the steps to consume data from a web service in the report viewer control I am assuming that we need to configure an object datasource for this. but i am not getting any documentation on this. Thanks Brian. That is the only website that has decent documentation for report viewer. But it doesnt detail on consuming web services though. ...Show All

• Visual FoxPro Dbf Autoincrement with ADO

  Hello everybody, I created a table with an autoincrement field( CREATE TABLE `Synch_LogFile` ( `ID` I Autoinc NOT NULL, `TableName` C (100) NOT NULL, ...) ) when I try To open it by ADO with VB (Select * From Synch_LogFile) I get this error message: [Microsoft][ODBC Visual FoxPro Driver]Not a table. What's I'm doing wrong Thanks, 1) it will not work with ODBC and newer table capabilities such as autoincrenent fields as I said. On top of that you are invoking MSASQL and nto VFO ODBC Driver 2) Should work with OleDb Provider. What is your code to update What is the failure error message Remember you cannot/should not write to the autoinc field as it fills automatically. Also remember to provide values for any columns wit ...Show All

• Microsoft ISV Community Center Forums Setting ChartObjects Properties throws Run-time Error '1004'

  I have been trying to figure out what is wrong with this macro for a month now. Can someone please help me, I give up I have columns of data ranging from A to EK and 352 rows of data for each. Each column will be a new dataset and therefore a new chart. Each set of 5 columns is a group so after I go through 5, I offset the output column for the charts by 7 and start a new group. It throws really random Runtime Errors '1004 ' , like "Unable to set the Size property of the Font class" or "Method 'HasTitle' of object'_Chart' failed." One day it will be the Legend object, then the Axes. There doesn't seem to be any consistent error besides the fact that it progressively quits creating charts the more I run it whil ...Show All

• SQL Server Is it possible to edit the list of export options in RS 2000?

  Hi, I'm trying to edit the list of export options in Reporting Services 2000. I only want to display Excel and PDF in the export options list. I tried looking in the CSS file in the Styles folder, but didn't see anything that could be changed to accomplish this. Is it possible to do this Thanks, Mike Look in the RSReportSErver.config file. Add visible="false" to any rendering extensions you do not want to show up. You can also just remove them if you don't ever want people to use them (Although getting rid of html4.0 would break Report Manager.) ...Show All

• Visual Studio 2008 (Pre-release) Please help with package signing

  I am working on a project signing packages and wish someone help me answering several questions about the PackageDigitalSignature example that comes in the SDK. In order to use the package signature, what kind of certificate I must use This is because I have a free email certificate in my xp, but don't know if it is the correct one. When I run the PackageDigitalSignature example, the program ask me twice, first to select the certificate, and second, to accept the CryptoAPI Private Key. It is a way to give the name of the certificate as an argument, and to avoid having to press the OK button every time I sign a package This because we want to automatically create, sign, and send a package by ftp. Thanks for the time and hopely the answer, ...Show All

• Silverlight (formerly WPF/E) Lessons to learn or "Something's rotten in the state of Denmark"

  Recently I discovered this amazing promising new technology called WPF/E. I am not a tech guru - the lessons yet to learn are teached to me and to all the other people out there working hard on every day webdriven software. As a developer having to deal for a long term with Flash I am quite upset with its shortcomings - it is always basicaly been provided so much functionality, that is enough to build visually appealing apps to serve the current "eye candy" hype at a time, but for some more serious functuanality you would always have to rely on their server software and therefore limiting your userbase to the amount of money you are willing to spent on machines running Flash Media Server. And now there is a new 'David' stepping on the sc ...Show All

• SQL Server DTS "The Parameter Is Incorrect" Error

  I'm running SqlServer 2000 and am trying to write a DTS. For some reason I keep getting that error for my Dynamic Property Task and not sure why. I've tried giving my Package a password like was mentioned in another thread on here, but that didn't work either. I'm trying to dynamically set a Data Source for an Excel connected, using a query. Query: DECLARE @directory VARCHAR(1000) SET @directory = 'C:\' EXEC [Legacy].[dbo].[spr_GetNewestExcel] @directory The Store Procedure: CREATE PROCEDURE spr_GetNewestExcel ( @directory VARCHAR(1000) ) AS BEGIN DECLARE @cmdParam VARCHAR(8000) --Temp Table that saves the output of a DOS command. CREATE TABLE #output ( output VARCHAR(300) ) --Temp Table that saves the output ...Show All

• Visual C# Exclamation Icon cursor in IDE

  Hi, Anyone know why, when I load my c# project into VS2005, my cursor flashes as a exclamation icon (yellow triangle with black exclamation mark) This is very fast and may (or may not) do it every time. I can't see any obvious warning messages anywhere, everything appears to work. It's a real "did I just see that " thing - it's that fast, but it does happen quite often. Someone, somewhere, coded it to do that. It probably took some time to do. Shame it's not at all apparent why ! My first guess would be, besides the obvious default Windows settings, that this has something to do with an add-in. Do you have any add-ins installed ( Tools > Add-in Manager ) ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. XNA 360 games.

  Will you be able to burn game's off your computer from the XNA game studio or not Yes but i didnt mean it that way...i was talking about being able to put game studio games on your 360 without taking up the hard drive space. ...Show All

• Visual C++ what dlls to include

  hey all, i recently made (or configured to my liking) an opengl project. when i try to use it on another computer, it tell me i am missing whatever dll(like glu.dll and others i dont know). and when i do get thoughs dlls with the .exe, it opens and then crashes! can any body tell me why and cna you give me a list of dlls i need i am using the header files: glu.h, gl.h, and glut.h thanx, jt if you are using VS.NET 2005, you can check the applications manifest to find the dependency of the application. You can also use depends.exe to find the dependency of your application. ...Show All

• Visual Studio 2008 (Pre-release) How to use OnWriteStartEnvelope? Urgent, please help

  I am using WCF to create WS-Discovery and other WS-* messages. The specs all show the namespaces for a message included in the envelope tag. WCF only provides me with a way (using a BodyWriter) to put the namespace on each tag. A previous message on this forum said that the ability to add namespaces to the envelope "was cut due to resources". Is that still the case with RTM If so, would it be possible to see a sample of using OnWriteStartEnvelope to create the entire envelope for a message Or at least a snippet that would get me started I have tried creating a class that derives from Message and overridding OnWriteStartEnvelope, but it never executes, so there must be something I don't understand about how to do this. ...Show All

• .NET Development IEnumerator<T> problem

  Im building a class implementing System.Collections.Generic.IEnumerator<T> but have some problems with it. Seems like the interface requires the Current property 2x System.Collections.Generic.IEnumerator<T> .Current System.Collections.IEnumerator.Current When i do this, it says the method current allready exists :( when i dont add both properties it says the interface implementation aint correct Thanks :) Could not implement the interface automaticly cause my smart tags were not working anymore after installing linq ctp ... but i just fixed it ...Show All