sunny123's Q&A profile

• Microsoft ISV Community Center Forums Making process modal

  Hi all I need saving from myself! I have a subroutine in Access which opens four Excel sheets and does extensive updating. The process takes 4 to 5 minutes. Before the process starts in earnest I check to see if Excel is open; if it is I stop the process and request that the user shuts Excel down. The problem with having Excel open is that the macro can end up picking a workbook which is open and not part of the routine, or the user continues to work on their open sheet, which effects commands such as ActiveSheet etc.. However, while the macro runs I often check my mail, which normally has Excel workbooks attached. Without fail I end up openning the workbook and crashing the subroutine. Is there a way to lock excel while I process, o ...Show All

• Visual C++ linking problems with templates

  Hi people, i'm using a templated class on my dll and it compiles and link fine, but I find that it has introduced some symbols of my templated class on the dll. It also happens with any program that includes that templated class so I have linking errors on programs that use this library because of the redefined symbols. I'm feeling fairly certain that the problem is in your project or header setup, though. I downloaded the VNL library, compensated the other missing types and compiled a static library from the code you provided. That worked out just fine. Even with use in an external project, everything compiled like a charm. Could you shed any more light on your setup, or perhaps make your project publ ...Show All

• Software Development for Windows Vista About the workflow desiger Rehosting?

  When I try to load a xoml file using the designer( http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnlong/html/WFDsgnRehst.asp ) ,I meet the Exception msg {"Invalid character in the given encoding. Line 2, position 53."}. try { WorkflowMarkupSerializer xomlSerializer = new WorkflowMarkupSerializer(); rootActivity = xomlSerializer.Deserialize(reader) as Activity; } I think the xomlSerializer.Deserialize method can not Deserialize the xoml file that include the acitvity name like " "(chinese). how can I solve this problem this is the xoml File <SequentialWorkflowActivity x:Class="foo.Workflow1" x:Name="Workflow1" xmlns:x=" http:/ ...Show All

• .NET Development How do you insert and update the database using DataSet (for VS .NET 2005)

  Hi! I'm currently new to VB .NET (through VS .NET 2005). I am in need of assistance regarding how to insert and update the database using DataSet. I am using OleDb in my program. It doesn't produce a syntax error after being compiled and executed but the data is not stored in the database. Please help if you can as soon as possible. Even a sample source code will do, it would even be better to give some explanation too. Thanks a lot! How do you update database Do you call Update method of the DataAdapter to do this. If not, then this is the reason. If you call Update and you do not see anything in a database, then check if you do not call AcceptChanges method before you call Update. AcceptChanges res ...Show All

• .NET Development pass values between web pages

  I have 2 pages and I want to pass values from one to other. I looked at this link http://msdn2.microsoft.com/en-us/library/6c3yckfw.aspx and I found a solution. When I implement myself, I have some problem: Source page: ------------- public partial class TreeView : System.Web.UI.Page { public string SelectedNodeText { get { return TreeView1.SelectedNode.Text; } } } Target page: ------------- private string selectedNodeText; protected void Page_Load(object sender, EventArgs e) { if(Page.PreviousPage != null) { TreeView treeView1 = (TreeView)Page.PreviousPage.FindControl("TreeView1"); selectedNodeText = treeView1.SelectedNode.Text; BriefRiskDescriptionTextBox.Text = sel ...Show All

• Visual C++ Hide console window

  Hi, in my console application i want to exit the console and switch to a windows form. opening te form works fine, but the console window is disturbing at this time. how can i hide the console window or do i have to create a windows forms project instead thanks in advance! einaros wrote: Try FreeConsole(); Is it possible to make it so that the console windows is never created in the first place longwood ...Show All

• SQL Server Default to NULL instead of blank/empty string during flat file import

  Hi, In SSIS flat file import using fastload, I'm trying to import data into SQL 2005 previously created tables. The table may contain column that are NULLable BUT there is NO DEFAULT for them. If the incoming data from flat files contains nothing either between the delimeters, how can I have a NULL value inserted in the column instead of blank/empty string I didn't find an easy flag unless I'm doing something wrong. I know of at least two ways to do it the hard way: 1- set the DEFAULT(NULL) for EVERY column that needs this behaviour 2-set up some Derived Column option in the package to return NULL if the value is missing. Both of the above are time consuming since I'm dealing with many tables. Is there a quick option t ...Show All

• Visual C++ Single vs Multiple dlls

  Hi, I am building an ATL COM DLL component. There are many functions to be exported (around 100). I want to ask about the performance gain/loss in case I build a single DLL exporting all functions or in other case build multiple dlls. Thanks & Regards, Omer Javed If all functions are used in the same client, it is better to keep them in one Dll. Loading one large library to memory is faster than loading number of small libraries. ...Show All

• Visual C++ Calling C# Main() in C++.NET

  Hi, I am a newbie and I wanted to know if it is possible to call an application written in C# using C++.NET. I know that Main() is the entry point of the this C# application...so can I launch the C# application by calling its Main() from a C++.net program Is this related to managed and unmanaged code Do I need to include the class where Main() is located in the C++.net program Should I do that by "#using classWhereMainIsWritten" or using the namespace Help! Gordon, I searched for an exe file in the solution directory and the only exe file I found was the exe file that belongs to the C++ project. The C# project only created a .dll file ...no .exe file :-S So, if I am not wrong, then a ...Show All

• Windows Forms How does the designer locate an assembly ?

  I can see the topic about locating assemblies at run-time. My question is how the VS 2005 IDE and the Windows Form Designer locates an assembly a design time. I have my own assemblies of components, which I am testing and which therefore do not have strong names and are therefore not in the GAC. I was able to add my assembly's components as Toolbox Items through the Choose Toolbox Items... dialog and by browsing to the directory where the assembles are located. When I create a .Net application and use the Toolbox it appears that the IDE will always know where my assembly is at design time because the full path to the assembly is in the Choose Toolbox Items... dialog. Is this all that is needed at design time to locate an assembly for the d ...Show All

• Visual Studio Express Editions Combobox and Datagridview

  HI, I apologize if this has been covered. I'm sure there is a quick solution for this. I'm want to be able to take a selection from 2 comboboxes and display this data in a DataGridView. The Comboboxes are filled with data from a Database. Also I only want the GridView window to display data from the selection not everything in the table, so it would remain blank until a selection is made. One last thing, how do I stop duplicate data from being displayed in the comboboxes. Should I setup separate tables and make the tables relational Thanks in advance. Peter Yes. Drag and Drop. One other thing, I have 8 columns on the DataGridView, out of the eight, 3 won't display the data ...Show All

• SQL Server Parameters not getting refreshed???

  Hi All, I am getting some wierd problem in my reports. I have deployed several reports on the server and when I am giving some parameters for the report, it does not take it and runs the report on complete database. What can be the reason. Few days ago, everything was working fine. I was using a separate datasource for each report. But then I created a shared datasource. Can that be the reason Please help me out !!! TIA Another alternative to determining whether or not your parameters are functioning properly is to click out of the design mode and view the MDX query. There will be a "Query Parameters" button in the toolbar directly to the left of the "Prepare Query" and "Execute Query" b ...Show All

• .NET Development Is there any method to assign encoding in mailaddress?

  Hello. I have faced the problem about automatically sending email in my system. My website is allowed people type in chinese character and two of them are: 1. Seller Name 2. Seller Email Address After people type in all their information , a email will be sent for them for reference. Firstly, I found that while user type in chinese character in Seller Name Textbox, that email will become unrecognised code like this " P q C L " . My coding is shown below: MailMessage mailMessage = new MailMessage(); mailMessage.To.Add(new MailAddress(seller.Email, seller.Name)); It seems that I can't use chinese character as a displayName in MailAddress. Is there any method As I know, I can give encodi ...Show All

• .NET Development Credentials & FileSystemWatcher

  Hi, How Can set up username and password in my FileSystemWatcher to watch a protected shared folder in my network thanks in advance ...Show All

• Visual Basic Cross Threading in General

  Can someone answer me this question... I have programmed in VBA for years. It seems to handle directly accessing simple form objects without any worries about threads or cross-threading or whatever... It seems ( also ) to me, that this threading issue could be internally managed by the Control Class to some degree or another. Is there a good reason for this new Thread Issue that I am unaware of ... is this code I can sell Can you advise which line causes the debugger to hang ...Show All