davidemile's Q&A profile

• Visual Basic (NEWB) Using .split()?

  VB express '05 Beta I have a large string (about 40 pages worth of data) That I need to parcel into smaller chunks, there are repeating markers in the data that I want to use as delimiters.  txtimp is the large raw string, and hand() is the string array that I want to have the data chopped into. I'm using: stray()=txtimp.split("Data")   But, It is only searching for "D", not "Data".  There are frequent D's in the text, so It's giving me many smaller strings I dont want. In the IDE, when Inputting the string I want it to search for, it gives me a list of ten choices of versions of split to use.  I always select the ...Show All

• SQL Server SQL Server Agent Issues

  Hey everyone, I don't know if I am posting to the correct forum so please move this if there is a better forum for this. I am having issues through SQL Server that I believe may be related to the SQL Server 2000 User Mode Scheduler. First of all, I am running a single instance of SQL Server 2000 on a Quad Processor system. I was not around when the system was installed so I do not know how it was originally configured. I am getting a reoccurring error whenever I try to do anything with replication or scheduled jobs. Error 14258: cannot perform this operation while SQL server agent is starting. Try again later. I found the f ...Show All

• Visual Studio Tools for Office how to export/import data from/to excel files without using excel?

  am makeing a program that uses excel files but i don't want the customer to have to have execl to have the program working (i have excel) is there a way to do it wihout using excel components You could use the ServerDocument support in VSTO 2005 to extract/inject data into the spreadsheet. You can read more about ServerDocument at http://msdn2.microsoft.com/en-us/library(d=robot)/microsoft.visualstudio.tools.applications.runtime.serverdocument.aspx ...Show All

• Visual Studio Tools for Office Addin - TaskPane communication

  Hi, I have an addin that manage file events (open, new, close, ...) and have some menu items and a toolbar. Then each document of my solution have a VSTO customization that shows a Task Pane with a custom user control. I want to share an instance of a object between the user control and the addin but i didn't find the way to communicate both pieces of code (addin and taskpane). Anybody knows how I can access the instance of my addin from a VSTO dll or Anybody knows how I can access the TaskPane (document Actions) and then obtain the control list and access to the custom user control Thanks in advance! Juan ...Show All

• Visual Studio Tools for Office Issues inserting table inside bookmark

  I am trying to insert a table inside of a bookmark using VSTO, but creating a new table and passing in the bookmark.Range property completely overwrites the bookmark. When I recreate the bookmark around the table.Range the beginning of the bookmark is inside the first cell of the table and the end one is outside of the last cell. This in itself is not a major problem, but when I try to regenerate the document, I get an exception saying "The range cannot be deleted." Is there any way to either insert a table inside of a bookmark, or create a boookmark around a table in such a way that I can delete the range inside, including the ...Show All

• Visual Studio Team System Import Database Schema Keys not imported as expected

  Greetings, When I use Import Database Schema on an SQLServer 2000 database project (from an SQL Server 2000 database server) none of the keys, constraints or indexes are imported against the tables. They all appear to be there but are created as objects at the same level as the tables (i.e. under the Tables folder in the tree view) instead of in the appropriately named folders under each table. Everything looks good in Query Analyzer and even if I target SQL Server 2005 the import is the same. All these objects have a red exclamation mark but no errors appear in the error list. Also all my stored procedures and user functions ha ...Show All

• Windows Forms CallbackOnCollectedDelegate

  I get this error message after inserting into a SQL database, and changing some controls. The insert statement is located in a dll file. CallbackOnCollectedDelegate was detected Message: A callback was made on a garbage collected delegate of type 'System.Windows.Forms!System.Windows.Forms.NativeMethods+WndProc::Invoke'. This may cause application crashes, corruption and data loss. When passing delegates to unmanaged code, they must be kept alive by the managed application until it is guaranteed that they will never be called. This procedure was function as it should in Visual Studio 2005 Beta 2, but after installation of the final ...Show All

• SQL Server AS2005 Performance issues

  Hi, We are currently looking into AS2005 performances for one of our client. For some reason the 'cubes' are not giving us the performance we were expecting. Her is some info about our environment. Server: 2 * Dual 2.8 GHz with 4 GB of memory The fact table has around 30 millions of records for three years worth of sales history, and we have created 1 partition per year. We are using MOLAP with aggregation level at around 40%. The biggest dimension (Product) has 45 000 members, with 2 manual hierarchy and many attributes hierarchy. Attribute relationships are setup properly in every dimension. They are using OWC11 to access th ...Show All

• Windows Forms Exception deleting a row from DataGrid bound to an ArrayList

  I have a DataGrid bound to an ArrayList. When I delete a 'row' from the ArrayList the DataGrid throws an IndexOutOfRangeException exception. I constructed a very simple sample app that reproduces the problem (code below). This sample simply populates the grid from the array (see Form1 constructor). When you click the button it deletes the current row (see button1_click). At that point the exception is thrown. If anyone could suggest what I'm doing wrong I'd appreciate it. using System; using System.Drawing; using System.Collections; using System.ComponentModel; using System.Windows.Forms; using System.Data; namespace WindowsApplicat ...Show All

• Visual Studio Express Editions Unexpected end of file problem

  Im reading a tutorial at cplusplus.com and Ive got this code: #include <iostream> using namespace std; int main() { cout << "Hello world!"; return 0; } And so I go to build and then build solution because im pretty sure thats what you have to do before compiling and I got this: ------ Build started: Project: example2, Configuration: Debug Win32 ------ Compiling... example2.cpp .\example2.cpp(8) : fatal error C1010: unexpected end of file while looking for precompiled header. Did you forget to add '#include "stdafx.h"' to your source Build log was saved at "file://c:\Documents and Settings\Zac ...Show All

• .NET Development Creating a new table in SQL Server from ADO.NET DataTable

  I have some C# code which is dynamically creating a DataTable, using ADO.NET. I would like to be able to create a new table in an SQL Server database, matching the schema of my DataTable object. Is there any ADO.NET functionality that I can leverage to do this Or should I just go to plan B - construct and execute a CREATE TABLE command, using the properties of my DataTable to build the command - seems a bit clunky, with all the flash capability of ADO.NET. Thanks! Nick Tompson You can use SQL Server Management Objects to create tables in SQL Server using SMO. Here is an example I wrote particular ...Show All

• SQL Server Virtual Memory best practices with SQL 2005?

  After having my newly installed SQL 2005 instance lock-out all connections due to an Out of Memory error during a data transformation, I decided to start looking into memory config options. (Please consider I'm primarily a SQL developer who was selected as the DBA and therefore has to manage a Windows 2003 server as well.) In my case, the SQL memory settings looked fine but Windows 2003 Server had a fixed maximum on virtual memory of 2Gig on the system partition, and no virtual memory space on the data partition. I changed it to system managed for both partitions, and it seems to be working ok now when I pull over large datasets. It still ...Show All

• Visual Studio Team System What is a typical build process?

  hi all, I was wondering if anyone can define a typical build process using TeamBuild By this I mean, was it expected that only binaries are produced by a nightly build and then by using the Build Quality marker someone would then determine if a setup was made for that build / product. Alternatively do people expect to run a nightly build that will not only compile there solutions but product a installable package upon completion How many people need their binaries in the Drop share Regards Graham You can use Team Build in either way and we have designed it to suit both scenarios. Though I would expect t ...Show All

• SQL Server Single record per page

  Hi All, I am new to RS2000 but have made a report that i need to have 1 record shown per page. the paper i am going to print to is 254mm x 178mm. I cant seem to figure this one out so any help or advise is most welcome You can a grouping to your data region, use RowNumber() function to control how many records belong to each group, and add a pagebreak on the group. This page contains a sample of how to do this http://msdn2.microsoft.com/en-us/library/ms157328.aspx (scroll to the page breaks section). ...Show All

• Windows Forms a bug on ListBox?

  Hello, I have a DELL computer with a newly installed Windows XP with SP2 and all updates from WindowsUpdate, I have a very simple application: one TextBox , one ListBox and a Button, when I press the Button the text on the TextBox is added as an Item to the ListBox and in fact the Item is added to the ListBox but it doesn't show any text. Then I added another Button and a FileOpen Dialog, if I press the Add button the application behaves just like before but when I press the other button (it just shows the FileOpen dialog) then the text on the ListBox appear and the application starts working as it should be. I have tested this on 2 other di ...Show All