ackermsb's Q&A profile

• SQL Server problems with web servces and data types

  Hello together, I am working on SQL Server 2005 and want SQL Server to provide to provide web services for a process management project. I was able to create a endpoint, but I the WSDL-File is very complex. There are much datatypes I do not need. Let me explain my situation and problems. 1. Providing web services For a first proof of concept I created a stored procedure which should be accessable through web serveices later on. I created the following stored procedure, which need to params and returns a list of stings (Names of Customers) set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo] . [GetCustomerView] @accountnum nvarchar ( 20 ), @dataareaid nvarchar ( 3 ) AS BEGIN SET NOCOUNT ON ...Show All

• .NET Development DataReader or DataSet/DataAdapter or something else!???

  I conducted some tests on a db with two tables with about 400.000 rows. its taking too long to open up for both on a DataGridView. However, when I run the same SQL Statement under Delphi 7.0 with ADO it loads it much faster. Shouldn't be ADO.NET faster than ADO if yes! please clue me in Sure! here is my code for both methodes, it may contain typos but overall this is what I'm using. This method is using the OleDbDataReader class dbRecordsHolder1 = new DataTable (); OleDbDataReader OleDbDr = null ; using ( OleDbConnection Connection = new OleDbConnection (constrEbillingData)) { OleDbCommand Command = Connection.CreateCommand(); try { Connection.Open() ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. ClientBounds Problem

  I'm having problems with deploys to my 360. More specifically, the resolutions that the games are displayed in. I can deploy programs fine, but when I run them, my ClientBounds don't seem to match up with the DisplayMode.Width and Height. It basically means that the resolution I'm expecting to run in runs out at about 3/4 of the screen width and height. I'm sure it's something silly I've overlooked, but I can't seem to find the problem. JLarkin wrote: Is there any way to change the PresParams before the actual GraphicsDevice is created This article explained it nicely. Just change the settings that you want instead of the reference device. http://www.riemers.net/eng/Tutorials/XNA/Csharp/S ...Show All

• Visual Studio Express Editions Can I download the image files, and install the program without burning it to a disk?

  I am asking this becuase I don't have a blank disk, and I want it to install on the computer I am on right now, and for some reason the internet is not working through the online installation. ...Show All

• SQL Server get file names from folder

  Is it possible to write a TSQL statement to obtain the a list of files located in a specified directory Also, if this is possible what additional information can be retrieved - in particular i'd like file size, author and date created (though I'd settle for just the file name). Thanks You can create a CLR FUNCTION that can be used in T-SQL code. See: Function -SQL CLR to Return File List C# - http://blogs.msdn.com/stuartpa/archive/2005/07/21/441468.aspx VB - http://blogs.msdn.com/sqlclr/archive/2005/05/20/420623.aspx ...Show All

• Windows Forms How to show a default text when no rows is bounded in a grid?

  Hi All, I have bounded a grid with some data. Now i need to show a text "No items bounded" when the grid doesn't have any rows to bind in it. I have tried this coding.... in VS 2005 grid_RowDataBound if (grid.Rows.Count == 0) { lblStatus.Text = "No items found" ; } But this is not working.... Can anyone help me Regards, Cbe Hi, Cbe By default, when you bind a DataGridView to a dataset like or datatable like datasource, and allow user to add new row, the row counting of the DataGridView would contain a "New Row", so when no items bound, the count is 1 instead of 0. You can count the rows in the datasource instead of the DataGridView. Reg ...Show All

• Visual Basic Regression Equation / Statistics in VS 2005

  Is there an easy way to create a regression equation based on certain data located in variables Or do I have to get out the 'ole stats book and write the code manually I couldn't find anything in the help file about this, so I may be out of luck! Thank you! -Corey     Sidermans Dark side, sometime you highly misnformed in the things you say. I'n 1970 I was doing linear regression equations on Mini-Computers in Focal a VB predecessor.. Linear regression is very,very  EASY to on a computer. It's pretty much like a correlation coeffiient. Unfortunately I am asked to do this once every fifteen years of so and I've forgotten the approach. I remember y = mx + b after to get the coe ...Show All

• SQL Server ParallelPeriod, Subcubes, and SP2

  We're defining some KPIs that include trend expressions which use the ParallelPeriod function to calculate the change in a KPI value since a past time period. For example, we calculate the change in the KPI value When we use an MDX SELECT with a WHERE clause that specifies a time slice, the expression evaluates correctly. However, when we use CREATE SUBCUBE to do the filter, or use BI Studio (which creates a subcube), the result is incorrect. In particular, the there's an IsEmpty check for the parallel period of the KPI value, so we're not doing bogus math when there's no data for the previous period. With the WHERE clause, that works fine, but with the subcube, the ParallelPeriod always evaluates to empty. As a point of comparison, I t ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. pop up box? in game

  Hi newbie problem, i am trying to create a few options for the player to choose from like: 10 x 10 = 100 10x10 = 1000 10x10 = 10 i was going to do this as images as i cannot think of a better way of showing on screen is there an easier way then if the person clicks on a certain versinity like x = >10 it will display a message if wrong box selected explaining the answer how can i do this can anyone help thanks If you just want to show some text, there are a few different libs available: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1142823&SiteID=1 ...Show All

• Software Development for Windows Vista Performance problem

  I have performance problem when working with wwf designer. It is too slow. I have Pentium D with 2 gb of ram memory. Maybe the problem is that I have Graphic card integrated, I don't know is the designer writen in wpf(does it require faster graphic card) Thanks, Indigo Cowboy Upgrading to the latest build, WF RC5, will give you better performance. Link to install RC5 can be found here . ...Show All

• Visual Studio Tools for Office Convert word doc to pdf

  Hi,  I need to convert word document to pdf file using C#.2  Iam having MS visual studio 2005 professional (and also MS VS.2003 enterprise ed) MS Office 2007 I have downloaded SaveAsPDFandXPS (used to convert doc to pdf) Microsoft Visual Studio 2005 Tools for Office Second Edition Runtime (VSTO 2005 SE) My question is Do i need "MS visual studio 2005 for office tools" version to work with ms word, so that i can convert word to pdf.      Make sure you have reference to Word.12. It will automatically add Microsoft.Office.interop.word to your reference. Follow these  for other office application. (Note: you should have installed VS 2005 Tools for Office 2nd Ed. R ...Show All

• Visual Basic Saving my users settings?

  I know how to save the settings for say info from a text box but I have radio buttons and depending on which they choose I want to save that so that next time my program loads there settings load aswell. Help Needed as soon as possible. Thanks Sam It depends...Is the preferences small ex. a favorite number. Or big ex. Their description of life. If it's small, use registry. If it's big, use a file (FileOpen, FileWrite, FileRead, and FileClose I think) If it's small, use the registry (Stuff in Registry namespace) ...Show All

• Software Development for Windows Vista Wimgapi.dll WimApplyImage Callback / Threading Problems (VB6)

  For the last few weeks we've been working on a wrapper library for Wimgapi.dll in VB6. This is to allow the WIM file to be used in our PE based OS image installation system. Sadly the system has to be written in VB6 to keep the deployed size very small but keep the GUI coding to a minimum (otherwise I wouldn't need to dust off my VB6 hat). Thre have been a couple of similar threads posted recently about how WimApplyImage can cause the VB6 IDE to hang or do strange things when using a callback function. We've also seen this problem and agree that it seems to be caused by WIMGAPI creating a new thread at the point it moves from restoring folders to restoring files. Any attempt to update the GUI or anything at all useful from the callb ...Show All

• SQL Server SQL Server 2005 Backup Through management console

  Hello Everyone, I have configured sql server 2005 for daily backup through its management console. Everyday backup is taken just fine without any problem. now i have configured its maintanace clean up task to delete the files which are older than 3 days at the time of writing file to specific folder. But some how this is not working and no files are deleted since i have configured this one week before. can you please drop your suggestion how do i need to configure it again so it can clean up the files according to the maintanance cleanup task. I would appreciate your help on this. Thanks, Bharat what is the service pack applied on the system... there are some issue ...Show All

• Visual C++ CAnimateCtrl does not animate

  Hello! In my project on MFC I use the ADO library to get data from MSSQL. I want some dialog window to be displayed during long operation, such as executing any store procedure that download image from MSSQL. I try it in the following way: 1) Creating the modelles dialog with animate control 2) Executing the store procedure 3) Destroying the modelles dialog The fact is that CAnimateCtr in my modelles dialog doesn't animate in such operation. If I try to create such dialog in another way, for example, after button click, it animates OK. What should I use May be, the second thread will help me What is the simplest way to get success Thanks for answers Hello ...Show All