robbyduffy's Q&A profile

• SQL Server selecting multiple parameters

  hi. i've just started using reporting services and i'm running into a problem. basically i have 3 parameters for filtering the report. now, there are no problems when a user selects 1 parameter. but when a user selects 2 or more, it ignores them. ex. i have these paramters: date, location, name. when a user inputs just the date, then there are no problems. but when the user inputs data for date AND location, my report ignores the parameter for location. i want it to be dynamic wherein the user can select a combination of those 3 parameters (date and location OR date and name, or just date). now, i know my error is in my sql query. ...Show All

• .NET Development Converting int to nullable enumeration...

  This is the piece of code that's throwing the exception field.PropertyInfo.SetValue(row, dataReader[field.Name],null); The field in the database is a number, nullable. On the other hand, the Property in the object is of type TerrainSequence , where TerrainSequence is an enumeration. When I try to do this conversion (int to TerrainSequence ) , this is the exception it throws. Object of type 'System.Int32' cannot be converted to type 'System.Nullable`1[FairPlay.Data.Persistables.TerrainSequence]'. Any idea on how to tackle this conversion This is still bugging me.. is this a BCL error i wrote this just to try ...Show All

• SQL Server SSIS Performance compared to DTS

  I'm new to SSIS, and trying to feel my way around but I've got some questions about performance. I've used DTS for a number of years, and I read in Donald Farmers blog that SSIS was about 7 times faster than DTS (mileage may vary).  Well, I may be doing something very wrong, because I'm getting about 7 times slower! I have around 40 dimension tables, most of them have less than 100 rows.  Only two have 60,000 rows.  Then I have a single fact table with 2.7 million rows. I pull my data from Excel for the dimension info, and Oracle for fact info.  In DTS the dimension load takes around 45 seconds total, all 40 dimensions in ...Show All

• Visual Basic fm20.dll redistribution

  The thing is that I need to redistribute fm20.dll with my program which uses it my VisualBasic project. But since this dll ain't redistributable I'm in a little confusion. It is senseless to ask people that will use my program to have MicrosoftOffice installed... Then I read about Microsoft ActiveX Control Pad and thought that my problem was solved....but unfortunatly I couldn't find it using 'Search Microsoft.com'...So as I already said I'm in a confusion - how and where I can get this dll for redistribution. Would be very greatful if someone will answer my question. P.S. Sorry for my bad english Best Regards Iskander T ...Show All

• Visual Studio How to build a custom tool for VS2005?

  I've searched high and low for some information on building custom tools for Visual Studio 2005 and can't find it anywhere.  Here's what I want to do: I want to be able to have the user specify in the "Custom Tool" property for a file my custom tool.  That tool will take in the information from the file and generate a new file with some code in it.  For example, Custom Tool for the file "SomeClass.xml" is set to "XmlClassGenerator" and whenever the XML in that file is changed, a file called "SomeClass.cs" is rewritten with a corresponding C# class. I've found tons of information on how to do this in VS2002/VS2003 including der ...Show All

• .NET Development Getting truncated data on sockets

  Hi, For some reason I am recieving truncated data on socket I am listening to. The data sent is 41Kbytes but I only recieve less than 10Kbytes. I dont know why. The buffer size I have defined is also very large Private SocketDataBuffer(100000) As Byte This line iRx = workerSocket.EndReceive(asyn) in the following code always returns less than 10K bytes. Any ideas   Public Function ConnectTradeAlertSocket() Dim _sHostName As String Dim _iLocalPort As Integer = 9999 Dim LocalIp() As IPAddress Dim _oIPHostEntry As IPHostEntry Dim IPLocalEndPoint As IPEndPoint oListenerSocket = New So ...Show All

• .NET Development NetworkStream.Read performance

  Hi All, a small question about some code we implemented: if ( rxSize > 0 ) { byte [] buf = new byte [rxSize] ; int total = 0 ; int offset = 0 ; int counterRead = 0 ; int counterSleep = 0 ; // put incoming bytes onto the input stream while ( ( !m_Terminate ) && ( rxSize > 0 ) ) { // stream = new NetworkStream ( socket, false ); if ( stream.DataAvailable == false ) { counterSleep++; System.Threading. Thread .Sleep( 50 ); // it was normally 100 but 50 went better ( 10 was to low ) } else { counterRead++; tmrPong.Change( 10000, Timeout .In ...Show All

• Smart Device Development How to detect when Scrollbar from my DataGrid changes ?

  Hi, Im doing some kind of Datalogger, and in a certain part of the app I need to detect when somebody changes the position of the scrollbar of a Datagrid Many thx in advance, Hi cgMarcos, Try this code (you can also find this snippet in the public newsgroups): foreach ( Control c in dataGrid1.Controls )                         {                                 Ty ...Show All

• .NET Development How do I enable useUnsafeHeaderParsing from code? (.NET 2.0)

  Hi, We have several webservers that do not follow the correct RFC specification when performing some specific HTTP web requests, in order to communicate with them we need to enable unsafe header parsing. Changeing the webservers to respond correctly is NOT an option in our case. According to documentation, adding the following lines to the app.config enables the unsafe header parsing. <system.net> <settings> <httpWebRequest useUnsafeHeaderParsing = "true"/> </settings> </system.net> This works nicely for regular applications, however, the problem is that our .NET code is exposed and run as ...Show All

• Visual C# Unable to load class library

  I wrote a managed wrapper in C++/CLI and compiled it under AMD64. Now I wrote a client in C++/CLI too and this works well. Trying to do the same in C# I got everything to compile but when I run it it says: Unhandled Exception: System.IO.FileNotFoundException: The specified module could not be found. (Exception from HRESULT: 0x8007007E) at MyClass.Main() This is weird though. I compiled the C# file for 'anycpu' but trying to set the platform to x64 did not do any difference. The class library is even located in the same directory.  It was compiled using the RC:         csc /out:test_cs.exe tes ...Show All

• Windows Forms Very strange ComboBox databinding problem

  Hi, this problem really drives me nuts. I have a custom ComboBox, which derives from the normal ComboBox control. I'm setting the DataSource of the ComboBox in my code to a DataTable and also set DisplayMember and ValueMember. So, the binding in general works fine, but here's the odd part: Depending on what is selected I color the background of the ComboBox differently. To achieve this effect when the DataSource changed i overwrite the OnDataSourceChanged method:             protected override void OnDataSourceChanged(EventArgs e)         {   ...Show All

• Architecture Design consulting

  Hi all, I would like to get a consulting in the following design senario , how to do it in the right way. I'm trying to develope a reusable component of communication between the PC and field devices. The devices have special communication protocol and a special way to make the physical comm. The are many devices kinds (Display , microcontrollers,...). I'm looking for the right way to write a global component. I'll use this component in many .Net projects. I thonk to do that with interface, and classes implement the interface, the reason because the devices are from different inheretane trees. The schema I thaught about is: ...Show All

• Visual Basic Inserting Data Into SQL Mobile Database VERY slow!

  Hi Guys, I've got a text file with 3000 insert queries in it. When I run them one by one on a Pocket PC 2003 device it takes over 45mins for it to complete. Is there a better way of getting data into the device Thanks Woody ps ActiveSync ideas can't work because I have 90+ of these units and this operation needs to be done at least once a day. Oops, found the problem. I was opening and closing the connection before every insert. What took 40mins is now down to around 2. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Where is d3dim.lib, d3drm.lib, dsound3d.lib?

  My questions: 1) My book ("Tricks of the Windows Game Programming Gurus ed1" ) teaches DirectX 8.1 SDK. Is it fine to have that SDK on for ease-of-understanding w/ the book, or use the updated DirectX 9.0c SDK 2) Relating to DirectX 8.1 SDK, the book says I need the following library files: ddraw.lib dsound.lib dinput.lib dsetup.lib dplayx.lib Now, the next three are nowhere to be found in the library folder: d3dim.lib   d3drm.lib dsound3d.lib Where are these libraries Did MS do their yearly remove & replace somewhere How is this going to effect my code Thanks, Phil   dxfoo wrote: ...Show All

• SQL Server Add a DateLoaded column to input data

  OK, I *know* this is trivial, and please feel free to giggle,  but after years of DTS 2000 my poor brain can't make all the jumps neccesary to cope with SSIS 2005. I have a Transfer data task. Source input (non SQL Server) has x columns, SQL Destination has x+1 columns, where the extra column is a non-null smalldatetime column DateLoaded. This will be populated with the Date & time the row was added. In DTS I do this either by adding a GetDate() equivalient to the Source SQL statement (which I can't do in this case) OR by an ActiveX script to put DATE()+TIME() in the final column in the Transfer pane of the designer. This must be ea ...Show All