Dirk Haest's Q&A profile

• SQL Server Show connection string(s) in report?

  I'd like to show (parts of) a report data source's connection string in the report. Is there any way to access the data source connection string(s) in an Expression I'm curious to hear all your answers, but a solution that works with the ReportViewer control would be especially useful for me. Eva Pierce Monsen The connection string value is currently not exposed through the report object model and can therefore not be accessed by other expressions. In RS 2005, you could define a (hidden) report parameter that determines the connection string. You would then use that parameter value in the data source connection string (RS 2005 supports expression-based connection strings, such as =Parameters!Co ...Show All

• SQL Server Execute package via a web application failing

  I have created a web interface for an ETL.  The SSIS packages run via the GUI package utility and the command line; however, they fail miserably via the web application.  The web app discovers the package without a problem, as I can view various properties of the package within the web app.  However, when I call execute and step through the code a DtsError is returned referencing "System.__ComObject".  Any ideas string pkgLocation; Package pkg = new Package (); Microsoft.SqlServer.Dts.Runtime. Application app = new Microsoft.SqlServer.Dts.Runtime. Application (); DTSExecResult pkgResults; IDTSEvents dtsEvents = null ; pkgLocation = strPackagePath.ToString() + strPackage; pkg = app.LoadPackage(pkgLocat ...Show All

• Visual Basic Ngenning and protecting the code in an image

  I'm writing some code that I want to be secure. I have stored data that I need to be uber secure. It's not a problem to encrypt the data. But the problem is to protect the code that manages the secure data. If I use reflector to dissemble my code, the dissassembly is magnificent and everything is right there. Using a c++ dll is not a solution because I need to call clr functions and once I've done that, the code is wide open to disassembly. Ngenned code is supposed to be dissassemable. But ngenning leaves the original image around, I suppose to activate the code that is placed in the GAC by Ngenning. Microsoft uses ngenned assemblies in their products. VS2005 is installed and then ngenned. But they don't leave disassembable im ...Show All

• Visual Basic accessing dataset fields

  Hi, I can not get this for the life of me. I want to get a list (array) of all the values in a certain column in a dataset, how can I go about doing this Also, what is the format for getting the value in a certain field from a dataset Like "Row x, Column y" where x and y are specified by a unique row value and unique column name. If you know of a good tutorial for Visual Basic & using SQL (Binding sources, datasets, etc), please let me know as I think I'm having a more difficult time grasping it than other aspects. Thanks! Right, my mistake; I guess I meant the above where instead of dataset, i meant a table in my dataset. So to get a list of all the values in a column ...Show All

• SQL Server No Indexes - Linking to MS Access

  Hello, I am using MS Access 2000 as a front end to a SQL Server 2000 db. When I link to the SQL Server db using a DSN, the SQL Server table pk's and indexes are not coming over with the link. The pk's and indexes do exist in SQL Server. I haven't had to link to these tables in over a year, but they used to link just fine. Do you have a suggestion as to where to look at this problem Thanks you - Darryle Please define the problem. Are you trying to “design” SQL Server tables form Access If there are indices in SQL Server, it will take advantage of them when you send queries. You can link to the sysindexes table in your database, and you can query what indices you have in SQL Server for that databa ...Show All

• Visual Basic How do I Convert a String to a DateTime

  I am reading data in from a csv file. One of the fields has the following format: MM/DD/YYYY HH:MM:SS I need to do a calculation between "records" of my csv file on the date/time. I think the easiest way to do that would be to convert the string to a datetime. Any ideas on how to go about doing this Thank you. Simply cast it to a datetime. Example Dim s As String = "01/21/2005 01:30:32" Dim d As DateTime = CType(s, DateTime) ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. C vs C#

  Currently I'm taking a C class at my university and I was wondering how different is C# from C code wise. Thanks Sebastian The C# language is a descendant of C, so it shares many common features, including operators, operator precedence, if/else/for/while constructs and much more. C# however is a modern object oriented language and contains many more sophisticated and useful constructs than C. Things like Events, Delegates, Generic Types, Runtime type information and reflection. Learn C for your course. If they don't offer C# at your university, start learning it on your own now. It's very important to learn an object oriented language early on in your programming career. It changes the way you t ...Show All

• Visual C# System.Char[] question

  I am running a continuous download of records from a server. To monitor the progress I use a progress bar and at the same time I send symbols to a RichTextBox via an invoker. The symbols are just added to the previous content with a single space separating them. It is a continuous line for symbols but they are wrapped around in a small window thus I see about 6 symbols per line. At certain time I need to start a new paragraph, so to speak. I decided to send this character: char [] CR = new char [ 13 ]; to the textbox: Then the first symbol of the next paragraph is combined with CR like this: CR+symbol. Instead of getting a new line I get this in the window: System.Char[]ABCD where the ABCD is one of the symbols. In othe ...Show All

• Windows Forms non-bound grid control in .NET? (like MSHFlexGrid)

  I'm halfway through writing a mini spreadsheet-like application in VB6 where the user can freely enter text into a table of cells, format them, get results from simple maths, etc. I would now like to rewrite in VB 2005 Express but can't find a suitable unbound grid control to replace MSHFlexGrid in .NET. I would prefer not to use a COM component if possible (and have seen quite a few worrying notes in the forums on MSHFlexGrid behaving badly in .NET). Is there a .NET based control I could use DataGridView seems to insist on being bound to data so isn't suitable (unless there's a property I can set to unbind it ). My application won't be bound to data, but lets the user type whatever data they want into the cells. ...Show All

• Visual Basic Hiding Scroll Bar on AxWebBrowser

  Hi Everybody! In my search I have found the following example in C++ code..... but am unable to convert this into Visual Basic .net code. Can anybody help Thanks. The problem with this approach is that it requires you to change the HTML code of the page displayed — something that is not always feasible. A better way to remove the vertical scrollbar is by using one of the IDocHostUIHandler callbacks. When MsHtml interacts with the user interface, it frequently makes calls to these callback methods to see how to proceed. By implementing the method GetHostInfo() , you can disable the vertical scroll bar. The nice thing about this programmatic customization is that it doesn’t require you to make any changes to the content o ...Show All

• Visual Studio Ordering Trial

  Can anyone tell m how much does the trial ordering of Visual studio 2005 cost I don't know if I want to buy it yet.Because I want to try it first. And I don't download the trial because I have limited bandwith useage. I am living in UK, how much would I had to pay if I ordered the Visual Studio 2005 thanks very much. ...Show All

• .NET Development socket.Receive() on blocking socket throwing WSAEWOULDBLOCK exception?

  I'm using a UDP socket for network communication with socket.Blocking == true and SocketOption(ReceiveTimeout) set. After several thousand packet exchanges, socket.Receive() starts throwing WSAEWOULDBLOCK (SocketException.ErrorCode == 10034) and seemingly continues to do so indefinitely about every second or third call to socket.Receive().   Can someone shed some light on what might cause socket.Receive() to throw a WSAEWOULDBLOCK exception on a socket with Blocking == true I wouldn't expect a WSAEWOULDBLOCK exception on a blocking socket. This is happening with .Net 2.0 Beta2 on WindowsXP Pro with service pack 2 (and updates). Thanks, Ray I'm (somewhat) able to reproduce the bug with the foll ...Show All

• Visual Studio Express Editions Instance of Class and context

  Hi, I have a project that contains the following: Form1------------------Form AccountsForm-------Form Search-----------------Form AccUpdate-----------Class I have created the following instances of the above AccountsForm in Form1 and called it ObjAccountsForm Search in the AccountsForm and called it ObjSearch AccUpdate in Search and called it ObjAccUpdate My question is When I need to reference, forexample, the instance of the AccUpdate Class form within my project I am having to type the full context to its instance Form1.objAccountsForm.objsearch.ObjAccUpdate. somepublic property in this Class My project contains many more Class's, and I have had to draw a table to keep track of where each instance of a ...Show All

• Architecture a good book for me

  Hello everyone, Well, now I have grown in my company and I will have a few more responsabilities, I will be project leader of small projects, and I would like to ask you for a good book for me. Perhaps one about methodology, agile or XP, about team system, or perhaps about enterprise patterns or something. Well, waiting for your suggestions Thanks in advance. Here are some I'd recommend, all of them excellent books, on some of the topics you mention: Patterns of Enterprise Application Architecture, by Martin Fowler Refactoring, by Martin Fowler The pragmatic programmer, by Andrw Hunt and David Thomas Professional Software Development, by Steve McConnell Agile Software Development, by Alistair Cockburn Beyond Software Archit ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. can i use visual studio .net professional?

  Can i use visual studio .net 2005 professional with xna or do i have to use xna game studio express. and if its possible to use vs professional would it still be better to use the game studio sorry if this question has been asked, i did a search and nothing came up. thanks for any help You can add the XNA Framework assemblies to a Visual Studio 2005 project and build Windows based games this way. What you will lose is the ability to build and deploy games for the Xbox 360 as that functionality exists only in XNA Game Studio Express. ...Show All