AndyL's Q&A profile

• .NET Development Role Based Security

  Hi, how can I implement a role based security with WSE 2.0 Greetings, Dieter ...Show All

• Visual Basic reading from an xls file (into VB) without using Excel

  Hi everyone, I've written a program in VB which accesses data from an xls file. Right now I open excel, and then hide it (so it is invisable to the user) to read the data from the file. Then I have a close button on my program which the user can click and as the program exits, it also closes excel. I have removed the "x" from the taskbar on my program, but I still run into problems if the user uses ctrl+alt+del. I am sure this is probably the worst way to read from this file, but it does get the job done... although very buggy and error prone. I was wondering if someone could inform me of a way to read in this data in a more efficient manner. Possibly even if the user doesn't have excel installed on their computer I am no ...Show All

• Architecture list of icons in the icon notification area

  Hi, I'm looking for a method to determine which icons are placed in the notification area, regardless if they are active or not. With google I noticed a program called: sti_EV.exe at http://system-tray-icon.qarchive.org/ which shows that it is possible what I want. My meanings are to capture the event of a change in the area and then check if a certain icon is placed. For example an icon that notifies a failure. TIA, Gearloose I've been studying a little and I'am able to create a list of applications that have an icon installed in the notification area. Most of them are "explorer.exe" because they are system icons, like networkconnectivity. Now I want to creat ...Show All

• Visual Studio Team System CRM Dll files

  the dll files that used in the application of the CRM that is in the MSDN 1- Microsoft.Crm.Platform.Proxy.dll 2- Microsoft.Crm.Platform.Types.dll was not in the path of the C:/Inetpub/wwwroot/bin folder and i want add those dlls to the solution, help me in finding these files or send me it plz. My question is where can i download these files Try better on the Microsoft CRM newsgroups http://support.microsoft.com/newsgroups/newsReader.aspx lang=en&cr=US&dg=microsoft.public.crm&sloc=es , this forum is only about Team Foundation server issues, sorry and good luck. ...Show All

• Software Development for Windows Vista How to use IfElse

  Hi I'm an absolute newbie to WF (and the concept of workflow itself), and although I've been through MSDN Magazine articles and MS E-Learning, I still can't figure out how to use the IfElse activity in the designer. If someone has a spare moment, could you write a little step-by-step example about it Cheers Chris Drop the if-else activity from the toolbox in the designer. You should see a red exclamation mark. Click on that and it should highlight the "Condition" entry in the Properties window (typically on the lower right corner). Click on that entry in the properties grid and you should see a drop down. Choose CodeCondition or DeclarativeRuleCondition. If you choose CodeCondi ...Show All

• .NET Development selecting data from datalist

  Hi all I am having problem in selecting the data from my datalist. Here is teh sample code < asp:datalist id="dlAttrName" runat="server" OnItemCommand="dlAttrName_SelectData" DataKeyField="attrID" > < ItemTemplate > < asp:LinkButton ID="lbSelect" Runat="server" CommandName="Select" style="display:none">Select</asp:LinkButton > < %# Container.DataItem("attrDef1")% > </ ItemTemplate > </asp:DataList> Private Sub dlAttrName_ItemDataBound( ByVal sender As Object , ByVal e As System.Web.UI.WebControls.DataListItemEventArgs) Handles dlAttrName.ItemDataBound ...Show All

• Visual C# Request.QueryString

  In VB, we can use: s = Request.QueryString("name") In C#, when I use it the same way: s = Request.QueryString("name"); or another way: s = Request.QueryString["name"];  compilation error is " CS1513: } expected ".   Why You are right, the error may not be caused by Request.QueryString. Now I change the code as follows, the same error still exists: <%@ Register TagPrefix="article" Namespace="article" Assembly="webcolumn"%> <%@ Register TagPrefix="article" Namespace="article" Assembly="articlecolumn"%> <script language="C#" runat="server"> void Page_Load(Object sender, EventArgs e) {  if (!Page.IsPostBack)  {   string s;   s = Request. ...Show All

• Visual Basic Add New Data Source for My SQL doesn't work

  I have tried also installing and using the ODBC driver version 3.51 and the My SQL driver 3.1.8.  None of these work. What do I have to do to add a new MY SQL data source Michael Michael, I've had the same problem as you. Fortunately I managed to sort it out. The steps: 1.     Set up your ODBC DSN in: Control Panel -> Administrative Tools -> Data Sources         (Use the MySQL ODBC driver). Make sure it's a System DSN. I think you can leave the         initital database/catalogue name blank (the automatic request doesn't seem to work                 anyway). 2.    &nbs ...Show All

• SQL Server Change the WHERE conditions dynamically

  Is there a way I can build a case statment or similar to handle different where conditions I know I can do it dynamic sql but it would be nice to have a method where I can create the querries directly in a normal statement Someting like: Select c1, c2, c3 From Table WHERE Case @Condition WHEN '>' @SelColumn > @Limit WHEN '=' @SelColumn = @Limit WHEN '<' @SelColumn < @Limit END I know this doesn't work so an example that do work would be nice. Can't you use a T-SQL IF statement instead IF @Condition = '>' SELECT ... FROM .. WHERE @SetColumn > @Limit ELSE IF @Condition = '=' .... WHERE @SetColumn = @Limit This will get you the best performance if ...Show All

• Visual Studio 2008 (Pre-release) -

  I'm not sure if this is the right forum for WCF questions/comments, but here goes one anyways... I created a "Hello [Name]!" WCF service and hosted it in IIS by defining creating a web.config as explained in the WCF Hands On! book by Craig McMurtry. The web.config file was originally using "basicHttpBinding" and I genereted a proxy for it which was quite simple to follow. Then I changed my client and the service (by changing web.config) to use "wsHttpBinding" (which encrypts the message) and it worked just fine (and it did encrypt the message). Once thing to notice here was that I was still using the proxy that was generated when the binding was basicHttpBinding. Next I added a new method to my service and regener ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Windows XNA default template will not run (any suggestions?)

  Hey Everyone, I have installed all the required goodies on two computers; on the first, everything works as expected. On the second, I am running into an error when I attempt to run the compiled build of the default XNA game template. The error signature reads: EventType: clr20r3 P1: xnatest.exe P2: 1.0.0.0 P3: 44fa3432 P4: microsoft.xna.framework.game ... etc. The second machine had VC# Express on it since June, DX Aug 2006 SDK was installed prior to installing XNA GSE; the latest DX run-time is also installed. Also, I do have the .NET Framework 2.0 redistributable installed. The error appears to be related to the CLR, but any advice/suggestions would be super-appreciated. Thanks :) ...Show All

• SQL Server Merge replication - changing values from filtered column

  Hi I'm working with merge replication between Sql Server 2005 and Sql Server 2005 Mobile. I'm using dynamic filtering by function HOST_NAME (... where Table.FilteredColumn = HOST_NAME()) When I'm trying to chagne values from filtered column on the client side (Table.FileteredColumn) I get error message that the column is read-only. How can I change data in filtered column Is this possible   I solved this problem. This was my fault, because I used filter option: I row from this table will go to only one subscription. When I changed it to: I row from this table will go to multiple subscription (partition option: Overlapping) evertything is OK. Thanks ...Show All

• SQL Server Alerting operators for all jobs

  Hi there, I'm not sure which section this really comes under and I think 'availability/disaster recovery' is probably the most applicable, sorry if it isn't. I have SQL Server 2005 set-up and about 50 jobs listed, now, these jobs were configured before an operators with alerting by email was set-up... so, none of the jobs when fail alert an operator. Is there any way I can automate a solution so if any job fails a designated/or default operator will be emailed and told what happened Or would I need to edit each job manually to set this Thanks Ed ...Show All

• .NET Development how to read only certain fields(columns) from a loaded dataset

  1)how would i read only certain fields(columns) from a loaded dataset and display them in a datagridview for instance: if i have a datasetAll which has col1,col2,col3,col4,col5,col6.... now i want to retrieve col1,col3,col5 based on filter condition and show the results in a datagridview. thanks Just remember that Select is a copy method, the results of which are not connected to the original data table. Therefore, updating one DataTable will not update the other DataTable (a'la DataView). ...Show All

• Visual Studio 2008 (Pre-release) Usercontrol preview

  When I add a User control in my XAML Window, Cider show me the whoops error. Is this the expected behaviour for beta 2 release or there is something wrong with my installation If yes, does the June CTP resolve this issue BTW I also tried the WPF WinSDK samples and I see the same problem. Thanks, Raffaele Hi Raffaele, I have the same problem on my machine. I use Vista 5456 and VS Orcas ("Cider") June CTP.   -- Andrea ...Show All