ModelMan's Q&A profile

• Visual Studio Tools for Office Excel asks, if you want to re-open the sheet again at startup

  Hi, I am using framework1.1 and vsto2003 Sometimes, well.....most of the times when I start up the excel aplication, first it starts up and loads all the data and everything and display everything properly. Once it loads every thing, it immediately shows this message myapplication.xls is already open. Reopoening will cause any changes you made to be discarded. Do you want to reopen myapplication.xls Does anyone have any idea why is that and how can I stop this from happening Thanks, In my application , I simply grab values from the database, do some processing and display them on 3 worksheets. I have a timer that runs every 5 minutes and repeats the process. In my solution there are 2 projects. One pr ...Show All

• SQL Server execute sql task resultset

  hi all, in my execute sql task, i have a try catch statement to catch error code if there's an error... begin try insert into person.contact (contactid) values ('1') end try begin catch select @@error as ErrorCode end catch this ErrorCode will be mapped to a user variable. my problem is the value for ResultSet. in order to assign ErrorCode to the variable, i have to set the ResultSet value to Single row, but if this task does not fail, i need to set ResultSet value to None in order for it to run successfully. How do i go about solving this problem Please help. thanks! It needs to be set to single row... Are you saying you tested it with single row and my case statement and it sti ...Show All

• Visual Studio Express Editions How do I know if the text in a text file has changed? How do I program Save and Save As?

  I am trying to create a notepad-like program. I noticed that on Notepad, when I go to File | New, Open, or Exit, the program displays a message box saying that the text has changed. I was wondering how I make the program recognize the text has changed and put it into a MsgBox Another problem... I know how to program Save As, but how do I program Save Finally, Notepad is able to display in the title bar just the filename, and I was wondering how to do that. For example, I want it to say "Sample - Notepad", not "C:\Documents and Settings\Administrator\Desktop\Sample.txt". Any suggestions Thanks a lot. Declare a public boolean outside of a sub. ' example Public textchged as boolean = False In the rich ...Show All

• Visual Studio Express Editions Ugh....Driving Me nuts....

  I am in the middle of writing a prog that takes a file within a directory on a HD renames it to the directories name and then places the newly named file on the root of that HD. Here is the code. and I am not getting it.....I would really appreciate your help. Thanks Imports System Imports System.io Imports System.IO.DirectoryInfo Public Class Form1 Private Sub Button1_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim dlg As New FolderBrowserDialog Dim FileNamesSelected() As String Dim SelectedFolder As String 'Dim FileFound As String SelectedFolder = Me .FolderBrowserDialog1.SelectedPath FileNamesSelected = System ...Show All

• Windows Forms Data entry box and site navigation

  hello, I'm wondering if it is possible to have a dialog box that allows data entry when you open the document; the data entered would populate parts of the form... also, would like to have navigation for the form but I understand this doesn't work in Word forms (Word 2003). Is there any way around this (such as having this available with the above mentioned entry dialog), short of having to do a digital software certificate I Just guess your requirement and I think maybe working with office core using InterOP can help you. follow an easy example for you: http://www.codeproject.com/useritems/C__Word_2003_Mailmerg.asp ...Show All

• SQL Server TNS Alias name changed

  Maybe somebody has asked this question, but I could not find it.... I used SSIS to transfer data from Oracle database to SQL Server 2005 (with Microsoft OLE DB Provider for Oracle). It worked fine with the TNS alias name said oracle1 . Then I changed the TNS alias name to oracle2 . I could connect to Oracle database with oracle2 using Oracle's tool. But SSIS could not find (or solve) oracle2 , if I changed the name back to oracle1 in SSIS, then SSIS worked. Any idea Thanks! SSIS worked now. Sounds like SSIS would not take the new TNS name immediately. Any idea that how long the new name will be effective in SSIS Anyway, it workd. Thanks to you, DarrenSQLIS. ...Show All

• SQL Server .Net DataProvider for SAP Timeout

  I am using the .Net DataProvider for SAP. When importing data I receive an error, when calling sap functions via exec. The errors vary (e.g. Error 0xc0047062: Data Flow Task: Microsoft.Adapter.SAP.SAPManagedProviderException: System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.) On the sap-side the function runs, but it takes a few minutes. I can ask the sap-bw team to speed up their performance, but this is political. The sql-timeout parameter is not working with this datareader. Have you any proposal that solves the problem. Thanks Hello Groth, you may also have a look at this tool: www.xtract-is.com It works definitly faster than the ...Show All

• Visual Studio Team System Branching Approach Inconjunction With Project References Approach - What is Recommneded?

  Hello, My team is implementing TFS with good success. We have a desired approach on how to handle our branching structure and how to organize our project references. The problem is how to integrate these two concepts into one simple set-up. Let me describe our desired approach to both areas and then discuss where the friction point occurs. Approach to Branching Based on previous experience and open literature, we want to take a “Branch by Purpose” approach to branching. There is an excellent blog on this subject that also contains additional links to review on branching, particularly from a TFS viewpoint ( http://blogs.vertigosoftware.com/teamsystem/archive/2006/03/30/2484.aspx ). Within a given TFS Proj ...Show All

• .NET Development SQLDataAdapter.Update throws OutOfMemoryException

  Hmmm... Any ideas what to go after here TIA for any hints. Perhaps using a different value for this da.UpdateBatchSize = 0 Here is the full exception stack dump: Exception of type 'System.OutOfMemoryException' was thrown. at System.String.GetStringForStringBuilder(String value, Int32 startIndex, Int32 length, Int32 capacity) at System.Text.StringBuilder.GetNewString(String currentString, Int32 requiredLength) at System.Text.StringBuilder.Append(String value) at System.Data.Common.DbCommandBuilder.BuildWhereClause(DataTableMapping mappings, DataRow dataRow, StringBuilder builder, DbCommand command, Int32 parameterCount, Boolean isUpdate) at System.Data.Common.DbCommandBuilder.BuildUpdateCommand(Da ...Show All

• Visual C# Where can I buy Visual C# 2005 Standard Edition in Australia?

  Anyone, I an only 15 years old but I regard myself as a beginner in C# programming. My dad bought me a copy of Visual C# 2003 and I have been reading nothing but good things about Visual C# 2005 but I can't buy it! I live in Australia and it seems that Microsoft in their wisdom do not sell this product but only the full Visual Studio 2005 that I have no hope of affording at all. My first question is this - why can't I buy Visual C# 2005 in Australia I would also like to ask another question. Why can't I print the contents of a RichTextBox in Visual C# 2003 There is a solution on the knowledgebase that I simply can't follow. Maybe nobody else can because third party providors produce PrintAdapters, PrintForm and PrintControl see ...Show All

• Visual C++ regex implementation

  I can't seem to get regular expressions to work in visual c++ 2005 express edition. I'm parsing a .h file for #define, and the below code errors: System::Text::RegularExpressions::Regex^ blockDefine = gcnew System::Text::RegularExpressions::Regex("define\bEE_BLOCK_(\w*)\b"); System::Windows::Forms::MessageBox::Show(blockDefine->IsMatch("#define EE_BLOCK_VERSION 0").ToString()); The error is: .\fileio.cpp(23) : warning C4129: 'w' : unrecognized character escape sequence I don't understand why this isn't working. Ovbiously it's trying to escape the \w and it doesn't like that...but how do I fix it The treatment of metacharacters is documented in MSDN under http://msdn2.mi ...Show All

• Smart Device Development Making existing MFC application DPI aware...

  Hi Guys! (These are probably trivial questions for the MFC Pros, but after searching 2hours in the MSDN library i thought it is worth to post a few questions ;)) I am having some problems making an existing MFC application DPI aware. --- Question 1: I am using SHGetUIMetrics to get the current system font size and create an "application font" in InitInstances of the application. I then use a public function to get the handle to the font in the various classes and dialogues that need to be DPI aware. Well not sure if this is really safe in types of encapsulation, but it's working. So now the guide says i have to register the metric changed message: WM_SH_UIMETRIC_CHANGE = RegisterWindowMessage(SH_UIMETRIC_CHANGE); and handle it i ...Show All

• Visual Studio Express Editions Append Table to Access MDB

  I try the followin code to add a new table to a Access Mdb, but the last line (when i append the table to the catolog) indicate a error saying that the type is invalid. What do i wrong Dim cn As New ADODB.Connection Dim cat As New ADOX.Catalog Dim tbl As New ADOX.Table Dim col As New ADOX.Column Dim oKey As ADOX.Key cn.Open( "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\CSysTmp\NewMDB.mdb" ) cat.ActiveConnection = cn tbl.Name = "Test" tbl.ParentCatalog = cat col = New ADOX.Column col.Name = "Id" col.Type = ADOX.DataTypeEnum.adInteger tbl.Columns.Append(col) col = New ADOX.Column col.Name = "Name" col.Type = ADOX.DataTypeEnum.adVarChar col. ...Show All

• .NET Development FTPWebRequest & SSL

  Hi, I'm trying to do FTP over SSL (Explicit). When i try to access the Response like this response = (FtpWebResponse)request.GetResponse(); I'm getting the error Remote certificate was verified as invalid by the user. I'm able to login to the same ftp server & list the directory without using the SSL but when I use SSL i'm getting the error. I'm adding part of the tracing log file containing the error. Can anyone tell me how to fix the error Thanks Mohan System.Net Information: 0 : [2512] SecureChannel#50510248 - Remote certificate has errors: System.Net Information: 0 : [2512] SecureChannel#50510248 - A certificate chain processed correctly, but terminated in a root certificate which is not trusted by the trust provid ...Show All

• Visual Studio Tools for Office DISP_E_TYPEMISMATCH Error when using FIND in excel

  I'm trying to open an existing excel file, search for some text, write some text to the document, and save the document. Here is my code: Microsoft.Office.Interop.Excel.Application xlApp = new Microsoft.Office.Interop.Excel.Application(); xlApp.Visible = false; String DocumentLink = "whatever.xls"; if (!System.IO.File.Exists(@DocumentLink)) { Console.Write("\t*DOES NOT EXIST*"); } else { Workbook wb = xlApp.Workbooks.Add(@DocumentLink); Worksheet ws = (Worksheet)wb.Worksheets[1]; RangeOfText = ws.get_Range("A1", "I30"); found = null; found = RangeOfText.Find("TextToFind", xlApp.ActiveCell, XlFindLookIn.xlValues, XlLookAt.xlPart, XlSearchOrder.xlByRows, XlSearc ...Show All