knarf's Q&A profile

• Microsoft ISV Community Center Forums SaveAs question

  Hi, I have a piece code that does SaveAs at the end of the program but it always tells me that file already exists and do you want to replace it. I do not want that message to pop up and i want program to just overwrite it. I had in the code both application.displayalerts and screenupdating set to false but still does not work. I had the same code in another macro and it works fine. Any ideas why this does not work. I am exahausted trying to figure this out. please help thank you Hey I think this piece of code will help you Function SaveWorkbook(Myfile As String, Optional DisplMess As Boolean) As ...Show All

• Smart Device Development .Net Compact Framework:Unable to connect to remote server

  Hi All, I am working on a handheld device application. The issue that I am facing now is that my handheld has to be within the firewall before connecting to the server.With this, I have problem connecting to the server with the message "unable to connect to the remote server" However, by passing the firewall, it works fine. Are there any special coding for .NET CF in order to work within the firewall Just for a note, firewall port 80 is open up and able to view the web services. What is wrong Appreciate your help very much. Gary Hi Gary, You should be able to access web se ...Show All

• SQL Server Data Source for Process Cube

  Is the source for the data used to process the cube actually embedded in the cube itself   I.e. I have source data which could move around.  How can I programatically modify the source connection string before processing the cube using SSIS You are brilliant.  I knew about the scripting feature however I wasn't thinking about the data source being surfaced in the Management Console for analysis services.  Thanks! ...Show All

• SQL Server Size of database seems a bit large

  I developed a vb app that imports csv data into an sql server db. The original text file is 36.5mb. The db after import is 230mb and the log file is 555mb. Is this normal Since this is a (more or less) separate issue I am moving it to a different thread: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=271650&SiteID=1 ...Show All

• .NET Development Slow function getpixel

  I am programming imageanalysis using VS2005 VB and the use of the single line k = apicture.GetPixel(i, j).R over all pixels in the image is very time consuming. Is there a faster way to get the pixel intensity of a pixels in an image held in memory kind regards Morten Use the LockBits method: http://www.bobpowell.net/lockingbits.htm ...Show All

• Visual Studio Express Editions How To Loop On Rows From A Database Table

  I want to loop on the rows from a database table, but I can't work out how to do it. So far, the code I have is: Dim sConnectionString As String _ = "User ID=myname;Password=myPassword;Initial Catalog=mydatabase;Data Source=123.22.44.35,1433" Dim objConn As New SqlConnection(sConnectionString) objConn.Open() Dim sSQL As String = "SELECT * FROM manufacturer_list" Dim objCmd As New SqlCommand(sSQL, objConn) So from there, how could I loop through each record Thanks. This is a good example. http://support.microsoft.com/default.aspx ...Show All

• SQL Server Is there a way to Un-sum in SQL Server 2000 Reporting Services

  I have a project due shortly and keep getting Sum(Field!Amount.Value) instead of just =Field(Amount.Value) in the detail row. s there a way to pull in results from multiple queries in one datasets in the SQL Reporting Services 2000 I have to add an amount field in different fields and I keep getting the Sum instead of individual amounts if I use different datasets and if not, I get the same amount. Is there a way around this Thank you for your help. SK You have to join the data in the data set query. There are multiple options to achieve this: * if the data comes ...Show All

• Smart Device Development Installation on a SD card

  Hi all, I have a cab file and the problem is if I choose to install it on a SD-Card, the dlls and the exe files will be anyway installed in the main memory of the PDA. What is the reason for this and how can I changed it Thanks for help Karin If you mean NETCF CAB, that's by design and you can not change that. Please see this: http://blogs.msdn.com/netcfteam/archive/2005/10/11/479793.aspx If you mean your own CAB, please make sure you're "InstallDir" macro to install your files: http://msdn.microsoft.com/library/default.asp url=/library/en-us/wcesetup/html/_wcesdk_CEStrings.a ...Show All

• Visual Studio How to add custom control to Visual Studio 2005 Toolbox?

  Hi all, I am working on a Windows Forms custom control now and I would like to place my control right on the Toolbox window after installation, however, this seems to be a problem now. I notice that EnvDTE and EnvDTE80 namespace and the DTE2 interface seem to provide customization of VS IDE environment, and I tried as follows: 1> Get a DTE2 instance by Activator; 2> Use DTE2.ToolWindows.ToolBox.ToolBoxTabs.Add to add a new tab; 3> Use ToolBoxTab.Add(name, object, vsToolBoxItemFormat) to add my control. here name="Control1", ie, and object=@"C:\Control1.dll" as mentioned in MSDN. Here is the problem. this method should retu ...Show All

• Visual C# datarow

  hi,    i already have the data from the database in a datatable. i have a column for date, reghours, othours, status. i want to get the data of a certain date and sum of reghrs(which means there's a possibility that there would be more than one row in a certain date). i have 7.0 in my textbox1. in my textbox2 it will display the difference of my textbox1 and total reg hrs. Instead of pulling the entire table into a datatable, it sounds like you should be sending the database a SQL query and retrieving the results in a datatable (or datareader).  Your query would simply be: SELECT so ...Show All

• Windows Forms Windows Form Transparency Problem

  I have been creating a Skinnable Desktop application, for which I have used Picture Box to load different skins, and the skins are getting loaded from XML files. My development Server is Win 2003, to make my form transparent I am using a blue image(#0000ff) called blue.bmp and then setting the transparency key to blue, and its is working fine in Win&nb ...Show All

• .NET Development system.objectdisposedexception

  Hi, I have a multithreaded application that crashes with the following msg in event log ... EventType clr20r3, P1 smartserver2005.exe, P2 1.0.0.0, P3 43f6cc52, P4 system, P5 2.0.0.0, P6 4333ae87, P7 3ad8, P8 a5, P9 system.objectdisposedexception, P10 NIL. I have provided try catch block in all routines in the code & still the appl crashes with the above msg. Note that crash is not consistent for a particular sequence of events. Any suggestions -S.Malathi Hi! It appears that one of your threads Dispose() some object and another reference this object later. Disposing doesn't mean obj ...Show All

• SQL Server Making FTP Task retry until file shows up

  If I want to download a file, but I don't know if it's available yet (actually positive it won't be available for some time), how do I make FTP Task retry/wait until file shows up in the ftp folder You can have a loop that continues until you set a variable to a certain value to indicate success, In addition add a script task that has a line Thread.sleep(1000). That will sleep the package for 1second, you will need to add imports System.Threading to the Script task at the top. The other option is to schedule your package to run every minute or 5 minutes. This has the benefit in that you don't have a long run ...Show All

• Visual Studio Team System Not sure how to approach this

  Hi, all. I am writing a custom validation rule to validate certain fields in a data grid. I was trying to use the collection of tags in the response to parse it to get the value in the grid field. So, I started from grabbing all the tags. But my grid data looks as following: <td>value</td>. I guess I can only get the tag attributes taking this approach. Can you recommend me how to get the element value by parsing the HTML response Please let me know if I am not clear in my explanation or if you need more details. Thank you. Check out this post which is asking a similar question: ...Show All

• Windows Forms Button Image Property

  I am working on a VB .NET solution, and I have a form with some buttons with images (.bmp files) displayed on them.  During certain events, I want to change the image bitmap.  I have all the images loaded as resource files within the .NET solution.  So i need to run the following command, but can't figure out how to set the han ...Show All