Gavin Lilley's Q&A profile

• Visual Studio 2008 (Pre-release) Long loading window

  Hello all, I'm a beginner in this field and I hope that somebody can help me. I have a window which take a while to be displayed and I wonder which is the best way to solve this issue. The window contain some controls which get data from an SQL server (maybe this help to understand way is taking so long). I've tried many solutions but I end up only with exceptions... What I like to have is anohter window which is displayed until the "longLoadingWindow" gets initialized. A C# code sample or any idea is appreciated. Thanks in advice. Ovidiu Howdy, What you can do is create a seperate thread that goes off and deals with your SQL connections to leave your UI thread processing wh ...Show All

• Smart Device Development Where can I get a valid certificate to sign my DLL compiled with Visual Studio 2005 for Windows Mobile 5.0 Pocket PC ?

  Hi, I have a DLL compiled with Visual Studio 2005 for Windows Mobile 5.0 Pocket PC. I would like to sign the DLL with a Windows Mobile 5.0 certificate, but where can I get it thanks in advance PS : I tried this certificate : "Smartphone Privileged Development Code-Signing for invite" but my DLL is not recognized as a valid DLL on my Pocket PC... For development needs you need to use certificates shipped with the appropriate SDK. This has a decent set of instructions: http://www-inst.eecs.berkeley.edu/~cs160/sp06/section/vstutorial.pdf For production purposed you will need to obtain a real certificate via Mobile2Market program or from Verisign ...Show All

• Windows Forms Getting rid of the drop shadow in ToolStripMenuItems' DropDownCollection

  Does anyone know if there is a way to get rid of the dropshadow that occurs at the right and bottom sides of the DropDownItems of a ToolStripMenuItem. I've tried using a custom renderer but I can't find where the drop down is being called. When its all said and done I want only the text to appear, not the background of any borders. I've managed to get rid of all of the extraneous stuff by simply overriding all of the relevant methods and doing nothing in my custom renderer (which inherits from ToolStripProfessionalRenderer) but I can't find where the drop shadows are being drawn. Does anyone have any idea how I can accomplish this Thanks! Jeremy Bad news: it is a system setting. Control Panel + Display, Appearance, Effects, " ...Show All

• Windows Forms ADO Control

  hi I have seen programs that bind a DataGrid to an ADO Data Control. But i want to know, how to display the fields in Edit Controls. Is there some way to bind the Edit control to the DataSource(ADO Control). DataGrid can set datasource that is source for the whole datagrid Normally we bind a whole table or view to the datagrid, then choose columns we need to display. what do you mean bind Edit control to source does it mean you want bind cell one by one please show me a little detail:) ...Show All

• SQL Server Problems converting varchar to smallmoney

  Hi My ticket engine stores values in varchar . The sql db-field that corresponds was created as smallmoney . The below statement works for conversion of "leavedays" if the given value is entered without any decimal places (E.G. 4) As soon as a user enters a value that includes decimal places (E.G. 4.5) the conversion will not work. In this case the value 4.5 is rounded to 5. What do i have to do to convert the value as it is entered by the user Thanks in advance t. Statement: INSERT INTO leavereq (mitarbeiter, startdate, enddate, leavedays, remainingdays, approvedby, approvedon) SELECT {0} , convert (datetime, {1}) , convert (datetime, {2}), convert (numeric, {3}), convert (numeric, {4}),{5}, getdate( ...Show All

• Visual Studio Feedback on Prototype Style in Sandcastle

  I am looking for customer feedback on the "Prototype" style in Sandcastle. It will be great if you provide me with input on redisign of member pages with tabs and our use of language filers in this style. Also should we adopt this "Prototype" style for our official documentation shipped in future versions of Visual studio Waht do you think I will blog about the details on "Prototype" style seperately. Cheers. Anand.. I prefer the Prototype style to the old VS2005 style. The Prototype style puts more information on the home page of a class, rather than splitting it between an overview page and a members page. The Prototype style has a nice breadcrumb toolbar along the top for exploring the n ...Show All

• Windows Forms Changing (.Net fx 1.x Windows control) DataGrid Row height programmatically

  Hi All, I am working on .Net fx 1.x Windows application, where i am facing a problem of changing the height of the row of datagrid, programmatically. I've found a way in which we can change the height using reflection, and this approach works fine. However, i would appreciate if any one can suggest the way where we can change DataGridRow Height using tablestyle or any other way than reflection. In .Net 2.0 it's quite easy. But unfortunately i want this to be done in .Net 1.x Framework. Thanks in advance. Sraddhan. Hi,sraddhan It's impossible to achieve that other than reflection,I wonder why do you want to change the row height It would auto size its height to fix the content. Have a ...Show All

• SQL Server SQL Update with id

  Hi I have a Excel sheet in this i have to take out a id and then search in the SQL DB if there is a Id like this and update some fields. I have it allready in Access but i need to have it in SSIS i have everthing exept the Update itself. I take the Id from the XLS and then i go to the DB and look if there are some of this ids in there. i "Merge Join" then then there are some left (5-10) now i wanna say take this IDs and update it on the DB but i search for so long now. I'm sure it have to be easy. Yes this i did but what i do after if i want the marged data to be Updated in the Database. How can i use a SQL Update with joining 2 Tables in a WorkFlow ...Show All

• Audio and Video Development Directx 10

  I wanted to know if to run directx 10, I have to change windows(xp to vista) and to buy a new graphical plate At the moment there is no graphics hardware that supports the directx 10 system... to use it you have to use the software device. In the future there will be graphics hardware that you can use, but for now software is all we have. "Samples and applications built with the Direct3D 10 Technology Preview in the June 2006 DirectX SDK require Windows Vista Beta2 to run. The Windows Vista Beta2 will be available to MSDN subscribers." From the SDK Readme . ...Show All

• SQL Server SMSS SQL SERVER 2005 canned reports greyed out

  How does one make the canned SMSS reports such as disk usage available from 1.) Local workstation for administrators of SQL can run then on SQL instances from the Object view of Management studio. All we see is the reports tab greyed out. 2.)From a reports server. Yes, I know these seems rather basic but it seems there is a right way to make this occur and a wrong way. MDSN has yet to give up this information to me. If anyone knows the links or answers kindly post in the blog and also email me at brucehelp@yahoo.com . This link covers the discussion but does not have the methods to achieve the installation of the canned reports. http://blogs.msdn.com/sqlrem/archive/2006/05/16/SSMS_Reports_1.aspx "Did ...Show All

• Visual Studio Team System Work Space issue

  I was just brought onto a project as the Build Manager just about a month ago. I am a MCSE not a MCSD. The old Build Manager left the company and we are attempting to resolve a few issues with this server. First is the mapping of the workspace. I see the workspace that was used. I am unable to map to that space as the server still thinks it is being use. I have read a number of post talking about command line “tf” command. However on the server I am unable to get this command to work at all. Whenever I attempt use this command I receive the error saying this is not a recognizable command. How then can I determine who is linked to the required folder I have also attempted to look in the C:\Documents and Settings folder st ...Show All

• SQL Server Viewing the Contents of a Stored Procedure

  Is there a way to view the contents of a stored procedure (MSSQL 2K) in the Query Analyzer maybe using system stored procedure K ...Show All

• SQL Server Reporting Services 2005 BestPractises Question

  Hi, We're starting to migrate from Crystal Enterprise to SSRS2005, and had some performance-related questions in relation to complex reports running against large tables. Scenario: . We have fairly large source tables, some greater than 5 million rows . We use fairly complex stored procs which use dynamic sql based on about 10-15 search criterias entered on web page . Currently our web middle tier calls a stored proc which inserts into a report table. Then UI calls the report which has SQL query to filter the report table on the UserId and shows only the rows for that user. Question: . Is this method - running stored proc in app which inserts into table, then asking report to filter the table based on UserID - consider ...Show All

• Visual Studio Team System [URGENT HELP NEEDED!] Unit Tests fail because of connection string problem

  Hi all, I am part of a six member group which is developing a hospital information system in the .NET platform using ASP.NET 2.0 and VSTS. Our solution has a website (SMUHPMA), a class library (SMUHMPMALib) which stores the base classes and controller classes and test project with stores the unit tests(SMUHPMATest). Now a number of the classes in SMUHPMALib interact with our database (SMUHPMA.mdf) which is stored in the App_Data folder of the website project (SMUHPMA).   We make a connection with the database in these classes using the following connection string: System.Web.Configuration.WebConfigurationManager.ConnectionStrings["SMUHPMADB"].ConnectionString; The web.config file which defines this ...Show All

• SQL Server Help with CURSOR

  We have a tree structure containing section names. Each node is a section name and each section can have subsections. I have to copy the tree structure but need to maintain the parent-child relationship established within the id / parent_id fields. How do i acheive this For example i have the tree Section 1 |-Section 1.1 Section 2 |-Section 2.1 The "Section" table contains 3 fields: id, parent_id, and caption. ID is the identity of the section record and parent_id contains NULL or the ID of this record's parent to create a child. So "Section 1" (id=1, parent_id=null), "Section 2" (id=2, parent_id=null), "Section 1.1" (id=3, parent_id=1), "Section 2.1" (id=4,parent_id=2). I would like to ...Show All