C# Discussion Boards - CodeProject

Dave Kreskowiak6-Jun-13 10:08

6-Jun-13 10:08

Well, that's not going to happen in Windows Forms code. Those pixels are owned by the control that is painting the video image and anything you draw on the control will be overwritten over and over again at the frame rate your video is being drawn at.

You'd have to use something like AForge.NET or OpenCVSharp to do an overlay. Google for them.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

Calling RPG program or Query using odbc connection to AS400

Kiko.176-Jun-13 1:42

Kiko.17

6-Jun-13 1:42

Hi guys,

I just want to know which would be faster or reliable between calling RPG program and using ODBC to query from AS400.?

Any comments and suggestions would be much appriciated.

Thanks so much

Re: Calling RPG program or Query using odbc connection to AS400

Keith Barrow6-Jun-13 2:36

Keith Barrow

6-Jun-13 2:36

Which to use? It depends.

ODBC is probably simpler (and directly faster), but you bypass any business rules the RPG provides. So this is the first thing you need to decide for your circumstances. For example a well-established AS400 is pretty solid and the buisiness rules have probably evolved to a strong position, so you don't want to re-work those (favour calling RPG). Of course if you are looking to deprecate the RPG code base you would want to migrate it to the .net side (this favours ODBC, but will more than likely cause a lot of work).

To confuse the mix, further, newer versions of RPG are capable of exposing SOAP (and consuming) web services, you should consider those. My memory of these things is hazy (and we used a screenscraper in the end). I think you can also get biztalk to play with the iSeries, this provides a pathway for communication in more complex scenarios.

“Education is not the piling on of learning, information, data, facts, skills, or abilities - that's training or instruction - but is rather making visible what is hidden as a seed”
“One of the greatest problems of our time is that many are schooled but few are educated”

Sir Thomas More (1478 – 1535)

Re: Calling RPG program or Query using odbc connection to AS400

Kiko.176-Jun-13 16:32

Kiko.17

6-Jun-13 16:32

Thanks much Keith Smile | :)

You give me a great idea.
I think i'll use ODBC, it might give me a lot of work but in my case, would be the best option. Thanks again..

XML Upload

Member 97011655-Jun-13 23:59

Member 9701165

5-Jun-13 23:59

Please Help me to Upload XML file into the SQLServer2008

Re: XML Upload

Eddy Vluggen6-Jun-13 0:38

Eddy Vluggen

6-Jun-13 0:38

Using C#? What have you tried? There's lots of examples on Google that show how to save a text to a database.

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]

Re: XML Upload

Member 97011656-Jun-13 0:43

Member 9701165

6-Jun-13 0:43

Using C#? What have you tried? There's lots of examples on Google that show how to save a text to a database using C#

Re: XML Upload

Dave Kreskowiak6-Jun-13 2:10

Dave Kreskowiak

6-Jun-13 2:10

Polly want a cracker?

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

Re: XML Upload

OriginalGriff6-Jun-13 8:12

OriginalGriff

6-Jun-13 8:12

Trunkie wanna bun? Laugh | :laugh:

The universe is composed of electrons, neutrons, protons and......morons. (ThePhantomUpvoter)

My vote of 1

Keith Barrow6-Jun-13 2:48

Keith Barrow

6-Jun-13 2:48

Need I even point it out?

Excel Spreadsheet formatting via OfficeOpenXml

matt_1ca5-Jun-13 22:49

matt_1ca

5-Jun-13 22:49

Wondering if there is someone in this discussion forum who has experienced OfficeOpenXml to be able to give me some enlightenment on how to format cells (or column) so that it is becomes a Number, Category: Accounting or a Number, Category: Currency... all in an Excel spreadsheet

I have tried to do it for hours without any luck ... I do not know where to find documention on this except that of playing with the intellisense objects and would appreciate all the help anyone can give on the matter.

Thanks so much I really appreciate it.

Matt

Re: Excel Spreadsheet formatting via OfficeOpenXml

Richard MacCutchan5-Jun-13 23:32

Richard MacCutchan

5-Jun-13 23:32

You could try creating the spreadsheet, save it to XML and then look at the generated XML. Or you could try http://www.openoffice.org/[^].

Use the best guess

Re: Excel Spreadsheet formatting via OfficeOpenXml

matt_1ca8-Jun-13 22:32

matt_1ca

8-Jun-13 22:32

Thanks for the OpenXml link ... I really appreciate it ... it will help with getting additional info on this problem ..thanks

c# error with database query transactions

User34905-Jun-13 22:35

User3490

5-Jun-13 22:35

Hi

i make a setup in visual studio 2010 and a make it install to another laptop but the access 2010 database can not make update their queries but we can retrieve information from it.

What might be the problem?

Re: c# error with database query transactions

OriginalGriff5-Jun-13 23:07

OriginalGriff

5-Jun-13 23:07

If you can read from it, but not write to it, then the most likely problem is permissions on the file or the folder you have stored it in. It is probable that you have installed the database file in the application folder, which on the release machine means under one of the "Program Files" folder. Writes to these folders are heavily discouraged, and if you have done that it is a poor idea. It works on your development machine because the application is in the Debug or Release folder of your project - not the "Program Files" folder at all.
Have a look here: Where should I store my data?[^] and move you data to a more sensible location!

The universe is composed of electrons, neutrons, protons and......morons. (ThePhantomUpvoter)

Re: c# error with database query transactions

User34905-Jun-13 23:41

User3490

5-Jun-13 23:41

when i make the setup there are only application, user desktop and user's programs menu folder .

Where can i put my access database so the user can be modify?

Re: c# error with database query transactions

OriginalGriff6-Jun-13 0:02

OriginalGriff

6-Jun-13 0:02

Read the link I gave you.

The universe is composed of electrons, neutrons, protons and......morons. (ThePhantomUpvoter)

Re: c# error with database query transactions

User34906-Jun-13 0:36

User3490

6-Jun-13 0:36

If i correctly understand i must use one of the following path as my path for my access database but how can i use it in c# ?
i must include it somewhere for example the Common.AppGuid where i have to use it?

Common.AppGuid 158aa00d-332e-440b-9c2c-47e2fc11c078
Common.AssemblyGuid 8d14ff7e-8d39-4163-a1ba-4fae4a5c361d
Common.UserDataFolder C:\Users\griff\AppData\Local\{158AA00D-332E-440B-9C2C-47E2FC11C078}\
Application.UserAppDataPath C:\Users\griff\AppData\Roaming\SetShares\SetShares\1.0.0.0
Common.UserRoamingDataFolder C:\Users\griff\AppData\Roaming\{158AA00D-332E-440B-9C2C-47E2FC11C078}\
Application.LocalUserAppDataPath C:\Users\griff\AppData\Local\SetShares\SetShares\1.0.0.0
Common.AllUsersDataFolder C:\ProgramData\{158AA00D-332E-440B-9C2C-47E2FC11C078}\
Application.CommonAppDataPath C:\ProgramData\SetShares\SetShares\1.0.0.0

thnx

Re: c# error with database query transactions

OriginalGriff6-Jun-13 0:44

OriginalGriff

6-Jun-13 0:44

Common.AppGuid is a value assigned to you application when you compile it.
Just add the methods, and store your file in the folder returned by AllUsersDataFolder

The universe is composed of electrons, neutrons, protons and......morons. (ThePhantomUpvoter)

Message Closed

6-Jun-13 1:07

User3490

6-Jun-13 1:07

Message Closed

modified 6-Jun-13 7:55am.

Re: c# error with database query transactions

OriginalGriff6-Jun-13 1:10

OriginalGriff

6-Jun-13 1:10

You probably need to add the using statements.
Look at your code where the error is, and place the text cursor inside the word that is underlined in red.
A small blue block will appear at the beginning of the word. Hover the mouse over that, and a drop down list will appear.
Open the drop down, and it will present you with options to fix the problem. (In this case, probably by adding the line

using System.Reflection;

for you).

(This is based on your previous post, now deleted - but still relevant, I suspect)

The universe is composed of electrons, neutrons, protons and......morons. (ThePhantomUpvoter)

Re: c# error with database query transactions

User34906-Jun-13 1:18

User3490

6-Jun-13 1:18

what is the B here?

public static string UserDataFolder
       {
           get
           {
               Guid appGuid = AppGuid;
               string folderBase = Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData);
               string dir = string.Format(@"{0}\{1}\", folderBase, 

------->     appGuid.ToString("B").ToUpper());
               return CheckDir(dir);
           }
       }

Re: c# error with database query transactions

OriginalGriff6-Jun-13 1:26

OriginalGriff

6-Jun-13 1:26

See MSDN: Guid.ToString Method[^]

The universe is composed of electrons, neutrons, protons and......morons. (ThePhantomUpvoter)

Re: c# error with database query transactions

User34906-Jun-13 7:34

User3490

6-Jun-13 7:34

where must i add these methods ?
there is a specific location so when the application start these methods call automatically?
where i can to call them? in program file?

Re: c# error with database query transactions

OriginalGriff6-Jun-13 8:00

OriginalGriff

6-Jun-13 8:00

Wherever you normally put "generic" helper methods. I would call it once from my main form and save a static string with the whole connection string ready to rock'n'roll when you need to access the file.

The universe is composed of electrons, neutrons, protons and......morons. (ThePhantomUpvoter)

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