C# - Insert data into Paradox table without primary key. - C# Discussion Boards

DavidNohejl15-May-05 8:25

15-May-05 8:25

err don't you mean "Console" type project?

The Undefeated wrote:
And i was wondering, what compiler compiles C# into a 16-bit DOS app. instead of a standard windows app?

No compiler I know about do that. All compile C# to IL.

David

Never forget: "Stay kul and happy" (I.A.)

David's thoughts / dnhsoftware.org / MyHTMLTidy

Anthony Mushrow15-May-05 8:36

Anthony Mushrow

15-May-05 8:36

Err. No i know how to make console app. but i wanted something that would run in DOS, console app dont work in DOS (they need to be compiled for use with DOS using something like Turbo C++ - but of course thats for C++)

DavidNohejl15-May-05 8:46

15-May-05 8:46

It's easy then. You must have .NET Framework for C# apps. IMO .NET Framework is for Win2k and newer, definitely not for DOS. There is way how to pre-compile app to machine code, but that's for faster startup only (I think) - NGen[^]

David

Never forget: "Stay kul and happy" (I.A.)

David's thoughts / dnhsoftware.org / MyHTMLTidy

Luis Alonso Ramos15-May-05 10:18

Luis Alonso Ramos

15-May-05 10:18

dnh wrote:
IMO .NET Framework is for Win2k and newer

Actually the .NET Framework works with everything since Windows 98 (just not 95), but still, not in old regular MS-DOS.

-- LuisR

Luis Alonso Ramos
Intelectix - Chihuahua, Mexico

Not much here: My CP Blog!

DavidNohejl15-May-05 10:46

15-May-05 10:46

Thanks.

David

Never forget: "Stay kul and happy" (I.A.)

David's thoughts / dnhsoftware.org / MyHTMLTidy

Peter Vertes15-May-05 16:31

Peter Vertes

15-May-05 16:31

I'm afraid you are out of luck Undefeated. .NET requires the underlying OS to able to be 32-bit capable. DOS on the other hand is only 16-bit capable hence .NET will not be able to run on it. Sorry...

C# - Insert data into Paradox table without primary key.

CiNN23-May-05 7:29

CiNN

23-May-05 7:29

someone could have written its own ompiler ^o^
that compile C# CLR for DOS with customized functions

elapid15-May-05 8:13

elapid

15-May-05 8:13

Dear,

Thank you for reading this question, please help me out if you can.

I got a paradox table without primary key, now I am trying to insert data into it, but keep getting an error: "Operation must use updateable query". Now after doing some readings, I found that it is because the table doesnt have a primary key, and the suggestion was to create a primary key for the datatable...

Now how do i do that? I also try to use the InsertCommand, but doesn't know how it works.. if someone could please explain this to me.. like how it works, and when it get triggered..etc

thank you.
Elapid
elapidd@yahoo.com

Elapid needs help.

Re: C# - Insert data into Paradox table without primary key.

Marc Clifton15-May-05 9:08

Marc Clifton

15-May-05 9:08

elapid wrote:
Now how do i do that?

The DataTable class has a PrimaryKey property which takes a DataColumn array, where each data column in the array is a column of the data table that is the primary key.

So, you would do something like:

dt.PrimaryKey=new DataColumn[] {dt.Columns["ID"]};

Of course, the real question is, why doesn't your table in the database have a primary key? If you load the data set with schema information, the data table should already be configured with the primary key, I think.

Marc

MyXaml
Advanced Unit Testing
YAPO

Re: C# - Insert data into Paradox table without primary key.

elapid15-May-05 10:34

elapid

15-May-05 10:34

Marc,

I understood the primary key part, but in paradox table, i dont really know how to make a [name].DB (paradox table) with a primary key.

mysql command is : create table Test.DB (Code varchar(2) primary key, Desc varchar(30))
and it keeps bombing on me saying index 345-3-543-5-34 is not valid

any suggestion?

Elapid For The Win

Re: C# - Insert data into Paradox table without primary key.

Marc Clifton15-May-05 14:25

Marc Clifton

15-May-05 14:25

elapid wrote:
i dont really know how to make a [name].DB (paradox table) with a primary key.

Maybe this will help:

http://media.datadirect.com/download/docs/odbc/odbcref/paradox.html[^]

It seems that the syntax is something like:

CREATE UNIQUE INDEX PRIMARY ON test (Code)

Unsure | :~

Marc

MyXaml
Advanced Unit Testing
YAPO

Quick Command Pattern Question

Dato15-May-05 5:08

Dato

15-May-05 5:08

I was reading a simple article on the Command Pattern and had a quick question.
The article is short and its here:

http://www.c-sharpcorner.com/Code/2002/Mar/CommandPatternsInCSCKU.asp[^]
For example if I had a base Class DVDPlayer and I wanted a status on the player would this be implemented this way ??

<br />
public class DVDPlayer : ICommand	<br />
	{<br />
		protected string mCDStatus="";<br />
		<br />
		public CDPlayer()<br />
		{<br />
<br />
		}<br />
		public string CDStatus<br />
		{<br />
			get{return this.mCDStatus;}<br />
		}<br />
<br />
		public void Execute()<br />
		{<br />
			<br />
		}<br />
public class DVDPlay: DVDPlayer, ICommand <br />
	{<br />
		public CDPlay()<br />
		{<br />
<br />
		}<br />
		//Please note "new" below"<br />
		public new void Execute()<br />
		{<br />
			base.mCDStatus = "Playing";<br />
		}<br />
<br />
	}<br />
<br />

With my main method like this ??:

<br />
Remote rm = new Remote();<br />
			CDPlayer player = new CDPlayer();<br />
			player = new CDPlay();<br />
			rm.Invoke(player);<br />
			MessageBox.Show(player.CDStatus.ToString());<br />

Is this the best implementation ?? Good Design ? Any ideas ?
thks in advance ..
Note : Remote class below:

<br />
public class Remote<br />
		{<br />
			public Remote()<br />
			{<br />
				<br />
			}<br />
			public void Invoke(ICommand cmd)<br />
			{<br />
				cmd.Execute();<br />
			}<br />
			<br />
		}<br />

Re: Quick Command Pattern Question

DavidNohejl15-May-05 5:40

Re: Quick Command Pattern Question

15-May-05 5:40

Dato wrote:
Is this the best implementation ??

hmm

Dato wrote:
public string CDStatus
{
get{return this.mCDStatus;}
}

Dato wrote:
MessageBox.Show(player.CDStatus.ToString());

WTF | :WTF:

David

Never forget: "Stay kul and happy" (I.A.)

David's thoughts / dnhsoftware.org / MyHTMLTidy

Marc Clifton15-May-05 8:58

Marc Clifton

15-May-05 8:58

Why not just modify the original source code?

I take it that ICommand specifies the Execute method? It's really bad practice to use "new", and it shows that the original implementer didn't design the class correctly--the base class that implements Execute should be declarated as virtual, so derived classes can override it.

Why are you doing CDStatus.ToString() when CDStatus returns a string?

I also don't like the "this.mCDStatus", in particular, the "this.". It's redundant and unnecessary. "return mCDStatus" is quite sufficient.

Marc

MyXaml
Advanced Unit Testing
YAPO

using a webcam in my C# application

GaMBiT_KC15-May-05 2:09

GaMBiT_KC

15-May-05 2:09

Hi guyz, I'm developing a small experimental application for myself...and I want to implement some motion detection algorithms.

However, I want to take the input from a webcam. Therefore my question is:
How do you use a webcam through C#?? Confused | :confused:

Any help is highly appreciated (even a web tutorial would be a nice suggestion!)

ThankS Confused | :confused:

GaMBiT---> aND ReVeNGe WiLL Be

Andrew Kirillov15-May-05 2:20

Andrew Kirillov

15-May-05 2:20

Hello

Try to use DirectShow. You can interop it, or you can use managed DirectX 9.

Here is an article on CP:
http://www.codeproject.com/cs/media/directxcapture.asp[^]

GaMBiT_KC16-May-05 3:11

GaMBiT_KC

16-May-05 3:11

10Q for your help! Smile | :)

GaMBiT---> aND ReVeNGe WiLL Be

pubududilena15-May-05 18:04

pubududilena

15-May-05 18:04

hi,
Try to use Windows Media Encorder 9 series sdk.There is a sample using C#..
http://www.microsoft.com/windows/windowsmedia/mp10/sdk.aspx[^]

regards
pubudu.