Richard, Thanks for your help. I get it. The thing is when I mouse over the new SessionOptions in this line in the C# program,

SessionOptions sessionOptions = new SessionOptions {
Protocol = Protocol.Sftp,

I see SessionOptions.SessionOptions(). With that in mind, when I do the C++ program, I convert that line to:

WinSCP::SessionOptions ^ sftpOptions = gcnew
WinSCP::SessionOptions::SessionOptions()
sftpOptions->Protocol = WinSCP::Protocol::Sftp;

As you can see, that (WinSCP::SessionOptions::SessionOptions()) is not a valid call. I change that to gcnew WinSCP::SessionOptions() and it works! Thanks.

I try that converter, but when I compile, there are problems. Thanks for the suggestion. :)

Please help! Even I am experienced in C++ and C#, I am new to C++/CLI. I have written a simple C# program using WinSCP library. I know how to do it in C# as there is already an example (http://winscp.net/eng/docs/library#csharp[^]) I try to convert but I do not get any success.

#using "WinSCPnet.dll"
using namespace System;

int main(array ^args)
{
try
{
Console::WriteLine("Staring...");

   WinSCP::SessionOptons ^ sftpSessionOptions = gcnew
      WinSCP::SessionOptions::SessionOptions (
         WinSCP::SessionOptions::Protocol = 
               WinSCP::Protocol::Sftp,
               ...
      );

...
}

But I get this error: Error c2061: syntax error: identifer '{ctor}' why? Please help in the translation. Yes I have made sure it compiles with '/clr' option.

Dear all, I find out Facebook does a good way of handling photos: 1) You can add photos to an album at any time. 2) You can rearrange the order at any time. 3) You can add/modify description to the album at any time. 4) You can add/modify description to each photo at any time. I want to have the same functionality available in my local computer. That means when I get into my album folder, maybe I click on a page or a program, it will allow me to do the above 4 things. Usually I arrange my photos like this: E drive + Photo 2012 + Photo 2013 +-- 2013-01-01 New Years Day +---+ Photo0107.jpg +---+ Photo0108.jpg +---+ Photo0109.jpg ... +-- 2013-02-14 Romantic Dinner +---+ CIMG0907.jpg +---+ CIMG0908.jpg +---+ CIMG0909.jpg ... Please note that I want to keep it simple. I think Facebook is a web thing. It uses Ajax to handle the photos. I don't want to install a web server in my computer. Please provide any pointer, whether there is on the shelf product, whether this is achievable using C#, or have to use ASP.NET / Ajax / php / etc. Thanks.

Well, I have already imported several tables. And the last one is a painful one. As for the last one, I still have to split that (old) one into five new tables. I think I am going to try to use the linked server approach. Thanks.

Dear all, I am new to the SSIS. I have many tables from old database (SQL 2000) and have to transfer to a new database (SQL 2012). I have created one SSIS project and have successfully shipped the data of one table already. I have also added a 'Execute SQL Task' to clean out table and reset identity column before the 'Data Flow Task'. Now what is the best way to import the rest? Import all tables in just one package? Or create one package for each table and create one package to 'call' all other package one by one? I think it is possible to create one package and use parameter to go over a pre-defined set of tables.

I hope this is the right place to ask. I am trying to create my first SSIS package in Visual Studio 2010. I see the Getting Started (SSIS) pane shows up. Later on, I have to restart, so I delete the original package first. I then create same one again. Now this time, in the Getting Started (SSIS) pane, there is an error message. An error has occured while loading Getting Started information. The remote server returned an error: (407) Proxy Authentication Required. * Yet at the same time, if I launch the web browser in Visual Studio, it can access the Internet. * Yes, I have to use proxy server to access Internet.

Mycroft, Thanks for your answer. And... have you actually read my question? I need a visual guide. If none exists, I would like to know which item I should choose from 'Displayed items' for changing column name.

I just wonder is there a visual guide in customizing the color coding. Problem I face with is that I need to change the color for column name. I have tried changing many items, but with no luck.

I hope that you are not saying developing those 'apps' like those appear in Apple AppStore or Android Market. Yes I have developed mobile applications. Development machine is a Windows 7 64 bit machine. VS2008. SQL Server also 2008. The mobile is Intermec with OS Windows Mobile 6.5. The mobile application is a mobile point of sale system. My client use the application to select item, enter quantity to sell, save the invoice and print it out. After doing a day's job, my client goes to processing office and upload data. Management can then process data for analysis. That is in.

Windows Mobile 6.5

I have a ListView. As there are several columns, for sure the horizontal scroll bar will appear. Once data is populated in ListView, the user may click on the horizontal bar, move to right or left, to see the rest of the information. Point is: Once the user finish moving the scroll bar, I want the focus to be set to a TextBox. How to do so? Edit: Platform is Windows 6.5

Then how do you know the horizontal scroll bar is displaying?

OK. I see your point. Let me go over the technical aspect. There is a sale system. There are about several hundreds of transactions in a day. The data is stored in a database. For each transaction, there is transaction header (usual stuff like customer id, transaction id, number of SKU involved, etc). There is also transaction detail (like item id, quantity of this item customer wants, etc). As you may see it, header to detail is a 1 to many relationship. One item we have to produce is an executable. This program will be run at end of each business day to output all transaction data to one XML file. This XML file is 3 level deep. It is similar to this:

<SalesRecord>
<VBAK SalesID="00001">
<AUART>SELL</AUART>
<SPART>GO</SPART>
<KUNNR>0000752134</KUNNR>
<BOTNK>2012071211085671S</BOTNK>
<VDATU>20120711</VDATU>
<VBAP item="10">
<MATNR>700911581</MATNR>
<KWMENG>3</KWMENG>
<UVKME>UC<UVKME>
</VBAP>
<VBAP item="20">
<MATNR>700912313</MATNR>
<KWMENG>4</KWMENG>
<UVKME>UC<UVKME>
</VBAP>
</VBAK>
<VBAK SalesID="00002">
...
</VBAK>
</SalesRecord>

It looks simple at first. Without much experience in processing this kind of XML, I think we could just let the program to write the XML out using something like XMLWriter(). This basically output a database table to XML format. Well in the database, the header and detail of each transaction are stored in two different tables! Somehow the person suppose to help me out use another way. He write a stored procedure to output 3 tables. In the program, he use DataAdapter to hold 3 tables (da.TableMappings.Add()). He then set mapping type of certain DataColumn (to be MappingType.Attribute or Mapping.Hidden). Afterward, use XMLDocument.LoadXML() to write out the XML file. Well there you have it.

Forum is good to ask questions, but once you post, you just do not when you will get an answer back. Google allow you to actively search for answer. At least you can tell your boss about that. :-D

Yes. Will learn this. Sounds useful.

No. I am the more senior guy.

Dear all, I need a bit of help here. I feel like being surpassed by junior staff in the company. One day the client has a requirement. Both me and the junior staff do not know how to do it. I rely more on books or talk to other coworkers for hint. The junior staff, however, are very good at using Google. After a bit of time, he is able to crawl / find a good solution. I would like to ask what you do when you face a technical challenge. If you use Google, how would you get to the answer fast? In other words, how are you able to know what the keywords are to type in Google? (Of course, if it is related to some specific terms, just type that in. But from time to time, it seems like I have to type in a bit more than that. And I think I am not good at this.) Example would be welcome.

Richard, I appreciate your input. I do find much similarity between what you write and what I have discovered. If I click on 'Deploy solution', the EXE goes to appropriate place in my device. How do I do the same for the config file?

Dear all, I have a Visual Studio 2008 project for a mobile device. In the project, I have a config.ini file. I want the config file deployed to the program directory (Say: DEVICE \ Program Files \ MyProject directory) in device when I deploy the solution. How to do so? I know there is post-build event that you can fill out, but how to fill out the rest? I need to now the last piece of puzzle as I know the first two: Copy $(TargetDir)\MyProject.exe ???