alumni's Q&A profile

• .NET Development SQLBULKCOPY DATE FORMAT PROBLEM

  Hi guys, I have come across an infuriating problem. I have an excel spreadsheet with formatted data. I also have a SQL Server table with 17 columns all nvarchar(255). I have been trying to use SQLBULKCOPY to import the data from the worksheet to the table. This worked with only limited success as it seems to ignore certain values and insert nulls. I converted my excel spreadsheet to a CSV file and tried the same. Now it imports most of the values but seems to be very VERY odd in its handling of what it perceives to be data in date format. In certain cases it ignores the value altogether and inserts NULL, in others it inserts the value but formats it into a datetime format instead. I don't want it to do this, I simply want it to save ...Show All

• .NET Development about XSLT..........

  How to create a dynamic .aspx using XSLT Your question can be read: how to generate aspx file from XSLT style sheet or how to write aspx that produces dynamic content with help of XSLT. In the first case see Chris sample above. In the second you may use XmlDataSource control ( http://msdn2.microsoft.com/en-us/library/system.web.ui.webcontrols.xmldatasource.aspx ) ...Show All

• Software Development for Windows Vista How to get Data Object (Properties) define in workflow from my Host?

  Hello, I have a problem for get information in my workflow instance. For example I had created in my workflow define a public property (Client) the question is: How can I do to get this value in run time with sql tracking I had added sqltrackingservice, sqlpersistenceservice and a create a profile with tracking profile designer. Please post your tracking profile. Samples for how to do this can be found here or here . ...Show All

• Visual Studio CRXI2 - VS 2005 - web page / Failed to open the connection. Failed to open the connection.

  I have successfully been able to display 2 similar reports . When I created the third report and developed a web page with the exact same code in the code-behind page, and every step in exact order as the first two web report pages , I get this.. Failed to open the connection. Failed to open the connection. C:\DOCUME~1\austism\LOCALS~1\Temp\HistoricalSampledateNCSOid {EE77DB46-0400-43D6-B0C6-5BBCC066188F}.rpt CrystalReportViewer - myCrystalReportViewer1 The following is in the code-behind after connection code is set up in the configure CrystalReports sub. HistoricalSampledateNCSOid = New ReportDocument() Dim reportPath As String = Server.MapPath( "HistoricalSampledateNCSOid.rpt" ) Hist ...Show All

• Visual Studio Tools for Office VSTO SE Interior.Color property issue

  I have an application developed using VSTO 2005; it works fine in Office 2003. now I downloaded the VSTO SE 2005 Beta runtime version and I ran the application on 2007 Microsoft Office System (on Win Vista) at first look it was great, it works; but I having an issue with one API property's Interior.Color (nameRange.Interior.Color), it fails when it is set from a other thread (not the main thread) e.g. start a thread to paint some cells while the application is showing a window with a progress bar. Any idea, comment to fix this issue/limitation/bug will be very welcome. Thanks, jr I don't know, but here is the way I do it. elementsRange.Interior.Color = 0xFFFFFF;//white elementsRange.Font.Color = 0x000000;/ ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Where in content pipeline does volume textures fail?

  Currently volume textures aren't supported in the Content Pipeline. So if I have a mesh that references a volume texture it will fail compiling. So, is it just a matter of writing a custom importer for volume dds files or is it all the way through the pipeline Will ContentManager.Load<Texture3d>(...) work if I just write the importer Say it is so...it is Christmas after all :-) So the best way as it is now to make all this automatic would be to do something like this, right 1. Create a custom importer that reads files with the extension ".ddsvolume" or similiar The custom importer would output a raw byte array which XNA handles transparently. Question: Is it possible to wor ...Show All

• Visual Basic VisualBasic... missing reference

  Hi, I recently converted my program to run under .NET Framework V2. However, a small number of users are having problems getting it to run. They are getting an error which says "Microsoft.VisualBasic .....system.io.filenotfoundexception". All of the users having problems have recently installed (ie within the last 2-3 weeks) V2 of the NET Framework. The vast majority who have experienced no problems have had V2 installed for some time now. Can anyone shed some light on this please. Thanks in advance for your help. NagaJim DO you know what line in your program is causeing the exception If not you can use the application. UnhandledException event to write out a log and find o ...Show All

• Visual C# How to create variables and configuration settings for C# Windows Project

  I need to store configuration details like Database Connection String, and other config details in a single location so that I can access it from any .cs file of the prj. How is it possible Thru some particular xml file or a text file PLZ reply asap as its urgent Sounds like this may be a task for the a User Settings action . The settings file, which is written in Xml, is used for such purposes like reading in a value, either for the user or the application .... See Using Settings in C# . / Using My.Settings in Visual Basic 2005 ...Show All

• Software Development for Windows Vista Editable Composites?

  Hiya I want to create a custom activity that replaces the parallel branch activity for my non-developer users. This activity inherits from SequenceActivity and contains a code activity, a parallel branch and a further code activity. The problem I have is that the children of my custom activity are read only so users (and I) can't drag activities onto the child parallel branches. How do I get around this I have done some further testing and it is just composite activities that are the problem. If I create a new custom activity that inherits from SequenceActivity and write no code, when i drag it onto the workflow it is editable. As soon as I put anything into the new custom activity it's locked. Anyone got any thoughts on whe ...Show All

• Software Development for Windows Vista AudioDG.exe - more info

  Hi I've got this annoying problem since the release of Win Vista Ultimate RTM (32bit). When i play audio,games/movies the Audiodg.exe uses 25-30% of the cpu every 30th second or so. This have an BIG effect on the sound, wich crackles every time audiodg uses more than 0% of the cpu. i have noticed that when i play audio in media player 11, the crackling sound is gone, even when audiodg loads the cpu.. This is not heping for games, and movies. These problems did not occour in the beta or rc1-2 releases of Vista Ultimate. Sorry about my bad english Tom-Erik Larsen ------------------------------ HP Pavilion dv-8000 1gb-ram Ati Xpress 200m 128mb (Aero capable) AMD Turion 64 VISTA Capable My v ...Show All

• Visual Basic Change color on value

  Here's what I have but it does not work, what am I doing wrong Select Case ProgressBar1.Value Case Is < 40 ProgressBar1.ForeColor = Color.Red Case Is < 60 ProgressBar1.ForeColor = Color.Aqua Case Is <= 94 ProgressBar1.ForeColor = Color.Blue Case 95 To 100 ProgressBar1.ForeColor = Color.Green End Select I don't believe you can change the 'block' color on a progress bar since they are some kind of graphic, or drawn internally. This is designed so that applications maintain a uniform appearance on the operating system. You would have to draw your own progress bar if you want it to change color. ...Show All

• SQL Server Getting data time in expression

  I would like to get this date+3days and show it on a text-box. Can i do it on the Text-box expression what should i write or i have to use custom code =DateAdd("m", 3, DateTime.Now()) Should be "d" not m ...Show All

• SQL Server SSIS System Variable ErrorDescription (@[System::ErrorDescription])

  Hello, Does anybody could help me to fixe this query, inside SQL Task to handle OnError event. The function DT_TEXT does not work with this query and I need to convert the Error Message so that the french caracter ' can be accepted inside the Insert Query. Here is my query : "INSERT INTO LOG(EventType, PackageName, TaskName, EventCode, EventDescription, PackageDuration, ContainerDuration,InsertCount, Host) VALUES ('OnError', ' " + @[System::PackageName] + "', '"+ @[System::SourceName] + "', 0, '"+ (DT_TEXT) @[System::ErrorDescription] + "', 0, 0, 0, 'Toto' )" The error message is capted inside the Insert Query, for example, the value of the variable ErrorDescription is : 'Erreur dans l ' insertion ...Show All

• Visual C# Help required to solve circular dependency problem in vb2005

  I am working on an application design that requires two projects to cross reference each other. I found the excellent Formfactory / Interface example/solution (listed below) on this forum. Unfortunately I am not C# literate. I understand and appreciate the method, but my attempt to convert it into vb2005.net has been defeated by the C# syntax. I would greatly appreciate someone (multilingual) providing a translation into vb2005.net Here is the C# solution: The pattern to solve this is abstract class factory , together with the singleton pattern. What you have to do is the make a classfactory for the forms . This classfactory you can place in your main program, which anyway MUST reference your assemblies, thus it w ...Show All

• SQL Server Exporting a table to Excel using bcl utility (Newbie)

  I am trying to learn SQL 2005 Express and I am having a problem exporting (if that is the correct word) a table to Excel. I have created a view in the Northwind database called MyCustomerView and want to practice working with the table. From the command prompt: bcp Northwind.dbo.MyCustomerView out MCV.xls -S -T I then get the error message: c :\> bcp Northwind.dbo.MyCustomerView out MCV.xls -S -T SQLState = 08001, NativeError = 10061 Error = [Microsoft][SQL Native Client]TCP Provider: No connection could be made because the target machine actively refused it. SQLState = HYT00, NativeError = 0 Error = [Microsoft][SQL Native Client]Login timeout expired SQLState = 08001, NativeError = 10061 E ...Show All