Aaron Sulwer's Q&A profile

• .NET Development Using classic ADO parameter objects from VC#2005

  Hi everyone Apologies if this is the incorrect forum for this posting, please let me know if I should repost elsewhere in a more appropriate location. I'm trying to use parameterized queries with classic ADO. I've done this successfully with ADO .NET 2.0, but because of the legacy ODBC drivers that we are needing to support which cause a crash when using ADO .NET I am having to use classic ADO. I'm using the following code to create the parameter and assign to the command object: private object m = System. Type .Missing; adorecordset = new ADODB. Recordset (); ADODB. Command adocommand = new Command (); adocommand.ActiveConnection = adoconnection; adocommand.CommandText = strSQL.ToString(); Parame ...Show All

• Visual Basic Does the rowimport check the row state or require the rowstate to be some thing other than disconnected?

  Does the rowimport check the row state or require the rowstate to be some thing other than disconnected cybertaz69, Thank you for your further information on the question. In your reply, you mentioned that you create a new row on the target table and reads in the row fields one at a time mathching column headers. I wonder, could you please tell me if there is any problem in your new method If so, could you please provide me some related pieces of code in your application Thank you for your reply and waiting for your further question. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Material vs Shader

  Welcome to another one of my newb questions! Can somebody explain the difference between a material and a shader My own ideas would probably be: - A Material defines the texture and lighting properties of a surface, and maybe even the sound properties of a surface. Visual qualities of a material can be described with  shader(s) ! Anyway, if someone could give me some ideas here as I find the two terms quite conflicting, but its probably because of my limited understanding! cheers :) The reason I ask is I was thinking about making a Material class that maybe describes texture, lighting properties and sound of certain geometry. edit: by the way I have checked out the definition of a material in the directx documentat ...Show All

• Windows Live Developer Forums find business name and type

  Hello All, I'm currently using find() to do business search .. I'm not sure how it works ... eg .. I did a search "cafe".. it didn't come out with anything .. and then I seached "coffee" .. it comes up with some cafe.. so what is it acctualy searching for is there a way I can choose to search for either business name or business type Thanks Yuki The "find" is very generic, very similar to the "find" using the Mappoint Web Service. As for how the search actually works, I do know that it goes through a set of internal datasources to find the result. Likely the reason "coffee" works is because theres a "coffee" datasource, mainly for ...Show All

• .NET Development Perimeter service router (WSE 3.0) and basic authentication

  When implementing a perimeter service router using wse 3.0 is the following possible: A client has to access a remote web service through a perimeter service router implemented using wse 3.0. The remote web server hosting the webservice uses basic http authentication (that is Authorization: basic <base64 encoded user/pass> must be added to the http header). Coming direcly from the client this seems to be possible by implementing a custom policy that modifies the WebRequest stored the context of the SoapElement passed to the ProcessMessage function. On the perimeter serivce router however the WebRequest is always nothing for all filters(CreateClientOutputFilter etc.) and even if a SoapHttpRouter is used the context of the messag ...Show All

• .NET Development Is it possible to enumerate a USB device ......

  hello.., I am doing a USB project in windows XP, in which i need to eject the any USB mass storage device which is plugged-in , for this i am using CM_Request_Device_Eject(). And it is working well. But when more than one device is plugged-in to the system, sometimes, there are cases that more than one device is getting the same deviceInstance, basing on which i am ejecting the device. Due to this the CM_Request_Device_Eject() is either ejecting the recently plugged-in device or ejecting the already ejected device by returning S_OK. To avoid this mismatch of the DeviceInstances, i want to enumerate the plugged-in devices for every minute. But when i do this, GetLastError() is returning NO_MORE_ITEMS. So, my doubt is.. Is this possible to ...Show All

• Visual Basic Software Publish Question

  Alright, I have a program that I'm working on and i have noticed that whenever I run the Publish in the Programs Properties, that it makes a .exe . Now whenever I run the .exe , I noticed that it puts it under Start - All Programs but I don't see it anywhere in the C:\Program Files\ . Why is that Also, I have a .mdf in the application. Will it create the .mdf upon install for me or do i have to encode that into the program How can I change this I want to do an install that allows me to choose where to install it. Secondly, I have a database (.mdf) that I created inside VB.NET. Will it automatically create this database per user Or do I have to make a app that will create the db Thirdly, I ev ...Show All

• Microsoft ISV Community Center Forums Sum of hours for month following submission date only

  Hi - im a little stuck on one part of my system. Thanks to the help of others i can now get users to enter a submission date into the activity system that then restricts them from editing any activities prior to that submission date ( a field called 'datelastsubmitted'). However on that end of month submission form i also need to show the sum of all hours for the month that is to be submitted next. By this i mean that if a user last submitted on the 31/10/2006 then the next time he comes to submit he will see the sum total of activity hours he /she has entered for November 2006 i.e 01/11/2006 to 30/11/2006. The field is called 'availablehours' and the code i have written does sum up the availablehours for the user but im unsure as to how t ...Show All

• Windows Forms DataSet.AcceptChanges and DataGridView

  Scenario: I modify data in a few rows on a DataGridView, then create a "Changes" DataSet using the GetChanges method, "foreach" through the rows in the Changes dataset and RejectChanges on one of the rows.  Then I call the Update method of the DataAdapter.   If at that point I re-load the D ataGridView's Dataset, the data is the way I want it to be - in other words the "good" changes have been posted, but the rejected change has not.   My problem is that if I don't go through the step of re-loading the DataSet, the values in the DataGridView stay the same - in other words, the rejected values are still visible in the DataGridView   I've tried merging the Changes DataSet back in ...Show All

• SQL Server Distributed App, Technology Question

  Hi Everyone. I am trying to get ideas for a possible technology we could use for a certain scenario. In a nutshell we want to run a distributed application at hundred of remote stores, anything that happens at the store must be propagated to a central sort of hub server. Now i have already thought about replication, but maintaining replcation across hundreds or even a thousand remote instances would be a nightmare.Also the App must work offline so if no link exists the app must still work and sort of reliably queue the transactions. So i been experimenting with service broker, to write transactions, that then queue on to service broker to the central hub, therefore enabling remote stores to continue to work even if no comms exi ...Show All

• Visual C# Custom app crashes with 0x800736b1

  I'm developing a custom application (GUI.exe), primarily in C#. My business objects (BOLData.dll) are in a managed C++ dll that's part of the overall project. The other dlls are all C#. The program runs just fine on the developers machines. We're all using VS2K5 w/SP1. It works under XP Pro, Win2K3 and Vista -- if VS installed. When I tried running the program on a clean XP Pro computer, it immediately crashes with a cryptic reasons: EventType clr20r3, P1 gui.exe, P2 1.0.0.23358, P3 45d76c7d, P4 bol, P5 1.0.0.23357, P6 45d76c7b, P7 a4, P8 13, P9 system.typeinitialization, P10 NIL. In the Program.cs file, I threw in a try/catch around the main form loading and then ran it again. This time I got a lot more info about why it's failing: System ...Show All

• Visual C# How export a gridview to excel using c#

  How export a gridview to excel using c# thanks! there are a couple of options, unfortunately for us since its WinForms based, there is apperently an easier way to do it in ASP.NET if we were using ASP.NET in order to help better, could I ask - how are you populating data into the datagridview Are you entering it manually or have you databound it from a dataset, using a DataAdapter to fill the dataset with records ...Show All

• Visual Studio Express Editions why cant i create a new project?

  hi im new but not to programming, now the problem i have is when i try to create a project, it tells me "project creation failed" why is this also is microsoft visual c++ express edition suitable for writing my own code to create mods/ addons  (half life 2 ect.) and why cant i open dll file asociated with games (for example, mp.dll, tfc.dll)   please help!! my email is dr.grumbles99@hotmail.com , please contact my email if unable to on this forum   thank you If you did not complete the installation you might not be able to use it properly. If you want to download CD images to burn to CD check out http://msdn.microsoft.com/vstudio/express/support/install/ The ...Show All

• Visual C# Saving User Settings

  I'm writing an app where I need to save some inputs from the user. I cannot use the app.config method because the users will not have admin access on their machines. I've tried doing this through the Visual Studio IDE, but its still outputting the settings to app.config (I cannot even get it to read the settings back in). Does anyone know if there is a way in .NET to do this. My alternative is to write the code to do it and I was trying to avoid that. Thanks for your help! Mark, Thanks for your help so far. I did as you said, but it is still outputting the settings to app.config in the same directory that the executable is in. That's not going to work for my users because they won't have admin privileges plus this method only allows ...Show All

• Commerce Server Developer's workstation

  I'm still struggling with the notion that all of our developers must have Windows Server 2003 running on their desktops to build CS based applications. There are few references on the net about this and the bottom line is that doing it on XP is an option but not recommended ('I told you so' on one of the blogs). Being aware that some features may not work (warehousing) I still would like to have development done on XP. I've installed CS2007, already have VS2005. I've unpacked CSharpSite and when trying to access the page get this error: ' Login failed for user ''. The user is not associated with a trusted SQL Server connection'. I went to Commerce Server Mangager and for each (I hope I've covered all) connection to into Profiles, Mar ...Show All