Re: Import data - C# Discussion Boards

bouli19-Nov-04 10:14

19-Nov-04 10:14

If you have another suggestion, it's welcome.
the goal is to save the processed lines from the text file, in my own format.
The rows I read are correct, the contents of the rows in memory are correct, but I don't want all in memory. once I processed the row, I store immediatly the row in order to keep only one row in memory.

There is no spoon.

Re: Import data

Heath Stewart19-Nov-04 10:16

Heath Stewart

19-Nov-04 10:16

We just told you how to do it. Read your file line-by-line, process it however you require, then save it. This is a simple, entry-level problem with file I/O. As we've all said - don't read the whole thing into memory, only deal with one or a few rows at a time and persist the processed data however you require. It's your requirements (which you failed to tell us about anyway: "process" could be anything) so you need to figure out how to process the data. The System.IO and System.Data namespace classes are there to facilitate retreiving and storing data.

This posting is provided "AS IS" with no warranties, and confers no rights.

Software Design Engineer
Developer Division Sustained Engineering
Microsoft

[My Articles] [My Blog]

Re: Import data

bouli19-Nov-04 10:29

bouli

19-Nov-04 10:29

ok.
So instead of using the ReadToEnd() method of StreamReader, I may do a loop and use the ReadLine() method, like in the MSDN sample.

There is no spoon.

Re: Import data

Nick Parker19-Nov-04 19:41

Nick Parker

19-Nov-04 19:41

Yes, you could do that.

- Nick Parker
My Blog | My Articles

Re: Import data

bouli19-Nov-04 21:52

bouli

19-Nov-04 21:52

I have a more simple idea.

I will simply save my read data from text file in an ms-access database (mdb).
Then ms-access will do the queries.

What is the namespace that creates and manipulates ms-access database format (mdb)? Is it ADO?

I think it's the simplest.

There is no spoon.

Re: Import data

Nick Parker20-Nov-04 5:07

Nick Parker

20-Nov-04 5:07

I would recommend that you check out the documentation on MSDN, it will be very helpful. In particular, check into the OleDbConnection Class[^]. HTH.

- Nick Parker
My Blog | My Articles

Re: Import data

bouli20-Nov-04 5:08

bouli

20-Nov-04 5:08

Ok. I'm going to check this class.
Thanks Smile | :)

There is no spoon.

Re: Import data

Heath Stewart19-Nov-04 10:13

Heath Stewart

19-Nov-04 10:13

The .NET Framework is not an application - it's a framework (hence the name) on which applications are built. The JRE (Java runtime environment) doesn't implement bulk importers either, but gives you the classes (i.e., the framework) with which to create bulk importers.

Yes, ODBC and OLE DB both have a driver to treat delimited text files as data sources and you can use that using either the System.Data.Odbc or System.Data.OleDb classes, buth that would be very inefficient because you're P/Invoking (indirectly) native calls and marshaling data. Reading it faster like the other reply (from Nick) mentions is much faster.

This posting is provided "AS IS" with no warranties, and confers no rights.

Software Design Engineer
Developer Division Sustained Engineering
Microsoft

[My Articles] [My Blog]

enum Questions

niceguyeddie19-Nov-04 6:31

niceguyeddie

19-Nov-04 6:31

I'm new at C#, okay with C++

Lets say hypothetically that i'm making a video game and I want to make a button that fires a weapon.. I've made an enum for my "special keys"... so instead of using the Keys enum which doesn't give the keys any more of a description more than what letter it is. So I wanted to make a new Keys enum called myKeys and do something like this

<br />
enum myKeys <br />
{<br />
     SpecialKey1 = Keys.N,<br />
     FireWeapon  = Keys.P,<br />
     //etc....<br />
}<br />
<br />
protected override void OnKeyUp(KeyEventArgs e)<br />
{<br />
     if (e.KeyCode == myKeys.SpecialKey1)  //Error<br />
     {<br />
            //Do something;<br />
     }<br />
     if (e.KeyCode == Keys.N)  //NO error<br />
     {<br />
            //Do something;<br />
     }<br />
}<br />

What am I doing wrong here?

This is the error...

<br />
 Operator '==' cannot be applied to operands of type 'System.Windows.Forms.Keys' and 'myApp.myKeys'<br />

Seems like neither of the above should work by looking at this error? What going on here? Suggestions for other ways of accomplishing the same task

Thanks for responses guys

Re: enum Questions

Daniel Turini19-Nov-04 6:55

Daniel Turini

19-Nov-04 6:55

niceguyeddie wrote:
Operator '==' cannot be applied to operands of type 'System.Windows.Forms.Keys' and 'myApp.myKeys'
Each enum is a different type, you'll need to explicitly cast both to int to compare them.

Yes, even I am blogging now!

Re: enum Questions

Dennis C. Dietrich19-Nov-04 6:59

Dennis C. Dietrich

19-Nov-04 6:59

niceguyeddie wrote:
What am I doing wrong here?

C# is type-safe and the type of KeyEventArgs.KeyCode[^] is Keys[^]. Therefore you have to explicitly cast the type:

if (e.KeyCode == (Keys)myKeys.SpecialKey1)
{
}

Lets say hypothetically that i'm making a video game and I want to make a button that fires a weapon.

I would definitely not use an enumeration to store the keys because a modern video game should provide a setup for reassigning the keys.

Best regards
Dennis

Re: enum Questions

niceguyeddie19-Nov-04 7:25

niceguyeddie

19-Nov-04 7:25

thanks guys, that completly makes sense.. those are the things that make you pull hair out for an hour because the solution is so easy yet just can't seem to see it.

this is actually not for a video game, the keys won't have to be reassigned. I can recompile if I need to change something.

Re: enum Questions

Heath Stewart19-Nov-04 8:12

Heath Stewart

19-Nov-04 8:12

On a different note (since your question was accurately answered) you should consider not hard-coding certain keys. Many people agree that a good game allows for key mapping, and - in a basic capacity - it's not that hard to add.

Lets say you host your game in a Form (this is typically the came even with Managed DirectX). There is a method you can override (actually several) named ProcessDialogKey. You would also keep a key map of what keys map to which actions. One way would be to use the hash table and an enumeration (like you already have) of Keys to Actions (assuming Actions is your action enumeration), which you could persist in a file, database, etc.

Take the following example (doesn't include persistence):

protected override bool ProcessDialogKey(Keys keyData)
{
  if (keyMap.ContainsKey(keyData))
  {
    Action a = (Action)keyMap[keyData];
    switch (a)
    {
      case Action.Shoot:
        Shoot();
        break;
      case Action.Duck;
        Duck();
        break;
      // ...
    }
    return true;
  }
  return false;
}

Depending on how your game's Form is set up, you may also need to set the Form's KeyPreview property to true to make sure that the form processes the keys before its child controls do.

This posting is provided "AS IS" with no warranties, and confers no rights.

Software Design Engineer
Developer Division Sustained Engineering
Microsoft

[My Articles] [My Blog]

Re: enum Questions

Daniel Turini20-Nov-04 5:47

Daniel Turini

20-Nov-04 5:47

Heath Stewart wrote:
switch (a)
{
case Action.Shoot:
Shoot();
break;
case Action.Duck;
Duck();
break;
// ...
}
return true;
}
Actually, you could get rid of this switch by storing interface pointers in the hashtable and simply call an "executeAction" method, or something like that.

Yes, even I am blogging now!

Re: enum Questions

niceguyeddie22-Nov-04 6:22

niceguyeddie

22-Nov-04 6:22

that indeed seems like a good way to go - only thing that looks like may not be good is that theres no way to tell if it was a keyup or keydown...

okay heres one more, this one is equally as retarded hahah

enum EnumType{Up, Down, Left Right}

public void myMethod(EnumType Direction)
{
      //Do somnething
}

and the error....

Inconsistent accessibility: parameter type '..EnumType' is less accessible than method '..myMethod'

I'd rather do this than the less meaningfull int 1,2,3,4 etc.
any ideas. ?

Re: enum Questions

Daniel Turini22-Nov-04 6:24

Daniel Turini

22-Nov-04 6:24

niceguyeddie wrote:
Inconsistent accessibility: parameter type '..EnumType' is less accessible than method '..myMethod'
Your enum is private, but your method is public and you are using the EnumType on the parameter list.

Yes, even I am blogging now!

picturebox and imagelist in C#

youssef19-Nov-04 4:44

youssef

19-Nov-04 4:44

Hi,

I create an ImageList with some BMP file and create a PictureBox.

I would like to know how can I do for selecting an image from my list and put it on the Picturebox.

Best Regrads

youssef

Re: picturebox and imagelist in C#

Heath Stewart19-Nov-04 8:13

Heath Stewart

19-Nov-04 8:13

pictureBox1.Image = imageList1.Images[3]; // Asign the 4th image

This posting is provided "AS IS" with no warranties, and confers no rights.

Software Design Engineer
Developer Division Sustained Engineering
Microsoft

[My Articles] [My Blog]

Re: picturebox and imagelist in C#

youssef19-Nov-04 8:37

youssef

19-Nov-04 8:37

thanks

youssef

RasAPI in C# - connecting after failure

Roland Bär19-Nov-04 3:16

Roland Bär

19-Nov-04 3:16

I have a Application that has to connect via ras to other devices. For this I have imported some RasAPI32-functions (RasDial, RasHangup). When an error occured while connecting, a call of the rasdial function results in the error code 756 - Dial already in progress).
When i stop my application and restart it, i can connect again.
How can I 'reset' a connection that is blocked in this way?

Thanks
Roland

Wenn Du diesen Satz irgendwo liest, ignoriere ihn.

Re: RasAPI in C# - connecting after failure

Daniel Turini19-Nov-04 6:53

Daniel Turini

19-Nov-04 6:53

Roland Bär wrote:
How can I 'reset' a connection that is blocked in this way?
IIRC, you need to call RasHangup even when RasDial fails. But I may be wrong, I didn't work with RAS in the past few years.

Yes, even I am blogging now!

Re: RasAPI in C# - connecting after failure

Roland Bär21-Nov-04 23:25

Roland Bär

21-Nov-04 23:25

Thanks Daniel, your help saved me a lot of trouble!

Roland

Wenn Du diesen Satz irgendwo liest, ignoriere ihn.

Windows Service and Sql Server

Anonymous19-Nov-04 2:41

Anonymous

19-Nov-04 2:41

Hello,

I have a windows service that updates the database. I installed it on the machine with SQL Server installed, it worked perfectly. But when I installed it on a client machine, the service does not start, and ends up with JIT compiltation error :

Could not start Data Update service on the Local Computer. The service did not return an error. This could be internal Windows error or internal Service error.

I have changed the connection string accordingly. But it always breaks on

this.sqlConn.Open();

Can anyone tell me what am I missing?

regards,
Zishan

Re: Windows Service and Sql Server

Dennis C. Dietrich19-Nov-04 3:15

Dennis C. Dietrich

19-Nov-04 3:15

Zishan wrote:
I installed it on the machine with SQL Server installed, it worked perfectly. But when I installed it on a client machine, the service does not start, and ends up with JIT compiltation error

Are the MDAC correctly installed on the target machine (see also .NET Framework 1.1 Redistributable Prerequisites[^])?

Best regards
Dennis

Re: Windows Service and Sql Server

Daniel Turini19-Nov-04 6:49

Daniel Turini

19-Nov-04 6:49

Anonymous wrote:
Can anyone tell me what am I missing?
Do you have an error message and/or the stack trace? (on the catch, try calling ToString() on the exception to get this information).

Yes, even I am blogging now!

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