Reading tab delimited xls file into a dataset - C# Discussion Boards

saurabh sahay11-Jun-09 10:18

11-Jun-09 10:18

I guess you are correct..

soloforce12-Jun-09 1:48

soloforce

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

soloforce

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

soloforce

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

11-Jun-09 8:18

Use this PHP package[^]

ToolStripPanel Drawing

baehoo11-Jun-09 4:01

baehoo

11-Jun-09 4:01

I am trying to get a ToolStripPanel to have the same drawing style as the embedded ToolStrips, so that it looks like one continuous bar. I have the ToolStrips using the ToolStripProfessionalRenderer so that they are styled the same as the Windows Task Bar.

I have gotten close by creating a new Renderer derived from ToolStripProfessionalRenderer:

class CustomRenderer : ToolStripProfessionalRenderer
{
   protected override void OnRenderToolStripPanelBackground(ToolStripPanelRenderEventArgs e)
   {
      base.OnRenderToolStripPanelBackground(e);

      LinearGradientBrush lgb = new LinearGradientBrush(e.ToolStripPanel.ClientRectangle, this.ColorTable.ToolStripGradientBegin, this.ColorTable.ToolStripGradientEnd, LinearGradientMode.Vertical);
      e.Graphics.FillPath(lgb, e.ToolStripPanel.ClientRectangle);
   }
}

This creates the gradient look with the correct colors, but they do not match up quite right. It seems as if the gradient has a higher number of colors, so the spread is drawn out longer.

I have accounted for the border of the ToolStrips (which is not shown in this code), yet they still don't match up quite right.

Anyone know how to make this happen?

grid view updation

nagendra.vk11-Jun-09 3:17

nagendra.vk

11-Jun-09 3:17

hi everybody

i had a problem with gridview.

my grid view having 10 rows of data.

if i change one value in one row then the remaining rows will be updated.

how can i solve this. im explaining briefly here

name | credit | debit | balance
aaa | 1000 | 0 | 1000
aaa | 0 | 500 | 500

if i change 1000 value to 2000 then the balance vl be 1500

i m inserting those values from different forms by using triggers concept.

hope u help me in this

thnx in advance

kumar

Re: grid view updation

EliottA11-Jun-09 4:28

EliottA

11-Jun-09 4:28

I would use excel with macros to do something like this.

Check out the CodeProject forum Guidelines[^]

Re: grid view updation

saurabh sahay11-Jun-09 5:32