C# Discussion Boards - CodeProject

soloforce11-Jun-09 9:58

11-Jun-09 9:58

Ok I broke the code down and put it into a click event as follows

ProcessStartInfo ps = new ProcessStartInfo();
ps.CreateNoWindow = true;
ps.UseShellExecute = false;
ps.RedirectStandardError = true;
ps.FileName = "/C" + "\"\"C:\\Program Files\\RBS ThinTV\\PLINK.EXE\"";
ps.Arguments = (@"appliance@%ThinConnectedFrom%" + " " + "-pw appliance" + " " + "\"killall -q vlc; export DISPLAY= Blush | :O

.0; vlc --video-on-top --key-vol-up 100 rtsp://stfamtv0002/streama\"\"");
System.Diagnostics.Process proc = Process.Start(ps);

Not sure but now its getting a Win32Excepetion was unhanded error.... on this line System.Diagnostics.Process proc = Process.Start(ps);

The command string is perfect.... its really weird.

saurabh sahay11-Jun-09 10:09

11-Jun-09 10:09

"/C" + "\"\"C:\\Program Files\\RBS ThinTV\\PLINK.EXE\""; -----here what is "/C" ?

To check the validity of the code.
USe
ps.FileName = "Notepad";
ps.Arguments = "abc.txt"

Check whether notepad opens or not and then check your code accordingly.

Skymir11-Jun-09 10:16

Skymir

11-Jun-09 10:16

/C is a command line switch for cmd.exe.

I believe the filename string should be "C:\\Program Files\\RBS ThinTV\\PLINK.EXE"

The true man wants two things: danger and play. For that reason he wants woman, as the most dangerous plaything.

saurabh sahay11-Jun-09 10:18

11-Jun-09 10:18

I guess you are correct..

soloforce12-Jun-09 1:48

12-Jun-09 1:48

Ok I was able to verify that this test with notepad worked great so I think the error is in my arguments. The original argument that works in a command prompt is this.

"/C" + ("\"\"C:\\Program Files\\RBS ThinTV\\PLINK.EXE\"" + " " + "appliance@%ThinConnectedFrom%" + " " + "-pw appliance" + " " + "\"killall -q vlc; export DISPLAY= Blush | :O

.0; vlc --key-vol-up 100 rtsp://stfamtv0001/streama\"\"");

So at this point since we are not using a command prompt the "/C" is nulled which leaves us with

"\"\"C:\\Program Files\\RBS ThinTV\\PLINK.EXE\"" + " " + "appliance@%ThinConnectedFrom%" + " " + "-pw appliance" + " " + "\"killall -q vlc; export DISPLAY= Blush | :O

.0; vlc --key-vol-up 100 rtsp://stfamtv0001/streama\"\"");

Breaking this command string down we have

ps.FileName = "C:\\Program Files\\RBS ThinTV\\PLINK.EXE";

and

ps.Arguments = (@"appliance@%ThinConnectedFrom%" + " " + "-pw appliance" + " " + "\"killall -q vlc; export DISPLAY= Blush | :O

.0; vlc --video-on-top --key-vol-up 100 rtsp://stfamtv0002/streama\"\"");

The trick now i believe is int he syntax.

saurabh sahay12-Jun-09 1:57

12-Jun-09 1:57

what do u do soloforce?

soloforce12-Jun-09 2:07

12-Jun-09 2:07

Im a network engineer for a small company, but I enjoy programing keeps my mind sharp. I dont have much expereince in programing but I sure like it. Big Grin | :-D

saurabh sahay12-Jun-09 2:11

12-Jun-09 2:11

cool!!..good to know about you Smile | :)

soloforce12-Jun-09 2:41

12-Jun-09 2:41

Is there anyway i can really test the syntax to make sure is all correct?

saurabh sahay11-Jun-09 10:15

Reading tab delimited xls file into a dataset

11-Jun-09 10:15

Also do the following

ps.FileName = "/C" + "\"\"C:\\Program Files\\RBS ThinTV\\PLINK.EXE\"";
ps.Arguments = (@"appliance@%ThinConnectedFrom%" + " " + "-pw appliance" + " " + "\"killall -q vlc; export DISPLAY=.0; vlc --video-on-top --key-vol-up 100 rtsp://stfamtv0002/streama\"\"");

System.Console.WriteLine(ps.FileName + ps.Arguments);
and see the string displayed on the console is the right command string for cmd.exe or not?

gsdeepak11-Jun-09 4:29

gsdeepak

11-Jun-09 4:29

Hi,

I want to read an xls file and import data in dataset. This xls file is a system generated tab delimited file. Using below code I am getting "External table is not in the expected format" exception.

If I open the same file in excel and save it in correct excel format this piece of code works fine.

public static void ReadExcelFileData()
{
connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\\Test.xls;Extended
Properties='Excel 8.0;HDR=Yes;IMEX=1;FMT=TabDelimiter'";

// Establish Connection
_connExcel = new OleDbConnection(connectionString);
_cmdExcel = new OleDbCommand();
_cmdExcel.Connection = _connExcel;

try
{
//Accessing Excel Sheet
_connExcel.Open();

//Code to read excel file
}
catch (Exception ex)
{
throw ex;
}

}
}
}
}

I tried to modify the connectionstring as given below,But it also gave me "c:\Test.xls is not a valid path" error
connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\\Test.xls;Extended
Properties='text;HDR=Yes;IMEX=1;FMT=TabDelimiter'";

If anybody had faced such problem earlier, Please let me know the solution implemented by you.

Thanks & Regards,
Deepak

Re: Reading tab delimited xls file into a dataset

Dave Kreskowiak11-Jun-09 5:22

Dave Kreskowiak

11-Jun-09 5:22

There is no such thing as a "tab delimitted XLS" file. A true XLS file is a binary format only natively readable by Excel, which your code will not work on. But, since you've said that you can open the file in Excel and export the data as a tab delimitted CSV file and your code suddenly work on that, leads me to believe that your initial file is not what you think it is.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

Re: Reading tab delimited xls file into a dataset

moon_stick11-Jun-09 23:55

moon_stick

11-Jun-09 23:55

As the previous poster stated, it looks like you're trying to import an excel file, rather than a tab delimited file (Excel workbooks have an '.xls' suffix whereas tab delimited are '.txt' by default). You can still open the workbook in the way you've started but you need to change the connection string. Have a look here[^] for details of what value to use.

HTH

ETA: you might need this one[^] instead depending on what version of Excel you're using.

It definitely isn't definatley

Common encryption method in PHP and C#

SimpleData11-Jun-09 4:10

11-Jun-09 4:10

Hi I am trying to transfer a data securely over HTTP and my page that I am recieving the secure data from is written in PHP.

I need a secure encryption method to encrypt the data that I am sending. It better needs a key to encrypt and decrypt and it should be secure (Rijandel would be nice Smile | :)

)

Thanks.

Ennis Ray Lynch, Jr.11-Jun-09 4:16

Ennis Ray Lynch, Jr.

11-Jun-09 4:16

HTTPS would be the best way.

However, Google suggests that PHP does support various crypto fucntions so pick one that is also available in .NET.

Need custom software developed? I do C# development and consulting all over the United States.

A man said to the universe:
"Sir I exist!"
"However," replied the universe,
"The fact has not created in me
A sense of obligation."
--Stephen Crane

SimpleData11-Jun-09 4:37

11-Jun-09 4:37

Thank you for your answer.

I have searched a little about it on Google and I have read some articles that I've came across.

But none of them give me enough information about how secure is that encryption method is and wheather it exists both on C# and PHP.

I need an encryption method which decryptable only with a secret key and exists on both C# and PHP.

http://www.example-code.com/csharp/crypt2_blowfish_matchPhp.asp[^]

Vasudevan Deepak Kumar11-Jun-09 4:41

Vasudevan Deepak Kumar

11-Jun-09 4:41

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

The woods are lovely, dark and deep,
But I have promises to keep,
And miles to go before I sleep,
And miles to go before I sleep!

To be honest

Ennis Ray Lynch, Jr.11-Jun-09 4:43

Ennis Ray Lynch, Jr.

11-Jun-09 4:43

If you don't have a solid enough foundation in encryption to know the answer you should not be writing code that does encryption, from a security standpoint. It is very easy to make mistakes that can compromise the data. If it is truly important information hire a specialist to come in for one day to do it for you or your company. If the data is not that important just do whatever is simplest and don't worry about it.

As for checking whether is exists in both languages. The documentation for both languages provide that answer.

Re: To be honest

SimpleData11-Jun-09 4:47

11-Jun-09 4:47

Thank you for all your answers.

As you can see I don't have a solid foundation in encryption, the data I am trying to encrypt is not so vital and sensitive. But it should be encrypted. I can even use Base64 but it would be a little bit too easy I guess. Smile | :)

Re: To be honest

Dave Kreskowiak11-Jun-09 5:16

Dave Kreskowiak

11-Jun-09 5:16

Base64 is not encryption at all. It is an encoding to make sure 8-bit data can safely traverse a 7-bit path.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

Re: To be honest

saurabh sahay11-Jun-09 6:15

11-Jun-09 6:15

True

saurabh sahay11-Jun-09 6:14

11-Jun-09 6:14

Symmetric (Rijndael)[^] would indeed be nice

SimpleData11-Jun-09 6:51

11-Jun-09 6:51

Thank you, but what about PHP?

saurabh sahay11-Jun-09 8:18