Re: Pipping data to and from process - C# Discussion Boards

Re: how to pass Date format "mm/dd/yyyy " to Sql Stored procedure

Abhishek Sur1-Aug-09 21:18

1-Aug-09 21:18

use
Convert(DateTime, '12/31/1920', 101)

to convert properlt to datetime.

Here 101 means you are passing in MM/dd/yyyy format. Check http://msdn.microsoft.com/en-us/library/aa226054(SQL.80).aspx[^] for more. Rose | [Rose]

Abhishek Sur

My Latest Articles
Working with Excel using MDAC

Basics on LINQ and Lambda Expressions

Create .NET Templates

Re: how to pass Date format "mm/dd/yyyy " to Sql Stored procedure

Mycroft Holmes2-Aug-09 12:26

Mycroft Holmes

2-Aug-09 12:26

I hope you are NOT storing your date values as varchar in the database, you would be committing a major offence doing that.

I use paramerterised queries and pass a date type into the sp. If I have to pass a string of a date to a proc I use 106 = "dd MMM yyyy" there is NO ambiguity in that format.

Never underestimate the power of human stupidity
RAH

.NET Licenser?

devvvy1-Aug-09 14:10

devvvy

1-Aug-09 14:10

hello

Skater.NET offers software licensing/lock - http://rustemsoft.com/SkaterDoc/index.html?order.htm[^]

Price quite reasonable too - but:
(a) Licenser not free so I'm lasing with Skater to see if I can download an "Evaluation Copy"
(b) We do 64 bit, apparent Skater only support 32 bit version!?
(c) Any other suggestion?

Thanks

dev

Re: .NET Licenser?

Moreno Airoldi2-Aug-09 1:02

Moreno Airoldi

2-Aug-09 1:02

I don't have a specific third party licensing solution to recommend, but see my answer to your post in the thread about obfuscation: I hope it can give you some ideas.

2+2=5 for very large amounts of 2
(always loved that one hehe!)

Pipping data to and from process

BigBenDk1-Aug-09 12:44

BigBenDk

1-Aug-09 12:44

What I need to do is something like this.

DataCruncher.exe < input.bin > output.bin
It is an application that is called in the command prompt.
The input.bin file is piped in, and the result is outputed to output.bin. Works great.

Now instead of starting the app from a command prompt, I need to call it from a C# app.

ProcessStartInfo info = new ProcessStartInfo(location);
info.Arguments = BuildArgs();
info.RedirectStandardInput = true;
info.RedirectStandardOutput = true;
info.RedirectStandardError = true;
info.UseShellExecute = false;
            
_process = Process.Start(info);
_toApp = _process.StandardInput.BaseStream;
_fromApp = _process.StandardOutput.BaseStream;

The input is in binary format, and so is the output, so I used the basestream instead of the StreamReader.

My problem is that it is blocking when im reading from the standard output.

while (true)
{
  int read = _fromApp.Read(readbuffer, 0, readbuffer.Length); // <-- blocks

  if (read == 0)
    break;

  //Do something with the data.
}

It looks like it is blocking the stream until it has all the bytes to fill the readbuffer array.

Is there something I should be aware of when read/writting to a process?

Re: Pipping data to and from process

Luc Pattyn1-Aug-09 13:18

Luc Pattyn

1-Aug-09 13:18

Hi,

the way I understand it, but this could be wrong, I don't have a reference to this, is this:
- the process input and output are designed to be used for text;
- the data is transferred from one process to the other on a line by line basis, and each full line is somehow guaranteed to become available in one go.

So it's my guess you aren't getting any data because there aren't any newline characters in your binary data.

You could experiment with binary data that happens to contain some \r or \n or \r\n sequences, to see whether that splits it in smaller parts.

If so, seems like you should either abandon binary data, or choose another way of communicating (actual files, memory mapped files, ...)

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.

Re: Pipping data to and from process

BigBenDk1-Aug-09 15:13

BigBenDk

1-Aug-09 15:13

Hi
Thank you for your quick response.

I did some more work on it, and it looks like it was a threading issue.

If I read the out stream in a diferent thread, it does not block. Im not sure why, but it works.

Re: Pipping data to and from process

Luc Pattyn1-Aug-09 15:25

Luc Pattyn

1-Aug-09 15:25

Yeah, I couldn't tell the threading situation from the code you have shown; if you were performing the reads from the GUI thread (say in a button click handler), then all the GUI changes you ordered in there would not become effective until that handler (i.e. all reads) have finished (unless you added some extra calls such as Invalidate or Refresh).

If you do use a separate thread, that one can't touch any Controls; you would need Control.Invoke for that. This[^] explains it.

And finally, if your data were text, not binary, you could have used the OutputDataReceived event instead of a separate thread...

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.

Re: Pipping data to and from process

BigBenDk1-Aug-09 16:35

BigBenDk

1-Aug-09 16:35

Yeah, I look at the OutputDataReceived event, and for a moment considered doing reverse text encoding on the string - but that was an absolute last resort Big Grin | :-D

The threading is handled internally, and has no contact to the GUI.

You can se a sample of it at:
http://bendtsen.net/sample.txt[^]

run cmd.exe

rick05561-Aug-09 12:15

rick0556

1-Aug-09 12:15

Regards, I am trying to run cmd.exe from a button click event.
this is where I am starting off.
private void button1_Click(object sender, EventArgs e)

{
System.Diagnostics.Process.Start(@"CMD.exe","attrib C:\\save.txt +s +h");
}
when I click on button1 another instance of the program starts.
also the command window never opens.
am I lame?

Re: run cmd.exe

Abhijit Jana1-Aug-09 13:06

Abhijit Jana

1-Aug-09 13:06

rick0557 wrote:
private void button1_Click(object sender, EventArgs e)

{
System.Diagnostics.Process.Start(@"CMD.exe","attrib C:\\save.txt +s +h");
}

Try This,

private void button1_Click(object sender, EventArgs e)

{
System.Diagnostics.Process.Start(@"CMD.exe","/C attrib C:\\save.txt +s +h");
}

The only change I have made, is I have added "/C" with the Second Parameter.

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
View My Latest Article

Re: run cmd.exe

PIEBALDconsult1-Aug-09 13:26

PIEBALDconsult

1-Aug-09 13:26

How about System.IO.File.SetAttributes instead?

Re: run cmd.exe

Xmen Real 1-Aug-09 18:02

Xmen Real

1-Aug-09 18:02

nope...its for file attributes like, readonly, hidden...

TVMU^P[[IGIOQHG^JSH`A#@`RFJ\c^JPL>;"[,*/|+&WLEZGc`AFXc!L
%^]*IRXD#@GKCQ`R\^SF_WcHbORY87֦ʻ6ϣN8ȤBcRAV\Z^&SU~%CSWQ@#2
W_AD`EPABIKRDFVS)EVLQK)JKQUFK[M`UKs*$GwU#QDXBER@CBN%
R0~53%eYrd8mt^7Z6]iTF+(EWfJ9zaK-iTV.C\y<pjxsg-b$f4ia>

-----------------------------------------------
128 bit encrypted signature, crack if you can

Re: File Properties

rick05562-Aug-09 19:47

rick0556

2-Aug-09 19:47

Basicly what I am tring to do is change a files properties to super hidden.
(or system hidden) like the protected operating files. read about a way to do this manually
with the cmd.exe(comand line). one could probably build a batch file to do this. But the clean
way would be to do it with in the C# application that creates the file in the first place.
But Im not sure how to go about doing it. the "File.Atributes" only has the general type properties
.It has "hidden" and also "System". But what I need to do is tuck away a file that my program can access And be sure that it wont get deleted or changed.
Any Help would be greatly Appriceated.
Regards;
Rick

URL's

Gregory Bryant1-Aug-09 11:34

Gregory Bryant

1-Aug-09 11:34

I have a Program that displays a List in a textBox such as

Items
Items
Items

is there way that I can make the list in the textBox Click able so that it leads you to a Page depending on which item you click with out showing such as.

http://Site/items
http://Site/items

^_^ thanks for any help.

Re: URL's

Henry Minute1-Aug-09 11:59

Henry Minute

1-Aug-09 11:59

Does it have to be a TextBox?

This would be fairly trivial if you were using a listbox.

Henry Minute

Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”

Re: URL's

Gregory Bryant1-Aug-09 13:04

Gregory Bryant

1-Aug-09 13:04

ListBox would be Fine, still don't know how myself so help?

Re: URL's

Richard Andrew x641-Aug-09 14:14

Richard Andrew x64

1-Aug-09 14:14

Create a handler for the Click event, then check the SelectedItems.Item property to determine which item was clicked.

Re: URL's

Gregory Bryant1-Aug-09 15:56

Gregory Bryant

1-Aug-09 15:56

ok I have all the Code but exactly how to create a Click Handler

private void listBox1_Click(object sender, ??? e)
{
String item = listBox1.SelectedItem.ToString();

System.Diagnostics.Process.Start("http:site" + item);
}

what exactly should I have there?

Re: URL's

Richard Andrew x641-Aug-09 16:05

Richard Andrew x64

1-Aug-09 16:05

The easiest way to create the click handler is the following:

1. Highlight the listbox control
2. In the properties window, choose the "events" view ( the little lightning bolt )
3. Find the click event in the list of events
4. Double-click the click event in the list, and it will create a method stub for you to put your code into

Re: URL's

Gregory Bryant1-Aug-09 16:10

Gregory Bryant

1-Aug-09 16:10

yeah thanks I found that after manually figuring out how to :P

^_^ thanks for all the help.

Re: URL's

Gregory Bryant1-Aug-09 16:28

Gregory Bryant

1-Aug-09 16:28

now I have to ask once you set DataSource is there anyway to full release it?

Additional information: Items collection cannot be modified when the DataSource property is set.

Because the program has a reset feature and this is the error I get when trying to clear the data from the both the listBox and the original list<string>

Re: URL's

Richard Andrew x641-Aug-09 16:32

Richard Andrew x64

1-Aug-09 16:32

Hmm. You're trying to delete an item from the listbox and not from the database?

Re: URL's

Gregory Bryant1-Aug-09 16:38

Gregory Bryant

1-Aug-09 16:38

never mind I used an unbound list ^_^ thanks for your time though.

CrystalReport ReportSource not from a file path but a byte array. Possible?

Wendell.S1-Aug-09 11:10

Wendell.S

1-Aug-09 11:10

My problem seems to be simple, therefore I could not find an answer yet.

I have a windows forms application and the reports are being deployed and uploaded to a binary field in the database. The main idea is to run a query and retrieve this data, storing the report on a byte array. I don't want to compile reports inside the project nor reading them from the hard disk.

Is it possible to set the reportsource for the crystalreport viewer using this byte array or I REALLY have to define a file path on the hard disk? Actually, reading on a buffer, write the file on the disk and read it doesn't seem to be that clever... It'd be nice if we could just read the byte stream of the report template and directly set it as the report source.

Thanks in advance!

(C# / WindowsForms / Sql Server 2008)

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.