C#

FirstPrevNext

Re: an sql query error ? help please ... albCode30-May-06 2:58 albCode 30-May-06 2:58  OleDbDataAdapter adp10 = new OleDbDataAdapter("Select case,dailycase From caseinfo where case>='" + txtcasestart.Text + "', and case<='" + txtcasefinish.Text + "' and startdate >='" + txtstartdate.Text + "' and enddate <='" + txtenddate.Text + "'", conn); command prompt with fop problem Support12330-May-06 2:30 Support123 30-May-06 2:30  Hi all, Sorry Code project. I'm posting yet another question. I just cant get past this problem... I'm trying to get this command executed in cmd through C#. The command needs to be in Quotation marks like this when it gets sent to cmd... "c:\Program files\progressive projects\progress\reporttemplates\fop.bat" -xml "c:\program files\progressive projects\progress\reporttemplates\ClientRecordCard.xml" -xsl "c:\Program files\progressive projects\progress\reporttemplates\ClientRecordCardHairFo-pdf.xsl" -pdf "c:\Reports\ClientRecordCard.pdf" my code looks like this The TempPath And TempName TempPath = c:\program files\progressive projects\progress\reporttemplates TempName = ClientRecordCardHairFo-Pdf startInfo.Arguments = "/C " + "\"" + @Convert.ToString(TempPath) + "\\fop.bat" + "\"" + " -xml" + "\"" + @Convert.ToString(TempPath) + "\\ClientRecordCard.xml" + "\"" + " -xsl" + "\"" + @Convert.ToString(TempPath) + "\\" + @Convert.ToString(TempName) + ".xsl" + "\"" + " -pdf" + "\"" + @Convert.ToString(Salon.Library.GlobalVariables.Reports_Path) + "\\ClientRecordCard.pdf" + "\""; my logic tells me that it should work but i get an error saying "'c:\Program' not recognized as an internal or external command, operable program or batch file. He who laughs last... Re: command prompt with fop problem Support12330-May-06 2:31 Support123 30-May-06 2:31  it is as if the Quotes aren't in the right place in my code... not opening and closing on the right places if you understand what i mean. He who laughs last... Re: command prompt with fop problem NaNg1524130-May-06 2:37 NaNg15241 30-May-06 2:37  You are corecct!!! (Ding Ding Ding Ding Ding!!!) I fixed your qouts in my post here. Re: command prompt with fop problem NaNg1524130-May-06 2:36 NaNg15241 30-May-06 2:36  well as I see you don't leave spaces and don't put everything in it's place... (and there are alot of things that could be shorten...) try this: startInfo.Arguments = "\"" + @Convert.ToString(TempPath) + "\\fop.bat\" -xml \"" + @Convert.ToString(TempPath) + "\\ClientRecordCard.xml\" -xsl \"" + @Convert.ToString(TempPath) + "\\" + @Convert.ToString(TempName) + ".xsl\" -pdf \"" + @Convert.ToString(Salon.Library.GlobalVariables.Reports_Path) + "\\ClientRecordCard.pdf\""; this SHOULD work, but I don't promis you cuz I don't realy know what you after here. NaNg. Re: command prompt with fop problem Support12330-May-06 2:40 Support123 30-May-06 2:40  thank you, ill give it a go. He who laughs last... Re: command prompt with fop problem NaNg1524130-May-06 2:41 NaNg15241 30-May-06 2:41  let me know if it works. Re: command prompt with fop problem [modified] Support12330-May-06 2:53 Support123 30-May-06 2:53  hi, sorry, it didn't work public void shellControl2() { if(CustCd != "") { ProcessStartInfo startInfo = new ProcessStartInfo("cmd.exe"); // /c switch sends a command startInfo.Arguments = "/C " + "\"" + @Convert.ToString(TempPath) + "\\fop.bat\" -xml \"" + @Convert.ToString(TempPath) + "\\ClientRecordCard.xml\" -xsl \"" + @Convert.ToString(TempPath) + "\\" + @Convert.ToString(TempName) + ".xsl\" -pdf \"" + @Convert.ToString(Salon.Library.GlobalVariables.Reports_Path) + "\\ClientRecordCard.pdf\""; // redirect messages to this program startInfo.RedirectStandardError = true; startInfo.RedirectStandardOutput = true; //don't execute using shellexecute API startInfo.UseShellExecute = false; //Don't open command prompt window startInfo.CreateNoWindow = true; System.Diagnostics.Process p = System.Diagnostics.Process.Start(startInfo); string output = p.StandardOutput.ReadToEnd(); string error = p.StandardError.ReadToEnd(); p.WaitForExit(); if (output.Length != 0) {MessageBox.Show(Convert.ToString(output)); shellControl1.WriteText(output);} else if (error.Length != 0) {MessageBox.Show(Convert.ToString(error)); shellControl1.WriteText(error);} } } This is the code snippit i'm using to send a command to command prompt to run the fop batch file to create a pdf file from xml and xsl files. if you can help it would be great. i had it working fine when all the files were in "C:\Reports\" But we had to move it to the derectory where the user installs the program and only the pdf file(Result) would be stored in the "C:\Reports\" directory. He who laughs last... -- modified at 9:09 Tuesday 30th May, 2006 Re: command prompt with fop problem NaNg1524130-May-06 2:59 NaNg15241 30-May-06 2:59  Is this the code? you didn't change anything in here except putting all I've written to you in a variable that probably shows you a warning "command is never used"... put it in the Argument, it is still the last one that doesn't work. Re: command prompt with fop problem Support12330-May-06 3:13 Support123 30-May-06 3:13  the argument is your code. the command variable was my code but i've taken it out it gives the same error: "'C:\Program' is not recognized as an internal or external command, operable program or batch file." He who laughs last... Re: command prompt with fop problem [modified] NaNg1524130-May-06 3:12 NaNg15241 30-May-06 3:12  May I ask what is the /C? Re: command prompt with fop problem [modified] Support12330-May-06 3:15 Support123 30-May-06 3:15  the /c is the command line switch that lets command prompt know to run the command. That is how i understand it. He who laughs last... Re: command prompt with fop problem [modified] NaNg1524130-May-06 3:23 NaNg15241 30-May-06 3:23  Well maybe try without it? Maybe it's \c and not /c? Check some stuff out... Are you sure it's with a space after it? try also that. -- modified at 9:24 Tuesday 30th May, 2006 Re: command prompt with fop problem [modified] Support12330-May-06 3:33 Support123 30-May-06 3:33  thanks for your time and thanks for trying. Enjoy your day He who laughs last... Re: command prompt with fop problem [modified] NaNg1524130-May-06 3:34 NaNg15241 30-May-06 3:34  No problems... but does it work or not? Re: command prompt with fop problem [modified] Support12330-May-06 3:43 Support123 30-May-06 3:43  not yet but ill let you know as soon as i get it right. There is something id like to try. but im not prommising anything yet. hold your thums He who laughs last... Re: command prompt with fop problem [modified] Support12330-May-06 4:01 Support123 30-May-06 4:01  i've got it Thank you soooooooo much. All we needed was one more "\"" in the beginning of the code it should look like this: startInfo.Arguments = "/C" + "\"" + "\"" + @Convert.ToString(TempPath) + "\\fop.bat\" -xml \"" + @Convert.ToString(TempPath) + "\\ClientRecordCard.xml\" -xsl \"" + @Convert.ToString(TempPath) + "\\" + @Convert.ToString(TempName) + ".xsl\" -pdf \"" + @Convert.ToString(Salon.Library.GlobalVariables.Reports_Path) + "\\ClientRecordCard.pdf\""; The Bold part is the extra i was talking about. THANK YOU! i've been strugling with this since last week Monday. Now i can sleep soundly. He who laughs last... Re: command prompt with fop problem Dan Neely30-May-06 3:56 Dan Neely 30-May-06 3:56  When trying to construct a long string like this, it's much easier to troubleshoot if you start with a single substring and add mroe one at a time after checking the last one works as intented, by printing ot the console. Re: command prompt with fop problem Support12330-May-06 4:03 Support123 30-May-06 4:03  thanks for taking the time to try and help me. i've found the problem. He who laughs last... Unique ID NaNg1524130-May-06 2:29 NaNg15241 30-May-06 2:29  Hey So I have a XML with DataSet in it, in the DataSet I have 2 DataTables, in each DataTable I have a Unique ID, and I did to this row, auto-inc, and don't allow DBNull, and it's readonly. So when I try to do NewRow(), and add it without setting the ID column, it throws an Exception DataColumn 'ID' can't allow DBNull. So how can I do it as UNIQUE ID? do I need to allow DBNull? Thanks in advanced... NaNg. C#: Very important: do u know how to compare excel sheets formats? haiaw30-May-06 2:20 haiaw 30-May-06 2:20  Hi, I have hundrets of applications in excel from which I get data from c# - it works.. but some people changed the original pattern of the excel file (for example they merged some cells).. What to do? Is there eny posobility to compary only cells addresses? Please give me some code maybe - the case is extremally urgent and I didn't know that people would change these documents for their needs.... Re: C#: Very important: do u know how to compare excel sheets formats? haiaw30-May-06 4:05 haiaw 30-May-06 4:05  No ideas ? Re: C#: Very important: do u know how to compare excel sheets formats? Dan Neely30-May-06 4:26 Dan Neely 30-May-06 4:26  if the problem is with the user changing the excel file, any remediation will have to be in excel. You probably need to reissue the SSes so that a password is needed to make that sort of change. Re: C#: Very important: do u know how to compare excel sheets formats? haiaw30-May-06 9:28 haiaw 30-May-06 9:28  Eventually the only thing I can do is : someRange.MergeCells.ToString() - it returns true if cells are merged... I would have to check all cells in rows which have critical values and are merged in charasteristic way... I can't reissue them... Client want to have an info that this and this dcument hasn't passed the structural qualification... How to set focus on the form. analytiks30-May-06 2:09 analytiks 30-May-06 2:09  I have a windows form with a single textbox. I have a few event handlers for some form events. When the focus is set to the textbox, and the user hits the Esc key, focus should be set to the form. But this is not happening. private void textBox1_KeyPress(object sender, KeyPressEventArgs e) { if ((int)e.KeyChar == 27) { this.Focus(); } } No matter what I did, the focus did not move out of the textbox. How to set the focus back to the form again.? Please help.

Last Visit: 31-Dec-99 18:00     Last Update: 27-Apr-24 19:03 Refresh ᐊ Prev1...11266112671126811269112701127111272112731127411275 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

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