Hassan Ghaed's Q&A profile
Visual C# Parametrized Query in Visual C# 2005
Hello, I have a problem in setting a dynamic query in my application. Actually, I know how to work with a parametrized query and how to pass a value for one of the elements in my where clause, but I need to pass more than a value like other criteria or generally i need to change the structure of my SQL in the given query. My database is Oracle 8i. Does anybody know how I may address this Thanks Hello, Thanks. I don't know how to use stored procedure in this case and I believe BINDING SOURCE has just FILTER property for my purpose, which has limited functionalities. I'm not sure if you exactly understood my problem or not. As Monkey said, I 'm looking for something like SQLCommand Property i ...Show All
Visual Studio Express Editions TextReader Not Getting Special Characters
I need to read text from a textfile which contains non-ASCII characters. A sample line from the file is: tda Oo u> Sv e pe=vSwanm!. 3. The non-Standard characters are in bold and underlined. The usual code I implemented in order to read the text does not work: Dim fileReader As System.IO.TextReader = New _ System.IO.StreamReader("example.txt") Dim firstLine As String = fileReader.ReadLine MsgBox(firstLine) With this code, firstLine should contain " tda Oou> Svepe=vSwanm!. 3." , but it does not. (i.e. firstLine contains " tda u> Sv pe=vSwanm!. 3.") If, on the other hand, I directly implement: Dim lineOfText As String = "tda Oou> Svepe=vSwanm!. 3." MsgBox(lineOfText) , ...Show All
Visual Studio Team System Managing permissions
Is there a way to restrict a user's ability to create, edit and delete labels or branches What I want to do is to have only certain users to have permission to manage labels and branches. Can this be done As mentioned, we don't have a separate permission for branches. They're treated like ordinary files. Depending on your intent, it may be possible to prevent branching by denying permission on the root directory and only granting it within existing branches, like Chandru suggested . ...Show All
Visual Studio Tools for Office Task pane / Action pane needs to be available accross different workbooks but I cant make it!
Hi I was wondering if someone could help with a problem on action panes / task panes in Excel. I have a task pane which is added via code (See below). I need the task pane to "stay put" as I navigate between different workbooks. If I load or add a new workbook, then the task bar is not available to these and remains only available to the worklbook in which it was added via code. My objective is to have an add-in which contains and controlls the functinonality of the action pane and have this available has I navigate between different workbooks. I hope some one can help. Many thanks for your help. David Edelman Public Class ThisWorkbook Public oActionPane As New ...Show All
Internet Explorer Development HTML/Javascript errors with IE7
We developed an application which uses HTML/Javascript for the main user interface. We generate the HTML/Javascript using C++ code and then feed it to the embedded IE MFC control for rendering. This app was developed with IE6 and works fine in that environment. We recently upgraded some of our machines to IE7 and now when we run and the page renders in the embedded IE window, we get script errors. The errors we see are shown below. 1) Line: 1, Error: Invalid character 2) Line: 9, Error: 'CalendarPopup' is undefined The first error is a bit confusing, since if you view the source the first line is just <html>. I thought perhaps it wanted a valid <!DOCTYPE ...> header so I added that, but the error was still there. The second err ...Show All
.NET Development Object exposed with RemotingServices.Marshal becoming unavailable over time
I originally posted this as a reply on a related thread. However, the main question in that thread had already been answered so I decided to seporate it. Somone in the other quoted the folowing from http://msdn2.microsoft.com/en-us/library/y0h540a7.aspx : Singletons In COM, "singleton" meant that as long as clients had references to your object, the object would not be deleted from memory. In .NET remoting, however, a Singleton object is subject to the lifetime lease that was specified for it, so it can be recycled even if clients currently hold references to it. You can create the former type of Singleton object by overriding the InitializeLifetimeService method of MarshalByRefObject to return a null refere ...Show All
Visual C++ strange run time error notification (empty pop-up window)
When a run time error occurs (e.g. an invalid file handle is used) in a console application created in debug mode with C++ Express Edition I get a completely empty pop-up window (title reads "Microsoft Visual C++ Debug Library") with three empty buttons. Clicking on any button terminates the application. 1.) Is this behaviour due to the missing C debug runtime libraries in EE (i.e. is it a "feature") 2.) Running the same .exe in an environment with .net 2002 installed shows the usual window contents and I am able to run the debugger - it points to the bad statement I use /MTd (link runtime lib statically) - how comes the pop-up window is fully working Any help highly appreciated ...Show All
.NET Development Updating Database
I am using VB.Net 2003. I've just switched my dB from Access to SQL I have a tab control with two tabs on it.. One for the Billing address, and the other for a shipping address. On the Shipping Address Tab I have a button that will copy the data from the fields on the Billing Address tab. This all works fine. Now the code below is what I am expecting to write the data back to the dB. But it doesn't. In fact, when I press the button to copy the data to the Shipping Tab and then I change to the Billing tab and back again, the data on the Shipping tab has been wiped out and the fields are blank. so I guess I actually have to different problems.... any help would be appreciated. thanks Private ...Show All
Visual C# Custom Object, Typed DataSet or DataSet
Hi All, I have a big project , which designs as 3-tier. Most of work is database updateing. Inserting, searching. Speed is not requested so much. Users are around 100. New DataFiled may be added frequently. Which is best regarding using Custom Object, Typed DataSet or DataSet I saw so much discuss and confuesed. Is anybody with true experience will share experience If using typed data set, it will be dangous to crash with later on recompilie Thanks a lot. I just wanted to share my views. Typed dataset is useful at time of development but it may be costly incase of performance DataSet can be used but it is having lots of things with it(Constraints, relations etc.), if you are not ...Show All
Visual C++ C++/CLI: Best practices for designing library
Hi, I'm working on library written in C++/CLI that will be used only from C++/CLI (which means that I don't need to produce pure .NET assembly), so I'm looking for some tips and recomendations how to design C++/CLI library (especially what are the possible ways for building and redistributing it, how it could be used in other projects, etc..). I have the following needs: It must be distributed with some header files (because I need to use templates in several classes) I need to separate declarations (.h files) and definitions (.cpp files) I'd prefer to distribute it as a dll with some header files, but distributing it with the complete source wouldn't be a big problem... Probabbly the only possibility is to split class ...Show All
Game Technologies: DirectX, XNA, XACT, etc. Compiler support
Will the XNA framework support the standard .NET framework APIs for compiling C# code into loadable assemblies at runtime I currently use those APIs to compile game scripts on the fly at startup to enable faster prototyping, but I can imagine reasons for these APIs not to be supported on the 360. On Windows you can continue to use any .NET class libraries available in the 2.0 framework. Please be aware if you stray from any libraries that aren't on the Xbox 360, this will limit your code portability (as I'm sure you already know). On the Xbox 360 we currently don't support the C# code compiler. Your scripting scenario is a commonly requested (and super important) one and we are investigating potential sol ...Show All
Software Development for Windows Vista Marked application(embedded manifest) doesn't elevate when UAC is turned off?
Hi I'm testing my app on vista Business K. I've embedded manifest file and running it with shellexecute. It correctly gets elevated when UAC is enabled. However, when UAC is turned off, it won't get elevated as it should. Most surprisingly, one of two identical copies of the application has the windows security logo mark on the icon and one does not. I know the two files are identical for sure because their sha-1 checksums are identical and all other properties are the same(size and etc) What the heck is going on here Is UAC still buggy Thanks in advance. Julien mentioned ' If your account has not admin privileges, the the app runs in low privileged mode.' Is it certain that the app runs in * ...Show All
Visual Studio Team System Complications with installing TFS on untrsuted domain
Hi, I saw the a post put up a little while ago mentioning problems with users on trusted domains. I have a question which is rather broad: We are thinking of installing TFS on a separate (untrusted) domain from which the users are on. I have seen that we will need to use the TFSecurity tool to add users to TFS. What we are looking at doing is eventually getting a CI build and automated deployment going. I was wondering if other users here had any experience/ideas of the possible complications here since we are talking on untrusted domains. Any thoughts would be much appreciated! Based on the link below it seems that such a configuration is not supported: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=436653&SiteID=1 The ...Show All
.NET Development How to extract files from a zipped folder ?
Since Windows 2003 allows you to extract the files from a zipped folder, by choosing Extract All... from the pop-up menu when you right click the zipped folder, I figure there could be a .NET method to do that. I have found an example in VBScript, and I'm wondering if someone here could show me how to do the same in .NET (I only need the bit that actually does the extract) Thanks in advance Dim FSO As Object Dim oApp As Object Dim fname Dim FileNameFolder Dim DefPath As String Dim strDate As String fname = Application.GetOpenFilename(filefilter:="Zip Files (*.zip), *.zip", _ MultiSelect:=False) If fname = False Then 'do nothing Else DefPath = Application.DefaultFilePath ...Show All
Software Development for Windows Vista Adding reference to COM COmponent in VC2005
Hi All, I am trying to use the HelpPaneProxy.dll com component from Vista. I am compiling on WinXP with VC2005. When I create a "console app" project and go to "References.." -> "Add new reference", only the Projects tab shows up. where is the COM tab how can I generate an inter-op DLL to access this COM component thanks, stan Hi, stan I have met the same trouble recently. Please tell me how to get list of reference s. thanks fun ...Show All