Re: creating report by using two dates - C# Discussion Boards

Dewald4-Apr-10 9:57

4-Apr-10 9:57

Is there a way to disable hot tracking on a ToolStripButton? In other words, when the mouse moves over the button I want it not to "light up" so to speak. TIA

the command for run program exe

KARFER4-Apr-10 7:39

KARFER

4-Apr-10 7:39

hi all

please what the code in C# to run program .exe

i mean i have button and i want when i press on the button any program exe i determined it run.

Regards
KARFER

-*-*-*-*-*-*-*-*-*
To Be Or Not To Be
(KARFER)
-*-*-*-*-*-*-*-*-*

Re: the command for run program exe

Not Active4-Apr-10 7:44

Not Active

4-Apr-10 7:44

http://msdn.microsoft.com/en-us/library/system.diagnostics.process.aspx[^]

I know the language. I've read a book. - _Madmatt

Re: the command for run program exe

Ice_Freez054-Apr-10 20:40

Ice_Freez05

4-Apr-10 20:40

Process.StartInfo.Filename = @"Directory\app_name.exe";
Process.Start();

Re: the command for run program exe

Not Active5-Apr-10 1:53

Not Active

5-Apr-10 1:53

12 hours later you give the same response. That's the way to boost your rep Roll eyes | :rolleyes:

How about next time you read the previous responses before posting.

I know the language. I've read a book. - _Madmatt

Re: the command for run program exe

EliottA5-Apr-10 2:14

EliottA

5-Apr-10 2:14

No no no, that would be unfathomable!
...
...
...12 hours later...
no no no, that would be crazy!

Check out the CodeProject forum Guidelines[^]
The original soapbox 1.0 is back![^]

creating report by using two dates

N_Hosseini4-Apr-10 7:11

N_Hosseini

4-Apr-10 7:11

Dear friends
I am a beginner in C#.NET programming. I have a problem to create a report.
I want to inter two dates in a form and when I push the button all data between these date shows on a report.
Please help me by sending all codes I need or by a sample
Thank you
Nasser Hosseini

Re: creating report by using two dates

Not Active4-Apr-10 7:46

Not Active

4-Apr-10 7:46

N_Hosseini wrote:
by sending all codes I need

No. We are not here to do the work for you.

We will help you along the way though. First tell us what type of report, SSRS, Crystal, something else? Where is the data coming from? You left it very vague and no answer can be given.

I know the language. I've read a book. - _Madmatt

Re: creating report by using two dates

N_Hosseini4-Apr-10 9:05

N_Hosseini

4-Apr-10 9:05

Thanks
I created a form with two textboxes and a button. I want to inter two dates in textboxes (beginning date and ending date) and click the button and a crystal report shows all goods, quantity of goods and sales price from sales table in the crystal report.
I use below codes
Please help me to complete them
Please check my codes and help me

private void btnshow_Click(object sender, EventArgs e)
{

string connectionString = "server=.;database=siman;trusted_connection=true";
SqlConnection connection = new SqlConnection(connectionString);
SqlCommand command = new SqlCommand("select goods, quantity, price from sales where saledate betwee "+txtbeginingdate.text+" and"+txtendingdate, connection);
command.CommandType = CommandType.Text;
SqlDataAdapter adapter = new SqlDataAdapter(command);
DataSet ds = new DataSet();
adapter.Fill(ds)
DataTable dt = new DataTable();
????????
connection.Open();
???????

connection.Close();
CrystalReport1 rptresult = new CrystalReport1();
?????
}

Re: creating report by using two dates

Not Active4-Apr-10 9:36

Not Active

4-Apr-10 9:36

First, please format any code you post using the pre tags (i.e. code block). You will get better results if you learn to follow the guidelines here.

N_Hosseini wrote:
SqlCommand command = new SqlCommand("select goods, quantity, price from sales where saledate betwee "+txtbeginingdate.text+" and"+txtendingdate, connection);

It is extremely dangerous to accept unformatted and filter input directly from user controls. Ever heard of SQL Injection Attack?

You need to learn how to use SqlDataAdapter[^]

DataTable dt = new DataTable();<br />
connection.Open();

These lines are useless.

I know the language. I've read a book. - _Madmatt

adding new tables to sql at runtime

teknolog1234-Apr-10 7:08

teknolog123

4-Apr-10 7:08

hi, is it possible to add a new table to sql from a form at runtime? If yes, would you please just give me a clue? I can manage the rest

Re: adding new tables to sql at runtime

Abhinav S4-Apr-10 7:32

Abhinav S

4-Apr-10 7:32

teknolog123 wrote:
hi, is it possible to add a new table to sql from a form at runtime? If yes, would you please just give me a clue? I can manage the rest

Here is the clue.
Smile | :)

Re: adding new tables to sql at runtime

teknolog1234-Apr-10 7:52

teknolog123

4-Apr-10 7:52

thanks

Cross-thread operation not valid: Control accessed from a thread other than the thread it was created on.

igalep1324-Apr-10 6:22

igalep132

4-Apr-10 6:22

hey all,

I've GUI application, which executes some logic application,
i do it with backgroundworker.
in the simple way (no operation progress update)it works fine, but when i'm trying to update an operation
progress, i get this exception...

my main idea : GUI with some user controls (main thread) then i execute another worker thread, while it works i'm listening to event it rise (each time when the upgrade point was reached), and when i'm catching this event in the main gui thread, i would like to update some label control...

I read about invoke etc... but it doesn't work with backgroundWorker.

any idea for solution will be appreciated Smile | :)

thanks

Re: Cross-thread operation not valid: Control accessed from a thread other than the thread it was created on.

Nicholas Butler4-Apr-10 6:27

Nicholas Butler

4-Apr-10 6:27

BackgroundWorker has progress reporting built in. Use this functionality and the ProgressChanged event will be fired on your UI thread for you.

Nick

Re: Cross-thread operation not valid: Control accessed from a thread other than the thread it was created on.

Abhinav S4-Apr-10 6:36

Abhinav S

4-Apr-10 6:36

This[^] should certainly help you out.

Me, I'm dishonest. And a dishonest man you can always trust to be dishonest.
Honestly. It's the honest ones you want to watch out for...

thanks, and one more Question

igalep1324-Apr-10 8:14

igalep132

4-Apr-10 8:14

thanks both of you, it really helped me !!!

one more question,
is there a method to implement a "pause" button for running thread ?
i guess when i use backgroundWorker.CancelAsync(); current working thread is die...
what i want is to make it pause, and on my request, to be continued from the place it was stopped..

Re: thanks, and one more Question

OriginalGriff4-Apr-10 8:33

OriginalGriff

4-Apr-10 8:33

BackgroundWorker does not have Thread.Suspend and Thread.Resume, so I suspect you will have to do it manually:
1) Set up a class level bool accessable to both the main and BackgroundWorker threads.
2) Set the bool true in the main thread when you want to pause the worker, and false when you want to resume it.
3) In the worker thread, monitor the bool on occasion, and while it it true, use the Sleep method for a suitable interval - half a second or so, depending on how fast you want it to start continuing.

Or better, replace the bool with a ManualResetEvent[^]

You should never use standby on an elephant. It always crashes when you lift the ears. - Mark Wallace

C/C++ (I dont see a huge difference between them, and the 'benefits' of C++ are questionable, who needs inheritance when you have copy and paste) - fat_boy

Re: thanks, and one more Question

igalep1324-Apr-10 9:45

igalep132

4-Apr-10 9:45

thanks for the answer,
I'll try it

Backslashes and forward slashes

Darrall4-Apr-10 6:14

Darrall

4-Apr-10 6:14

I am retrieving a filepath that I need in my program using a folderBrowserDialog. Can anyone tell me how to change all the back slashes to forward slashes?

Thanks

Darrall

Re: Backslashes and forward slashes

OriginalGriff4-Apr-10 6:23

OriginalGriff

4-Apr-10 6:23

string withForwardSlashes = withBackwardSlashes.Replace('\\', '/');

string withForwardSlashes = withBackwardSlashes.Replace("\\", "/");

Re: Backslashes and forward slashes

Darrall4-Apr-10 7:46

Darrall

4-Apr-10 7:46

I tried it exactly as you have it there and I get "Too many characters in character literal" and "No overload for method
'Replace' takes '1' arguments."

Any thoughts?

Thanks for your time.

Darrall

Re: Backslashes and forward slashes

OriginalGriff4-Apr-10 8:13

OriginalGriff

4-Apr-10 8:13

Works fine for me - could you post the code fragment exactly as you have it?

Re: Backslashes and forward slashes

Darrall4-Apr-10 8:55

Darrall

4-Apr-10 8:55

Here it is Smile | :)

private void button2_Click(object sender, EventArgs e)
       {
           string OldPathName;
           string NewPathName;

           if (folderBrowserDialog1.ShowDialog() == DialogResult.OK)
           {
               MessageBox.Show("MyFolder = " + folderBrowserDialog1.SelectedPath);
               textBox1.Text = folderBrowserDialog1.SelectedPath;

               OldPathName = NewPathName.Replace ('\','/');
           }

Re: Backslashes and forward slashes

FyreWyrm4-Apr-10 10:37

FyreWyrm

4-Apr-10 10:37

Backslash is an escape character. The '\' you entered is interpreted as ''. You can change that to @'\' or '\\' and it should work.

Don't blame me. I voted for Chuck Norris.

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