akin_l's Q&A profile

• SQL Server Distribution Calculation

  Hi Can someone please tell me how I can take a set of sales orders and generate a table or set of data that show the percentage of sales per product which are in different sales ranges eg Socks - Beige 50% Orders are above $100 20% Orders are above $90 and less than 100 30% Orders are above $60 and less than 90 Many thanks for your time TV This will work: create table sale ( saleId int identity, value decimal(10,5) ) go insert into sale (value) select 100 union all select 110 union all select 90 union all select 20 union all select 30 union all select 100 union all select 95 union all select 35 union all select 39 union all select 20 go select count(*), sum(cas ...Show All

• .NET Development Server response with header attribute mustunderstand="1"

  Hi everybody, I'm stucked with a web service response... When I call a web service I must add a Header calles TransactionID with the mustunderstand attribute set to "1". The web service response it's ok but includes the same header with mustunderstand="1", and client proxy class is unable to process this response. The message I'm getting is: "Soap Header TransactionID was not understood" It seems like my client proxy class can’t understand the TransactionID header. How can I tell my client class thar TransactionID is understand Is it possible not check the mustunderstand attribute Any other idea Thanks in advance Angel ...Show All

• SQL Server Differing results on identical systems.

  I have a staging environment and a developement environment set up on the same machine. Both environments consist of two databases, a staging area and a data warehouse. On the staging system when I run a query of the form: select count(*) from [StagingArea].[dbo].[saTable] join [DataWarehouse].[dbo].[dwView] on saTable.col = dwView.col join [DataWarehouse].[dbo].[dwTable1] on dwTable1.col = dwView.col join [DataWarehouse].[dbo].[dwTable2] on (dwTable1.col = dwTable2.col AND dwTable2.col = saTable.col) I get an answer returned in 2 seconds. When I run the same query on the developement system it never comes back with an answer (after 3+ hours). The data in both systems is identical. But it would appear that the query optimizer i ...Show All

• SQL Server KB918222 Windows 2003x64 R2 fails

  When I try to apply this post SP1 patch to SQL Server 2005 x 64 on a Windows 2003x64 R2 system it fails everytime. The following is the HOTFIX log: 07/12/2006 15:02:06.781 ================================================================================ 07/12/2006 15:02:06.781 Hotfix package launched 07/12/2006 15:02:08.046 Product discovery successfully completed during the install process for MSSQLSERVER 07/12/2006 15:02:08.046 SP Level check successfully completed during the install process for MSSQLSERVER 07/12/2006 15:02:08.046 Product language check successfully completed during the install process for MSSQLSERVER 07/12/2006 15:02:08.046 Product version check successfully completed during the install process for MSSQLSERVER 07/12/2 ...Show All

• .NET Development Typed Dataset Question #2

  Hello All, I am creating a Windows Forms application (VS2005 and .Net 2.0) and I have a question regarding the best time / event to use to populate the form dataset. In most cases, the rowcount for the datatable in the dataset will be less than 200. In a few datatables however, there is the potential for hundreds of thousands (if not millions) of records. My questions are, "Do you use the form load event to populate the datatable " "What would the response be like during the form load if it was populating 1.2 million rows into a datatable " "Any better ideas on how to fill a large datatable " Thanks in advance. Roger What about the form constructor I see a lot ...Show All

• Windows Forms PictureBox

  i'm coding a Solitaire game.in this game we can change the card image.i mean game>bunch.i hope u get what i said. i think we'll choose the image from the picturebox and then with a parameter we'll send this image to another form and show the image there.i couldn't write the code.please help me . i solved the problem thnx a lot :) but now i have a new problem.i wanna create pictureboxes on form-load.but i put the images randomly.here's my code.i got this error message.Cannot implicitly convert type 'string' to 'System.Drawing.Image'. where'S my mistake for ( int i = 0; i <= 6; i++) { Random r = new Random (); int randomnumber = r.Next(1, 10); PictureBox picbox = ...Show All

• Visual Studio VS SDK project reference questions

  Hi, All! I have a couple of questions regarding the subject. After user adds assembly or COM reference in the project references, I need to get metadata from the assembly (to implement IntelliSense stuff, for instance). If I simply load the assembly, it locks the assembly's dll. So, I just get infantile sickness symptoms of Visual Studio. VS 2005 C# project does not lock anything, so I believe there is some mechanism on how to avoid this unwanted effect. I can see two ways how to implement reading metadata with no dll locking: 1. Load assembly as an array of bytes. The problem of this approach is that such assemblies are not 100% aware of types already loaded in the domain. 2. Create a new domain and load assemblies with shadow ...Show All

• Visual Studio 2008 (Pre-release) Custom Controls Toolbox

  Hi, In my case the Cider Aug 2006 CTP not add automatically any my custom control on the Toolbox. Using WinForms exists the feature and this improve the custom control's development requirement time. There is a plan to add this feature for the future -- Andrea Gelati WPF WPF/E Control's Developer WPF Control Toolkit Project Administrator on CodePlex.com Personal Blog - http://agelati.spaces.live.com ...Show All

• Visual Basic Rename a Table in MS Access using VB or SQL statement

  Hi all, How can I rename an MS Access table in VB or thro' SQL statement I have 2 clues as given below, but I am not able to get to use these ideas. These statements does not seem to refer the ADO library and hence, I do not know how to arrive at framing a program for these statements. Please help me in using these clues by guiding me how to frame a program around the statements or please let me know if there are any alternative ways. Clue 1: This creates a copy of the original table and you then delete the original leaving you with a newly named table. DoCmd.CopyObject, "myTableOld", acTable, "myTable" DoCmd.DeleteObject acTable, "myTable" ----------------------------- Clue 2: CurrentDB.TableDefs("myTable").Name = "myTableOld" Any he ...Show All

• Software Development for Windows Vista view mode is not saved when browsing folders inside my NSE

  Hi All, I'm developing a shell namespace extention and everything works fine except one thing - the view mode (details, list, etc.) is not saved when I go from one folder to another inside my NSE. I don't know what to do about this. Does anybody know how to preserve view mode while browsing folders (should I get current view mode from the parent folder and set it somehow when I create IShellView object ) In my NSE I use SHCreateShellFolderView() to return IShellView when it is requested through IShellFolder::CreateViewObject. My Explorer is not configured to remember each folder's view settings. Thanks in advance. ...Show All

• Visual Basic Word.doc

  Is it possible to open a word.doc in a RichTextBox and if yes, how You can open a word.doc in a RTB without it throwing an error but it's just a few unreadable characters. Is there any way to open a word.doc in VB.net ...Show All

• Visual C# Why C# does not support multiple inheritance?

  Hi Please let me know why c# does not support multiple inheritance. I know it will support multiple interface inheritance. but why in the case of classes Pls let know the reason. Regars sanjay take a look at these links this is explained well there http://blogs.msdn.com/csharpfaq/archive/2004/03/07/85562.aspx http://blogs.msdn.com/nickmalik/archive/2004/12/31/344966.aspx http://www.c-sharpcorner.com/Language/MultipleInheritanceCB.asp hope this helps ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Art/Sound assets

  First off, I'm really excited about XNA/etc. If I ever meet the guy/gal who came up with this idea I would love to buy them a beer. I'm a programmer with professional experience. I feel like I'll be comfortable with XNA development once I've got my hands on it. My main concern is game assets. I'm no artist, nor am I a sound engineer. Here are my questions: How much art/sound content is expected to be available for programmers like me Will there be a variety of content For example, I want to make a fantasy RPG and some other guy wants to make a space themed FPS. Will we both have access to the assets we need Will art and sound types be able to upload their own content for other developers to use ...Show All

• Visual C# Accessing Resource Strings

  Hello All, Is there a way to parse the resx file I want to create a text file that contains all the values of the .text entries in the resx file. Then I can give that to a multi-linguistic expert and ask him to convert those strings to some other language. Any pointers on this would be appreciated !! Thanks John :) The ResXResourceReader works just fine and solves my purpose. I am breaking my head over the ResXResourceWriter because I believe it can only create NEW resource files but not modify existing ones, right I need to do the latter. ...Show All

• Visual C# Casting an object to a specified System.Type object

  Although this seems like something that should be painfully obvious, the method eludes me... I need to cast an object to a specific System.Type object. It's more clear in code: ... int a = 1; int b = 1; Compare(a,b,typeof(int)); ... public bool Compare(object intA, object intB, Type type) { return (intA == intB); //returns false } How do I cast intA and intB to integers without doing so explicitly I need to cast them using the System.Type object, since it is unknown within Compare that these are int types. I don't believe that will work because the comparer takes instances of object and if the types passed in are int then they will be boxed, so even if the numerical values are the same, the boxed instance ...Show All