pangitko79's Q&A profile

• Windows Forms Problem with Properties and shortcuts

  Hello there. I have created a clock proggy with Visual C# Express 2005 and deploy it with clickonce on winXP. Works good, but I have a little problem. I have set some properties (for user, not for application) like the location of my clock on the screen, its backcolor, whether or not it has to play a sound, etc. As expected, these settings are correctly saved and handled by C#. Some days ago I decided to add an "autostart" feature, and since I don't want to mess with the registry I chose to create a shortcut in the startup folder using a WSH wrapper. The shortcut gets created and deleted well so I thought it was fine and published the program on my web-space. The problem is this, if I lauch the standard shortcut (placed in the ma ...Show All

• SQL Server Like statement in a filter

  In a report I want a parametered filter on a specific text. I tried with the following statement: =Iif(Parameters!Filter.Value="Example",(Fields!Warehouse_Class_Code.Value),"NULL") like %TEXT% But no result. Please help! I have a table with several values: HARPAL06 CITPBK01 HARPBK08 HARPAL02 ONPAL07 I want a parameter with a filter on the records with the text "PAL" I tried =Iif(Parameters!Filter.Value="Example",(Fields!Warehouse_Class_Code.Value),"NULL") like %PAL% But this doesn't work. ...Show All

• SQL Server toggle all

  I have seen other places where this question is asked, but I am still not seeing the answer clearly. If I have many groups that are collapsed and I want to expand them all at the same time, it there a way to accomplish this Many talk about a param that can be passed in, but even if you have the parameter set, this is only for the initail state, is it not No, it's not only for the initial state. The report will be refreshed when the parameter value changes. So if you set the hidden property on the groups to be dependent on the parameter value, e.g. =IIF(Parameters!ShowAllGroups.Value, false, true). By setting the value of the ShowAllGroups parameter to true, the groups in the re-rendered the report will be ...Show All

• Visual Studio Express Editions Complete Newb Question - PLEASE HELP!!

  Begginer C# programmer here (begginer programmer in general). I am currently reading Learning C# 2005 from O'Reilly, and I've come across a stubling block early. When going to compile the helloworld.cs console app, the book instructs me to go to Start, Programs, Visual Studio 2005, Visual Studio Command Prompt so I can run the csc command to compile the app. Problem is, I'm using Visual C# Express 2005, which doesn't have this option, at least not in the same area. I have figured out on my own how to build the app in Visual C#, but the book mentions that 90% of the examples are built as a console app in this way, to simplify learning the language, so I would like to know the proper way to duplicate the process of running the Visual Studio ...Show All

• .NET Development Remoting and Write operation fail

  Hi! A have a problem with Remoting through TCP. I have a Service that provides access to object through Remoting and Client application, that calls method of this object through TCP secured channel. When I first run my client, it's OK, but when service is stopped and started again, and I try to call method again I am getting an exception and can't find out what happens. Help me please, I have no variants, what is wrong. Another ASP client calls other methods of my remote object sucessfully... System.IO.IOException was unhandled Message=" , . ." Source="mscorlib" StackTrace: Server stack trace: System.Net.Security.NegotiateStream.ProcessWrite(Byte[] buffer, Int32 offset, Int32 ...Show All

• Visual Studio Team System KB Article on the fix for the "TFS Project comma issue"

  I posted a MS Project to TFS problem back in June and was told then that "A KB article on this issue will be released in the next couple of weeks. Meanwhile, you can call CSS and ask them for the fix for the TFS Project comma issue." Can anyone tell me if the KB article has been released TIA Ron L Yogita The issue I was trying to resolve is in this post: http://forums.microsoft.com/forums/ShowPost.aspx PostID=490927&SiteID=1 . You answered me at the time that the KB article should be available "soon" or I could call Customer Support. I was hoping that the KB article had come out. Ron L ...Show All

• SQL Server Finding all views with a specific name, in all databases

  Hi, We are migrating to SQL Server 2005 from 2000 and we have a view created in many of our databases. That view must be changed after the migration because it uses system tables and does not return the correct information in SQL Server 2005. To do that, I want to create an SSIS-package that loops through all the databases on a particular server. If that view exists in the database, I want to run a script that change the view. What I try to do: Set up a For Each Loop container with Foreach SMO Enumerator Set the connection to my server Set the Enumerate property to "SMOEnumObj[@Name='Databases']/SMOEnumType[@Name='Names']" On the Variable Mapping page, place Index 0 in Variable User::dbName In the For E ...Show All

• Visual FoxPro impersonateloggedonuser and Getfil()

  Iam running VFP 9 with SP1 under windows 2k. In order to protect my database/table files on a network I have created a single user who has access to the folder where the files are contained. This is the only user with access to the folder. When an individual on the network runs the application the application logs on as that user and has access to the database files...the code goes like this.... #define LOGON32_PROVIDER_DEFAULT 0 #define LOGON32_PROVIDER_WINNT50 3 #define LOGON32_PROVIDER_WINNT40 2 #define LOGON32_PROVIDER_WINNT35 1 #define LOGON32_LOGON_INTERACTIVE 2 #define LOGON32_LOGON_NETWORK 3 #define LOGON32_LOGON_BATCH 4 #define LOGON32_LOGON_SERVICE 5 #define LOGON32_LOGON_UNLOCK 7 DECLARE ...Show All

• SQL Server How to connect SQL Server 2005 in WAS 5.1

  Hi All, One of our database server has upgraded from SQL Server 2000 to 2005 version some days ago, but I found the application which could run before cannot work fine now. I have followed some intructions got from other guys, such as replace the old driver with a new version, but it still did not work. Now I have two questions 1. What is the driver implementation class name I found there were several answers. (I don't use XA connections) 2. What is the data source helper class name I suspect that the above questions are the causes. However, please give me some other hints if any. Thank you very much! The driver implementation class name is com.microsoft.sqlserver.jdbc.SQLServerDriver. The datasource name of the com ...Show All

• Visual Studio Express Editions Keyboard

  Is there a way of locking the keyboard in VB (I dont want to actually lock the computer like CTRL+L i want to just block the keyboard.) It is not going to randomly happen, it will happen when a user requests it. ...Show All

• Visual Basic Close running process

  Hi, I'me creating an e-mail listener that gives me the aballity to control my computer by sending emails to a certain address. It allready can open programs, send files, send who is currently logged in,..etc. However there is one last thing I want it to do that I can't figure out, if its possible in the first place. So here is my question. Could you close a running process just by knowing it's name example outlook.exe, or msmsgs.exe thnx in advance Thx, it works. Don't worry though I took as much security messurements as i could tink of, and the program has limited control to the system, it's not like you could start every program or close down every program, same as sending files, it can ...Show All

• Microsoft ISV Community Center Forums Order by in select statement not working

  Hi there - i have a select statement that runs on form load that allows selection of appropriate company names from a combo box based on if the user is the owner of a company, which works great, syntax is below; Me.companyname.RowSource = "SELECT [companyname] FROM [qryactivity] WHERE [active] = Yes AND [leadofficer] ='" & loginname & "'" However i want to sort them alphabetically by name but cannot get it to work, i keep getting syntax errors, i have added the following code but it does not like it: Me.companyname.RowSource = "SELECT [companyname] FROM [qryactivity] ORDER BY [companyname]ASC WHERE [active] = Yes AND [leadofficer] ='" & loginname & "'" any help would be greatly appreciated. Rhys. ...Show All

• Visual Studio 2008 (Pre-release) Grouping of paragraphs of FlowDocument

  Hello to all, I do not know exactly how can I express what I really want to do, so I hope your experience will help you to understand me. :) I have a table (from a SQL database) which looks like: Col1 Col2 Col3 Item1 Item_a Item_A Item1 Item_a Item_B Item1 Item_b Item_C Item2 Item_c Item_D Base on this table I want to create runtime a FlowDocument with paragraphs grouped by column 1 and then by column 2 into sections - something similar with the listview grouping capabilities. Does any one have a idea is this possible and if yes how Thanks a lot, Ovidiu programmatically you could read the columns and create the paragraphs as children of a section. ...Show All

• Windows Forms Custom Drag/Drop Reordering of Rows/Columns in DataGridView

  Greetings all, If you’re looking for a challenge, then this one’s for you! I’m somewhat embarrassed to have to ask for help with this problem, but after many fruitless hours of attempting to find a solution on my own, I thought I would ask the experts. Here’s the scenario: I’m trying to extend the DataGridView class to allow for custom drag/drop reordering on rows and columns. From a user’s perspective, the sequence of events should occur as follows: 1. The user clicks (and releases) the left mouse button on a row or column header cell to select the row or column. 2. The user then clicks (and holds down) the left mouse button to initiate a drag/drop operation which will allow him/her to reorder the selected row/column within ...Show All

• SQL Server Removing Named Instance

  We want to rename our instance and I understand there isn't a straightforward way to do so. I'm prepared to run SQLEXPR again to create the new named instance. However, I'm not clear on how to remove the other named instance once the data files have been moved over. I do not want the old service "SQL Server (<old_named_instance>)" to be running. I would also like the files "C:\Program Files\Microsoft SQL Server\MSSQL.1" removed along with the registry entries for this instance. I tried running SQLEXPR with a / option but that invoked the installer and did not give me the command line options. Is there a simple way to remove a specific named instance Thanks. The command line inte ...Show All