Steven Gilissen's Q&A profile

• SQL Server Paging in Stored Procedure

  I got this code on internet for Stored Proc paging. This will work if my final result is the order of eployee id. In my case my final result is in the order of emplyee name. What i have to change in below code so i can have paging in SQL plus my order is by name. I dont want to create Temp table. Becuase i think Creating temp table is overhead to sql server and in that case i'll use Datagrid defualt paging and return all rows always.(My total number of rows will not be more than 300 and in 70% cases they are below 100) CREATE PROCEDURE [dbo].[usp_PageResults_NAI] ( @startRowIndex int, @maximumRows int ) AS DECLARE @first_id int, @startRow int -- A check can be added to make sure @startRowIndex isn't > count(1) -- from ...Show All

• Windows Live Developer Forums Hit Counter

  How do I add a hit counter - either from within or offered by MSN Spaces - or an outside free service like "ShinyStat" This forum is for questions about the MSN Spaces APIs. Feedback, feature requests or questions about the MSN Spaces product are probably better directed to http://spaces.msn.com/thespacecraft/ ...Show All

• Visual Studio Team System postbuild event

  Hi, Would it be possible to add a postbuild event feature to the database project I have a scenario where I would like to run aspnet_regsql.exe utility to install/merge the ASP.NET 2.0 services database into the database that I am building with VSTS-DB. I basically want to avoid creating the ASP.NET services db schema by hand (or even importing .sql files) -- I'd rather run their tool and point it at the database created by the build. The postbuild event could provide some macros (e.g. Target database name, connection string, etc) that I can then use as command-line switches to aspnet_reqsql.exe. Thanks, Vitaly Vitaliy, It is an interesting idea, but there are already a few ways to do thing ...Show All

• Visual C# how to create a runtime object

  hi, how to create an object whose type is known only at the runtime. ...Show All

• Visual Studio Express Editions Fuzzy search on DB field contents

  Hi, How would I code to search for any word within a DB field. For example: I have a column called Description and have the following info saved in one of the fields for this column, Computer Display Flatscreen. I would like to search for any of the words contained in this columns field, say Display, and fill a table with all records found. Can this be done Any help appreciated Ron that would be a LIKE statement with the wildcards % around the text to get a record containing the text given in a field, is this what you are after An example of this statement would be like this: SELECT field FROM table WHERE field LIKE '% yourTextHere %' ...Show All

• SQL Server Accessing varibles inside the ScriptTask

  Hi All, In one of my ScriptTasks, I instantiate FileSystemWatcher class and set events for it. This has been done inside the Main() method. I can access all the varibles declared in the SSIS package inside the Main() method ( by using Dts.Variables("").Value ) but none can be accessed inside the event methods. One possible reason for this can be, events might be running in different threads. Now my question is, How the varibles can be accessed inside the event methods. Hope someone can give me a solution. Appricate all your solutions. Thanks SL Coder wrote: Hi, I tried the Daniel's method but it didn't work for me. The actual code looks like below.... to show you the exact problem. ...Show All

• Windows Forms StatusStrip - SizingGrip problem

  Hi I've added a StatusStrip control to a form. Within this I added a ToolStripProgressBar , and set it's Alignment to "Right". Now I have the progress bar next to the SizingGrip. If I now set "SizingGrip = False", the sizing grip is removed, but there still is an empty area left. I now have an ugly space between the progress bar and form border. How do I get rid of this area Kind Regards If I set the RightToLeft to true, I get the empty area to the left (where I have a Label control). So it RightToLeft does not solve the problem. If you turn on 1. RightToLeft = False (StatusStrip) 2. SizingGrip = False (StatusStrip) 3. LayoutStyle = HorizontalStackWithOverflow (StatusStrip) 4. ...Show All

• SQL Server SELECT Query duplicating rows

  Hi, I have a small problem that i cant seem to get my head around regarding the results of the following SELECT query. The result set contains two rows for every Employee - one for Annual (EntitlementID = 1) and one for Long (EntitlementID = 2) Where have i gone wrong Thanks in advance. --Tables: Employee (EmployeeID, EmployeeCode) -- EmpEntitlementValue (EntitlementID, EmployeeID, Balance) -- Entitlement -- Department -- Position -- Contact (FName, LName USE Employees go SELECT EmployeeCode As 'Employee Number', FName + ' ' + LName As 'Employee Name', Department .[Name] As 'Department', Position .[Name] As 'Position', CAST(DAY(DateStarted) ...Show All

• .NET Development Spell Checking Library

  In .Net 2.0, does it provide a spell checking library with the ability to support custom defined dictionaries If not, what are my options Don't think it does... But, tried this http://sourceforge.net/projects/netspell/ ...Show All

• Visual FoxPro Excel header/footer fonts and automation

  Hi, I did a search but didn't see this topic brought up. I want to change the font of my header in Excel (ver 11) using Visual Foxpro (ver 9). I used the macro recorder in excel to get a general idea, but I can't seem to get the code to work in VFP. Here's the excel code: ActiveSheet.PageSetup.LeftHeader = "&""Arial,Regular""2nd QTR 2006 vs 2nd QTR 2005" How do I get that code to work in Fox Any help would be much appreciated! Jeff Alex Feldstein wrote: >Here's the excel code: >ActiveSheet.PageSetup.LeftHeader = "&""Arial,Regular""2nd QTR 2006 vs 2nd QTR 2005" >How do I get that code to work in Fox Try: Activ ...Show All

• .NET Development Displays Excel worksheet in DataGridView

  How can I bind an excel worksheet data to a datagridview Im trying to load an excel sheet with numbers to my form, im trying to get as much of a look and feel as excel as possible. Hi, What you want is to embed the speadsheet control that is part of Office Web Components: http://www.microsoft.com/downloads/details.aspx familyid=7287252C-402E-4F72-97A5-E0FD290D4B76&displaylang=en The .net datagrid is not a replacement for a spreadsheet. Regards, Charles ...Show All

• Visual Studio 2008 (Pre-release) Executing Commands from *any* event

  I understand that commands can be triggered off certain events of certain controls. For example, specifying a Command for a Button will trigger it off the Click event. But what if I wanted to trigger a command off of a different event -- like a Load event Is there a way to do this at all If so, can I do it from XAML only This is the feedback from Msft on the issue Microsoft wrote: This is by design for this version. We do understand that this is a valuable feature and are considering it for future versions. Thanks for the feedback! Looks like we won't get it with V1 ...Show All

• Windows Forms Need Help with Wireless issues (WLAN - SSID) automation

  Hello at all, I have some problems with deploying Wireless Networks. Hope this forum is correct and someone can help. I want to rollout WLAN-Settings for 2000 Clients. I have already a test szenario with some Accesspoints and a zentral management Solution. (Extremenetworks Summit-WM) Connecting to the Wireless Networks with PEAP and without Certificates works fine, but how can i deploy these settings without configuring each Client manualy The most clients are windows xp professional. And after connecting with PEAP (802.1x) it seems that the client caches User and password. Also after rebooting the Client connects without prompting for user and password. Is there a possibility to prohibit that So that the User is forced to login a ...Show All

• Visual Studio VB .NET 2005 Solution Files + CVS

  Hi, Im trying to import our new VS 2005 projects(ASP.NET 2.0 & VB) into WinCVS. Im having trouble though with checking the project out and then trying to open it. The problem comes from the fact that the solution files have the directories hard-coded into it. Is there a workaround for this I want to be able to put the project on CVS and then allow for other people to check the project out into a directory of their choice. Is this possible Any suggestions/workarounds Thank you. Eric Seidel Thanks for the reply. My folder structure is as follows: H: \food_menu.net\ - aspx pages accessible by intranet users \food_menu.net\Admin - pages accessible by admin only \food_menu.net\MemberPages ...Show All

• Visual Basic many rivers to cross!

  Hi all, Anyone no the best way to solve my problem. (Using vb.net 2005) i am trying to make an offline app.(god help me). Basicly its a form with lots of fields holding data. The form must be able to be saved and edited then uploaded later to a server in xml format. I'm not sure whats the best way to hold the data for easy saving and editing. I'm not sure if i'm thinking correctly but here's my thoughts... Hold data in access DB convert to xml via dataset when ready to upload. make a serilizable class convert when needed (not sure how to save multiple instanses and recall them at will) make a dataset and save data as xml ready for upload. Am i on the right track here Also could i use sqlexpress if so must i ...Show All