pckaw600's Q&A profile

• .NET Development Conversion problem

  Hi! I need to take a text string from a tab-delimited text file referring to a date and load it into a database (SQL 2005) as datatype datetime. I parse a tab-delimited text file thusly: [CODE] AccountBalance ab = new AccountBalance(); ab.buildType1DataTable(); // METHOD THAT BUILDS THE DATATABLE string[] type1Row = line.Split(new string[] { "\t" }, StringSplitOptions.None); ab.tbl.Rows.Add(type1Row); [/CODE] For each of the columns of the datatable, I define them each like this: [CODE] DataColumn StartDate = new DataColumn(); StartDate.ColumnName = "StartDate"; tbl.Columns.Add(StartDate); ... [/CODE] How can I convert the column with strings that must go into a database column expecting datetime The date string is ...Show All

• Visual C++ String Table?

  Hello, I have created an empty project, and managed to write some code that will create an empty window... When I was experimenting, I thought that keeping ALL the text within the program in a string table (as a resource)... Would that be good Is that too inefficient Anyways this this the code for the window: =========code============== #include <afxwin.h> class MFC_Tutorial_Window :public CFrameWnd { public: MFC_Tutorial_Window() { Create(NULL,_T("Test Window")); } }; class MyApp :public CWinApp { MFC_Tutorial_Window *wnd; public: BOOL InitInstance() { wnd = new MFC_Tutorial_Window(); m_pMainWnd = wnd; m_pMainWnd->ShowWindow(SW_SHOW); return TRUE; } }; MyApp theApp ; =========code========== ...Show All

• .NET Development Exception when my web-site talks to a web-service

  Hi all Some of our users are getting the exception below when trying to access page that communicates with a web-service on another network. Here's the deployment: Website on a server in our DMZ, Web service on a server on our internal network. The exception is posted below. I've spoken to our comms team about the exception and they tell me that some packets were dropped due to the DMZ server trying to communicate with the internal server via a connection that has been dropped (due to the firewall). Here System.Web.HttpUnhandledException: Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Net.WebExcep ...Show All

• Visual C++ Compiler Error C3213 in C++/CLI

  Compiler error C3213 says: "A type that will be visible from an assembly must use publicly visible base classes." Can anyone explain to me why this is so If another assembly accesses my publicly visible derived class, why must my entire base class hierarchy be publicly visible in .NET The issue for me is not so much that the base class can not be private but, because the base class just exists to be derived from, I only want the derived class to show up in the IDE's Toolbox as a component when tha assembly is added to the Toolbox. Normally if the base class were private, then naturally it would not be included in the Toolbox as a component. However now that I must make the base class public ...Show All

• SQL Server Can't I dynamically read from any file? - Connection Manager does not exist

  I have a Parent package and a child package. I have hard coded the value for the User::FilePath variable in the parent package. I am mapping this variable to the value of the same variable in the Child Package. I created a directory and sql file: "C:\temp\sqlb.sql". I have verified that the path variable value is passed to the child package by using a Script task with a messgbox call. How do I define an execute sql task to execute sql file: @[User::FilePath] & "sqlb.sql". I'm using this expression for the SqlStatementSource property. I have entered the OLEDB server information and specified the SQLSourceType = fileconnection. However I get the error: [Execute SQL Task] Error: Connection manager &qu ...Show All

• Visual Studio Just-In Time debugger problems - win32 exception-popups

  Hi I have VS 2005 installed since a few weeks, and first it worked smoothly but now strange things are happening. Very often either firefox (1.5.0.6) or Outlook or IE crashes and the just in time debugger throws a win32 exception and wants to debug, and it pops up exceptions until I reboot. Then it starts again. I've searched for this in this forum but I didn't find any solution. I have disable script debugging (IE) and Disable script debugging (Other)" checked. I do have to develop in .Net 2.0, and cant't go back to 1.x What to do I'm getting crazy about this. Do I have to reinstall the whole system or what Any of you who had this problem and found a solution Hi, which operating system that ...Show All

• Visual C++ Exception handling showing undefined behaviour. Help !!!

  Question #1 : The following code crashes in Visual C++ compiler. It fails in the expression _BLOCK_TYPE_IS_VALID(). It means that, it is deleting a bad pointer. When I give a copy constructor, it works fine but the control does not even go in the copy constructor. Why is it showing this behaviour Question #2 : If I throw a local primitive type like an int, the address of that variable matches in the catch block if I am catching by reference. But for objects, the address for the variable in the catch block changes. Why #include <iostream> using namespace std ; class Exception { char * m_pszError ; public : Exception ( const char * p ) { cout << "Exception::E ...Show All

• Visual Studio Tools for Office Probem with "CommandBars.Add" command

  Hi, I have a very strange problem and could not find solution yet. I have a VS.2005 VSTO project for Excel Add-In. If I have the following piece of code excel shows two messages as expected. //*************************************************************************************************** public void OnConnection( object application, Extensibility. ext_ConnectMode connectMode, object addInInst, ref System. Array custom) { try { applicationObject = application; addInInstance = addInInst; MessageBox .Show( "test___1" ); excelApp = (Microsoft.Office.Interop.Excel. Application )(application); MessageBox .Show( "test___2" ); } catch { throw ; } } ...Show All

• SQL Server Excel file stays in use after I import it using a SSIS package

  Hello everybody... I have a very simple SSIS package that loop throught the worksheets of an Excel file and insert the data into a SQL server 2005 table. The SSIS is very simple and works fine the problem is that after the Package executes if I double click on the Excel file imported I have the message that the file is in use. I think that the Excel connection manager of the package doesn't release the Excel resourse but this is only a guess.. Do am I right If yes how can I release the resource Thank you very much Marina! Have a look in Task Manager and see if there is a process called dtexec.exe or dtsdebughost.exe running after execution. If so its possible that the package is ...Show All

• Visual Studio Express Editions Skinning vb forms

  is it possible to apply skins in vb forms by using this express software if so, how can anyone help me.. please.. thanks... ...Show All

• Software Development for Windows Vista Vista secuity disallows hyperlinks in Outlook 2007 Beta 2

  As my subject line indicates, I am using Outlook 2007 Beta 2. It ran very smothly under WinXp Pro SP2. Under Vista (build 5600) however, I am having a bugger of a time with hyperlinks in emails. When I click a link in an email, I get an error that "The operation has been cancelled due ro restrictions in effect on this machine. Please contact your system administrator" Since I am my Sys Admin, I am in a bit of a quandry. Any ideas of how to lower this part of the security level I am hanged if I can figure it out. Thanks in advance Jeff Kincaid try this: http://www.cnblogs.com/CrazyCoder/archive/2006/09/06/496187.html good luck ...Show All

• Visual C++ Should this sample run without a crash?

  Hi, today I was testing some things and came across with something like this: #include <iostream> using namespace std; class A { public: void print() { cout << "test"; } }; int main() { A* a = 0; a->print(); return 0; } And I was a bit surprised when it ran without any problems both in debug and release in VS 2005. Well, I realize that since the code doesn't depend on the class, it may seem armless to run it but.. is this right Should it run in cases like this Is this standard or is it something that the VS team choosed to do since the code doesn't depend on the class I didn't check the standard yet to check if it says something about these cases, and I have to admit that sometimes it's hard for ...Show All

• SQL Server Reference an aggregate in where clause

  I have two tables that are joined on 1 column. I want to update one table using an aggregate from the other table. I could just update all rows even if the aggregate value has not changed, but I wondered if there was a way to only update the records where the aggregate has changed. I tried this code but assigning the name m to aggreate gives an error UPDATE t2 SET t2.ColumnB = SELECT MAX(ColumnB) AS m From Table t1 JOIN t2 ON t1.ColumnA = t2.ColumnA WHERE t2.ColumnB <> m GROUP BY t1.ColumnA Use a subquery - replace the 0 in the isnull calls with blank strings if your ColumnB is character data. UPDATE Table2 SET ColumnB = t1.MaxB FROM Table2 t2 INNER JOIN (SELECT ColumnA, MAX(ColumnB) AS MaxB FROM Table1 ...Show All

• Visual Studio Express Editions Publishing

  Hi, It seems very strange for me. I posted 2 times and they have all gone and this is third time. I want to deploy my application program on CD-ROMs. There is Publish function in VS C# 2005 Express Edittion. It creats a setup.exe and there are 4 steps in the program. 1. Checking .NET Framework 2.0 installed or not 2. Installing it if needed 3. Install my application 4. Running it. I want a different way. After the second steps above, Is there any way the setup.exe run my application from CD-ROM without installing it to computers. I can put my application into CD-Rom to burn. Thanks, the thread has been moved to the correct forum initially.... http://forums.microsoft.com/MSDN/ShowForum.as ...Show All

• Internet Explorer Development Float Margin Goes Away in IE7

  I am having a problem in which a page I developed breaks under IE7 only. Try it: Go to http://www.gordon.edu/alumni Click on the alumni office email at the bottom of the page After the window opens, move your mouse You will see that the entire body in the middle column has moved way over to the left, beneath the first column. The link has an image in it (the @ symbol... our way of blocking spiders from stealing our email addresses) The problem only occurs when the user clicks on a link containing an image . Text links do not cause this problem. The middle column is a float that is defined like this: #Column2 {   float: left;   width: 376px;   margin: 0 14px 2em 199px; */  & ...Show All