LukeD's Q&A profile

• .NET Development ADO.Net and Return values

  I have been playing about with obtaining return values from a stored procedure. the sp looks like so CREATE PROCEDURE [proc_CustomersLoadByPrimaryKey] ( @CustomerID nchar(5) ) AS BEGIN SET NOCOUNT ON DECLARE @Err int if @CustomerID = 'a' begin set @err=99 return @err end SELECT [CustomerID], [CompanyName], [ContactName], [ContactTitle], [Address], [City], [Region], [PostalCode], [Country], [Phone], [Fax] FROM [Customers] WHERE ([CustomerID] = @CustomerID) SET @Err =74-- @@Error RETURN @Err END my code to access this via C# looks like so. private void button1_Click(object sender, EventArgs e) { SqlConnection con = new SqlConnection(); con.ConnectionString = connectionString SqlCommand com = ne ...Show All

• SharePoint Products and Technologies Why need Form Server 2007? Thought WSS/MOSS covers that kind of funcationalities

  This is probably not the ideal place to ask this question but I'm just not sure what Form Server 2007 is for. I admit that I have not spent any significant amount of time looking into it. My very limited knowledge about it says it's built on top of WSS 3.0. I'm not sure what that means. I guess I'm trying to find out what "additional" functionalities Form Server provides that the OOB WSS/MOSS don't already provide, and the compelling reasons why it's useful in the business world. I am not sure of the exact answer you are looking for but you could probably find it on the Forms Server home page: http://office.microsoft.com/en-us/formsserver/FX100490391033.aspx ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. collision detection - alpha channel mask?

  I'm making a tile-based game, and some of the tiles are part walkable, part not-walkable. (like half mountain, half dirt). I need a way to determine which part of the tile can be walked on and which part can't. I can't do it based on pixel color, so I wanted to know if anyone could help me out with some bright ideas. I remember hearing something about an alpha channel mask you can put over your tiles, or recreate the tileset in black and white to designate walkable/not walkable. Is that the best (or only) way to pull this off If so, that would double the size of my tileset file George Clingerman wrote: XNA Rockstar wrote: And George...what are you, the XN ...Show All

• Visual C++ About obj file for VC8

  I use VC8 lately.It's build some obj files for a project,but I don't know what's the obj file type.It's not COFF file and not OMF file. I use new dumpbin tool to check these obj file, the report show:"ANONYMOUS OBJECT". Who know what's the file type Pleaes help,thanks... You probably specified /GL compiler flag, i.e. you are using link-time code generation. In that case object file contains internal representation of your program, something resembling abstract syntax tree. That format is not documented anywhere and there is no guarantee it will not change in the next VS version. Eugene ...Show All

• SQL Server Fortnight Date Dimension in AS2000

  I am new to AS and currently using SQL Server 2000 (upgrading soon). I need to provide information using fortnightly dates. Ie, the user should be able to see data for a specific fortnight beginning (or ending) date. Fortnights always start on a Sunday and finish on a Saturday 2 weeks later. I can write a stored procedure to identify the fortnight start or ending date based on an input date, but how do I call this from AS (as a calculated member ) so that it can be drilled down to within a Time dimension Assuming that you already have a date dimension table for the Time dimension, you could create a User-Defined Function (UDF) like udf_fortnight(@InputDate datetime), which can be used to add a fortnight f ...Show All

• SQL Server unique problem

  Hi friends I am currently working on a project using miscrosoft sql server 2005 analysis services I faced a unique problem on the day of UAT wat i found was that after processing my cube sucessfully when i was going to the browser wiindow the entire screen was coming but when i was pulling facts across dimensions there was no data coming in any of the facts. i checked the perspectives..re inserted the dimensions in the cube structure and re inserted the facts ..checked in the data source view whether the facts are properly connected with the dimension and then re processed the cube ...but again the same old problem Then panic struck me and without wasting more time i re made a new cube with the same dimension and same facts and the new cub ...Show All

• Visual Studio 2008 (Pre-release) Samples for January Orcas

  Got the January Orcas (VSDec2006CTP) image installed - Yeah Greenbits! But I can't seem to find any Entity framework samples. Am I supposed to download the latest ADO.NET samples from October http://www.microsoft.com/downloads/details.aspx familyid=c14c451d-7043-44f0-87d7-845f1c238d64&displaylang=en Hi, I've finally finished the download of the VPC image files. Sure enough, the October samples work just fine. Taking a quick look with Reflector, it appears that there is an updated version of System.Data.Dll - on my Vista system, this file has the following properties: // Assembly System.Data , Version 2.0.0.0 Location: C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\System.Data.dll Name: System.D ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. strange behavior with CreateEffectFromFile

  hello people. I am experiencing trouble when using D3DXCreateEffectFromFile. the issue is that CreateEffectFromFile function sometimes fails and returns E_OUTOFMEMORY. you'll all agree, this is nearly impossible. besides, when the compilation buffer is not empty (and the function, hence, fails), some undefined compilation error happen. typically on the lines where the HLSL compiler is needed. It might work if I comment those lines in the effect file (resulting in a useless one, because the only pass becomes empty). In a separate simple application, with a stand alone directx, like in SDK tutorials, my code is working well and the effect is properly read. so, I suspect the application environment (all surrounding code) to modify DirectX beh ...Show All

• Windows Live Developer Forums Bug in a Route.Itinerary.Segment.Distance

  Hello people, while i was debugging an application i'm working on, i found a bug (i guess so...)in the distance info in a route segment; you can test it at http://local.live.com/ (using shortest time and miles options). The bug is in the 9th segment between Washington [Washington, D.C.], District of Columbia, United States and Miami, Florida, United States. The total distance of the route is 1062.9mi, but the distance in the previous segment is 794mi!! However, if you query the route between that segment and the next one, the distance is correct... I hope it helps to correct it. greetings Dario Aznar - Argentina Hi John, someone out of this forum explained it to me that i was m ...Show All

• Visual C# Interfaces oversold???

  First, I must admit that I am a C# novice and so I probably don’t have as much knowledge and experience on the subject of interface as most of you guys reading this post. After reading a few books on C# and interface design, I still can’t see and understand the real power of interface unless of course, we are talking about interfaces as a powerful concept in OOP ‘only’ and not as a powerful concept in the general sense. When I was first learning OOP I was quite suspicious about the ‘excellent features’ that OOP claims to be able to deliver to the world and I was right. For example, in reality OOP offers very little if any, code reuse. I am now having the same suspicion about interfaces even though I see a lot nice words used to d ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. loading compressed files such as zip, rar,pk3, etc

  is it a "feature" of the content pipeline or would i need to write a custom load+filesystem routine to uncompress such files ProfEclipse wrote: You would need to derive a new ContentManager and override the OpenStream() method and derive a new Stream to read zip/pak files. YourContentManager.OpenStream() method would open the zip/pak file and position it at the specified asset. Your derived Stream class would handle reading the compressed data. Then, when you YourContentManager.Load<SomeContentType>("someasset"), the rest of the work is handled by the base ContentManager. So, you don't have to create any loading routines, just the zip/pak stream reading code. thats what i was afraid of ...Show All

• Windows Forms How to change data type of datacolum after data is filled?

  I am using .NET 2.0. I have a tab splitted file and I convert it into a datatable after parsing it. But I don't know about the datatype of any datacolumn of datatable at the time of file parsing. Therefore by default the datatype of each datacolumn is string. After parsing, I bind this datatable to datagridview. Now when the user tries to sort a column of datagridview that has numeric or datetime values only, datagridview sorts it as string rather than numeric or datetime. I have observed that if I change the datatype of the datacolumn of datatable to int or datatime according to its contents then it is sorted correctly. So how can I change the datatype of datacolum after the data has been loaded in the datatable Any other way ...Show All

• SQL Server ldf file lost

  somehow i lost my ldf file and now my sqlexpress is not working. I have the mdf file though. Is there a way to restore my database using mdf file Please help. Sorry about that, then yout database is in a inconcistent state where it can’t be recovered, hope you have a valid backup of your database. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Mouse pointer changed event?

  Hello Sorry for the ambigous and silly title. Is there any event that is triggered when the mouse pointer has changed (that is, the actual graphic of the mouse pointer) I am guessing such an event may exist in the Win32 API or the DirectX API. I understand this post may be slightly off-topic, but I found this forum most suitable. No. DirectX settings that an app change are specific to that app only and don't affect other processes. So DX is off question. For the Win32 API, there's also no such a functionality exposed directly... ...Show All

• .NET Development The strategy of multiple Setting-files

  Hi, I have a VS-solution with some projects inside. One executable and 2-3 libraries. Libraries rely on some Settings I save in library's app.configs. I found out that DLLs are unable to read their Settings-files, so I have to manually paste these settings into my executable's app.config. I find it's not the best practice, because the number of libraries may increase and there may be new library settings I may forget to copy into the main app.config. So, is there a strategy to this problem Something like an "auto merge" of all VS-Solution configuration files Konstantin I have this problem as well. There is no "auto-merge" or anything similar that I am aware of. Since we had many projects, it was get ...Show All