DETNYRE's Q&A profile

• Visual Studio Express Editions Can I use VBE 2005 classes in Excel 2003 VBA code?

  I have a class library that I'm developing in Visual Basic Express 2005. I can use the classes in other projects in VBE, but I would also like to use them in VBA code in Excel 2003 (i.e. in the VBA code I want to be able to create instances of the classes from the class library).  If that is possible, can someone please give me step by step instructions Yes, that seems to be the same error. Make sure that you sign the assembly with a strong name, and use the /codebase option when registering. If that still doesn't work, you could try adding the assembly to the GAC using the gacutil.exe tool. Blackwood, depending on how you intend to use/deploy your class, you should also consi ...Show All

• Visual C# Comparing values in an array and SqlDataReader?

  Hi ya, I'm trying to compare an array and the values of SqlDataReader and I can't actually figure it out. I used to work with ADO and new to .net I want to compare them and then if the values are not matched to the SqlDataReader, I want them to store it into a recordset but there is no recordset in Ado.net plus i think my logic has some flaws as well. Cheers The code: for ( int i=0; i <=countme-1; i++) { myCommand.CommandText = "select * from tbl_empDetails" ; SqlDataReader myReader = myCommand.ExecuteReader(); while (myReader.Read()) { if (myReader.GetString(abc) != SID[ i ]) { Response.Write(SID[1] + " " + givenName[1] + "<BR>" ); } el ...Show All

• Software Development for Windows Vista "callexternalmethod", when does it mostly help

  hello all, i want to ask about he usage of "callexternalmethod", when does it mostly help. thanks, Hello Abssi, The use is if you want to pass data from within the workflow instance to the host of the workflow, you might consider using a CallExternalMethod activity which could raise an event on your local service. Miguel ...Show All

• Visual C# Form MessageBox mouseleave

  Hi, I am using a form's showdialogue property to show the form as a messagebox. I would like the functionality so that when a user mouse over the form and then mouses out - the messagebox would close automatically. However, the mouse out event doesn't fire all the time, it fires sporadically. I'm not in love with this event, I would be glad to use another one if it achieves the same result. Any help Basically, I just want to call the dispose method of the form when the user mouses over and then out. Clarify! Your event is not Always Firing or Form is not correctly Dispose off If Form is not correctly Dispose of then how you are evaluating this. And what code you are using in MouseLeave Make sure you are hooking event han ...Show All

• Visual Studio Tools for Office Databinding in Excel

  Hi! I have an VSTO Excel project. I added a workbook that has 3 sheets in it and has all the formulas and functions built into the worksheets. It needs to stay there! I had a datasource and try to bind to a listobject or named ranges or anything and it over writes my functions etc that are already in the sheets. How can I databind using code to get the full results returned to the worksheet in the specified cells for each of the stored procedures, each sheet runs a different stored procedure. If I use the list object it over writes the code in the sheet and doesnt do all the calculations so I need a way to get data into each sheet just like I would import a csv file and copy and paste into the worksheet spaces. I hope ...Show All

• Smart Device Development Multiple instances of an application - bad

  I have an application running under WindowsMobile5.0. I have used the code below to make sure that I only get one instance of the application (I'm talking to a SDIO module - don't want more than one instance). It works fine after the first instance is up and running. However, if I tap the application name in the 'File Explorer' multiple times (4 or 5), I end up with the application launching 2 or 3 or 4 times. I have not yet found a way to prevent this. The reason this causes a problem is that the spinning processing icon doesn't appear immediately after the first tap. It is not obvious that the tap was accepted and it is not uncommon for the user to tap a second time and this can cause the problem. static class Program { [DllIm ...Show All

• .NET Development DataSet text representation.

  Hi! I don't know where i must put this, if is the erroneous forum... moderator please.. :D Well, i must send a DataSet via eMail, i can do it with .GetXml() method, but i'm looking for a more eye-candy representation than XML, somethig like : -------------------------------- | colum 1 | colum 2 | comlum 3 | -------------------------------- | value | value | value | -------------------------------- Somebody know some method/funcion/algorritm to do it :) Regards. There is no pretty printing method for this. You'll need to do it by hand. What will make it harder is the fact that positioning is based on the size of the text. Your best bet is to probably generate an HTML e-mail and store the data in a table so at least the ...Show All

• SQL Server Images and Drill-through reports asking passwords again + SQL Reporting Services with web service

  I have coded my project to access SQL Reports through webservices . I have bypassed  Report server username and password for administrators who have logged in. My problem is images (logo of our site) is not displaying . If right-clicked on the logo icon, it asks for report server username and password. ( But image is showing in IM AGE format not in HTML4.0 ) My drill-through report also have the same problem. I am using SQL Reporting services 2003 I am using rs.discountasp.net which is a secure server for reporting server database. I am not using RS2005 , i am into SQL Server 2000 reporting services.Will the unattended Execution account with rsconfig.exe create  security hole to my revenue re ...Show All

• Smart Device Development PPC Outlook - checking whether an email has been sent successfully

  Hi, Is there anyway to check  via code whether an email has been sent successfully I am sending an email via the following code: EmailMessage email = new EmailMessage (); email.Attachments.Add( new Attachment (_AttachmentPath)); email.To.Add( new Recipient (_Recipient)); email.Subject = "blah" email.BodyText = "blah"; // Send the message over the first email account available. email.Send(os.EmailAccounts[0]); thanks. This forum is intended to deal with issues directly related to the .NET Compact Framework. It appears that this question can better be answered by someone on one of the newsgroups for Windows Mobile or Windows CE. In order to get a qu ...Show All

• Visual Studio 2008 (Pre-release) TreeView items rendering

  I have TreeView with child nodes containing dockpanels. Each dockpanel has checkbox and textblock. The problem is that when i navigate through treeview nodes in some cases (e.g. when i expand node -> select child node -> select parent node) contenet of treeview item isn't rendered properly. Are there any ideas Here is screenshot: http://ibox.org.ua/ id=7455 Thanx in advance Actually whole problem was solved when i used TreeViewItems to hold all my node content and not drectly add UIElemets as childnodes ...Show All

• Community Chat Secure Data Organizer - A Free Password Manager Written in .NET 2.0

  Hi all, I've been working in .NET ever since the pre-RTM 1.0 release for my Master's Thesis. I continue to code in many languages but have been working on a pet project on the side called Secure Data Organizer. This is a free program that marks the culmination of several years of design and effort .It is a Password Manager but was designed to be the best one out there. Ease of use (even at the expense of developer pain) was a driving development principle, as was native and intuitive GUI, human-readable XML file format, and public disclosure of encryption algorithms and techniques. I released it as freeware to the web back in late November. Since then, we've grown to over 1,300 registered users--a nice starting userbase! Our big b ...Show All

• Smart Device Development Problems using TAPIV2

  Hi, I'm trying to use the TAPI-Wrapper for C# from Alex Feinman. I have Visual Studio 2005 with the WM5.0 SKD for Smartphone and for Pocket PC installed. Now I'm simply trying to compile the sample "MakeCallSP" but when I try I get the error "Metadata file 'c:\tmp\Visual Studio 2005\Projects\Tapiv2\TapiLib\bin\Debug\TapiLib.dll' could not be opened -- 'Version 2.0 is not a compatible version.' I tried changing the references, tried changing the destination-plattform for both projects, tried using the v2.0 mscorlib.dll instead the v1.0 and the other way around but it still doesn't work! I'm a bit helpless now, could someone please enlighten me :) Thanks! This DLL is designed for NETCF V2 s ...Show All

• Windows Forms HyperLink in DataGrid

  Hi I'm using a GridView in VB.Net 2005. One of the column of the GridView is Hyperlink Column. When i click the hyperlink i want some message to be displayed in tne redirected page. The message displays in each link should be different. How can i achieve this Where should i write my coding Thanks Hi Thanks for ur reply. The answer that u posted is not relavant to my query. I've made the first column of my gridView as Hyperlink Column. The problem is that whenever i click the hyperlink it redirects to a page with the same query string. I need the query strings to be different for each Hyperlink(Eg: I need the id of the clicked row). This is the code i've written Dim bc As ...Show All

• Visual C++ debug through functions linked by dllImport attribute

  Hi guys, I wanted to know if there is any way to keep debuging a funtion linked using DllImport in a c# class ! I mean going from C# to native c++ dll and debuging the DllImported functions ... Thanks hi alex, I had tested your second hint but it doesn't work... program flow doesn't come to native dll for debugging ... i will try your first hint . by the way both of options works fine when using managed c++ .... but in c# there are some troubles ... if you know a link or tutorial about this, plz send me ... Thanks thanks ... ...Show All

• Visual Studio 2008 (Pre-release) Extending EndPoint Configuration

  Does anyone know if it possible to extend the EndPoint configuration element. By this what I mean is i would like to do the following: Current: < endpoint address = " http://localhost:8080/service1 " binding = " wsHttpBinding " bindingConfiguration = " WSHttpBinding_IService1 " contract = " ConsoleClient.ClientServices.IService1 " name = " WSHttpBinding_IService1 " / > Extended: < endpoint address = " http://localhost:8080/service1 " binding = " wsHttpBinding " bindingConfiguration = " WSHttpBinding_IService1 " contract = " ConsoleClient.ClientServices.IService1 " name = " WSHttpBinding_IService1 " my ...Show All