Why is my .mdb connection not working? - C# Discussion Boards

Re: How do I create a new folder programmatically?

mav.northwind2-Oct-05 12:24

mav.northwind

2-Oct-05 12:24

What's wrong with Directory.CreateDirectory() ?

mav

Re: How do I create a new folder programmatically?

tom_dx3-Oct-05 11:56

tom_dx

3-Oct-05 11:56

THX

IM PROUD TO BE A GMAIL;

Re: How do I create a new folder programmatically?

Mahesh Kumar V K2-Oct-05 19:53

Mahesh Kumar V K

2-Oct-05 19:53

Example,

Is this what you meant???
System.IO.Directory.CreateDirectory(@"D:\NewFolder\NewSubFolder")

Regards,
Mahesh

Save a text file as ANSI instead of UTF-8?

mcyrrer2-Oct-05 10:37

mcyrrer

2-Oct-05 10:37

Hi!
I need some help with how to save a bunch of strings into an ANSI-text file and not the standard UTF-8. The reason for this is that the application that uses this text file does not like UTF-8 when a special character is involved (like Swedish åäö etc). Does anyone have any good ideas or sample codes out there to save a file into ANSI instead of UTF-8?

Re: Save a text file as ANSI instead of UTF-8?

mav.northwind2-Oct-05 12:26

mav.northwind

2-Oct-05 12:26

Hi!

When you create a FileStream you can specify an encoding to use. There you can use Encoding.ASCII to get non-UTF8 text files.

mav

Re: Save a text file as ANSI instead of UTF-8?

mcyrrer2-Oct-05 20:14

mcyrrer

2-Oct-05 20:14

As usually... It was too easy. Tank you very much .

Re: Save a text file as ANSI instead of UTF-8?

pipiscrew3-Jul-12 10:14

pipiscrew

3-Jul-12 10:14

CultureInfo culture = new CultureInfo("el-GR");
int codePage = culture.TextInfo.ANSICodePage;
Encoding GreekEncoding = Encoding.GetEncoding(codePage);

then at this line :
new StreamWriter(destinationpath, false, GreekEncoding);

Why is my .mdb connection not working?

Anonymous2-Oct-05 9:38

Anonymous

2-Oct-05 9:38

I try to get some data from a .mdb file, but it fails with a realy weird and long exception, here is my code:

public DataSet getTranslation(int language)
{

DataSet translations = new DataSet();
String connes = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Documents and Settings\\Johan\\My Documents\\languageDB1_00.mdb";
String sql = ("SELECT Translation, PhraseKey FROM Translation WHERE languageID = " + language + ";");
OleDbConnection conn = null;

conn = new OleDbConnection(connes);
//"SELECT Translation, PhraseKey FROM Translation WHERE languageID = " + language + ";";
try
{
OleDbCommand command = new OleDbCommand(sql, conn);
OleDbDataAdapter adapter = new OleDbDataAdapter(command);
conn.Open();
adapter.Fill(translations, "Translation");
return translations;
}
catch (Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.ToString());
return null;
}
finally
{
conn.Close();
}
}

The exeption message begins with:
IErrorInfo.GetDescription failed with E_FAIL (0x80004005)

please help...

john

Re: Why is my .mdb connection not working?

Mahesh Kumar V K2-Oct-05 21:39

Mahesh Kumar V K

2-Oct-05 21:39

Hello John,

The problem is because of the usage of the keyword "Translation" as in OLEDB.
If you change the SQL to

String sql = "(SELECT [Translation], PhraseKey FROM [Translation] " + <br />
							"WHERE languageID = " + language + ")";

the snippet will work fine.

Regards
Mahesh

Get External Ip

ventomito2-Oct-05 8:37

ventomito

2-Oct-05 8:37

Hello folks,
i'm not a C# expert so i have a question to do.
I want to fetch the external ip of a machine whin is linked at a router.
All the HowTo i have seen didnt help me Frown | :(

If anyone can help I would be grateful.

Thanks
Enrico

most efficient way to draw triangle

...---...2-Oct-05 6:04

...---...

2-Oct-05 6:04

I want to draw a triangle on the end of a line (vector).
I know how to do it brute force. Is there a better way?

Thanks a lot...

Re: most efficient way to draw triangle

Dave Kreskowiak2-Oct-05 7:12

Dave Kreskowiak

2-Oct-05 7:12

How would we know what "brute force" is to compare it to a better method? You have to post some code or supply some explanation of how you're doing it now. Also, the "best way" depends on the situation that the code is being used in. Do you need to draw this triangle in a certain position all the time, does it have to function as an arrow pointer, following the slope of the line? ???

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Re: most efficient way to draw triangle

...---...2-Oct-05 8:20

...---...

2-Oct-05 8:20

Point taken.
What I want is a triangle at the end of a line just as in the hands of a clock (it's not a clock).
By by "brute force", I meant a set of 3 connected points
Placed at the other end of the line.

Re: most efficient way to draw triangle

Dave Kreskowiak2-Oct-05 8:47

Dave Kreskowiak

2-Oct-05 8:47

Have you looked at the LineCap's of a Pen? Click[^]

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Re: most efficient way to draw triangle

...---...2-Oct-05 9:24

...---...

2-Oct-05 9:24

Wow. I had no idea.... thanks. Not to get too greedy here, but is it possible to use it for the
technique here? Or will I have to re-write most of it.... thanks again

/////////////////////////////////////////////////////////////////////////////////////////////////////

public Pen[] activePen = new Pen[] { new Pen( Color.Blue, 2 ), new Pen( Color.Green, 2 ), new Pen(Color.Red, 2) };

private int _penIndex = -1;

/////////////////////////////////////////////////////////////////////////////////////////////////////////

private Pen GetNextPen()
{
_penIndex = (_penIndex + 1) % 3;
return activePen[_penIndex];
}

//////////////////////////////////////////////////////////////////////////////////////////////////////

g.DrawLine(GetNextPen(), 250, 250, x, y );

/////////////////////////////////////////////////////////////////////////////////////////////

Re: most efficient way to draw triangle

Robert Rohde2-Oct-05 19:29

Robert Rohde

2-Oct-05 19:29

Sure you can, but you will have to initialize the array of Pen somewhere else (for example in the constructor):

private Pen[] activePen; //btw: members should always be private

public MyClass() {
activePen = new Pen[] { new Pen( Color.Blue, 2 ), new Pen( Color.Green, 2 ), new Pen(Color.Red, 2) };
activePen[0].EndCap = System.Drawing.Drawing2D.LineCap.Round;
activePen[1].EndCap = System.Drawing.Drawing2D.LineCap.Triangle;
activePen[2].StartCap = System.Drawing.Drawing2D.LineCap.Triangle;
activePen[3].EndCap = System.Drawing.Drawing2D.LineCap.ArrowAnchor;
}

Now all your pens have different kind of caps. You can als play around with the other properties of the Pen (like Dash...). You should also look at the CustomeStartCap/EndCap properties. With them you can define special caps (if needed).

OleDbType cast to BaseType .Net

Gedrain2-Oct-05 3:24

Gedrain

2-Oct-05 3:24

Hello,

in the help it says Varchar of the Type OleDBType is mapped to string of the .Net framework. How can i get this information if i have the OleDBType? because i can't find it anywhere this information.

greetings

Sander

Re: OleDbType cast to BaseType .Net

Dave Kreskowiak2-Oct-05 7:17

Dave Kreskowiak

2-Oct-05 7:17

Get what information?

The .Value of the OleDbParameter object? Easy, look at the .Value property.

What the OleDbTypes map to? This map doesn't exist in code. There are no hard-and-fast rules that "map" an OleDbType to a .NET Framework type. For example, you could read a database integer type into many types in the .NET Framework, depending on how you're using the data, an integer, single, double, byte, ...

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Re: OleDbType cast to BaseType .Net

Gedrain2-Oct-05 7:21

Gedrain

2-Oct-05 7:21

System.Data.DataTable tableSchema = Connection.GetOleDbSchemaTable( System.Data.OleDb.OleDbSchemaGuid.Columns, new object [ ] {null, null, t.name, null} );

System.Data.DataView dVTableSchema = new System.Data.DataView(tableSchema);
dVTableSchema.Sort = "ORDINAL_POSITION ASC";
for (int i=0; i < dVTableSchema.Count; i++)
{
int dataNumber = (int) dVTableSchema[i]["DATA_TYPE"];
System.Data.OleDb.OleDbType columnType = (System.Data.OleDb.OleDbType) Enum.Parse(new System.Data.OleDb.OleDbType().GetType(), dataNumber.ToString());

okej i have now the columType but know i wanna know how i can read the mapped .net type and i'm not using any oledbparameters.

greetings

Sander

Re: OleDbType cast to BaseType .Net

Dave Kreskowiak2-Oct-05 8:29

Dave Kreskowiak

2-Oct-05 8:29

There is NO MAPPED TYPE! The data can be moved to ANY .NET Framework value type.
The "mapping" is a set of guidelines, not a direct one-to-one relationship between the database type and any .NET Framework types.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Re: OleDbType cast to BaseType .Net

Gedrain2-Oct-05 8:36

Gedrain

2-Oct-05 8:36

hmm that sux because i need the base type so i need to translate it my self?

Re: OleDbType cast to BaseType .Net

Dave Kreskowiak2-Oct-05 8:50

Dave Kreskowiak

2-Oct-05 8:50

You have a problem. Say you read a floating point value from the database. Which .NET type are you going to map it to, Decimal (128-bits), Double (64-bits), Single (32-bits), integer, ...?

Yep. You have to pick an appropriate type to hold the value, since only YOU know what the range of that value should be and what precision you want it to be.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Help!! monitor bandwidth usage

dunbshy2-Oct-05 3:03

dunbshy

2-Oct-05 3:03

i'm a newbbie in programming, can somebody tell me how to create a program to monitor the bandwidth usage of each host within a network? Can System.Diagnostics.PerformanceCounter be used to monitor a remote computer?

Re: Help!! monitor bandwidth usage

Dave Kreskowiak2-Oct-05 7:09

Dave Kreskowiak

2-Oct-05 7:09

Monitoring the bandwidth usage is best done by the switch the machine is connected to. If you do it over a remote connection using the Performance counters, you'll skew the usage statistics because transferring the counter information will add to the usage.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Re: Help!! monitor bandwidth usage

dunbshy2-Oct-05 7:26

dunbshy

2-Oct-05 7:26

thanks for your info Dave. By the way, What namespace or library do i need to investigate in order to write a bandwidth usage monitoring application? Do i need to create a client application and install it in the host machine within a network? the main function of my application will be monitoring the bandwidth usage of each machine within a LAN. And those machines are connected to internet through a router/switch/hub.

You mentioned that monitoring the bandwidth usage is best done by the switch the machinese is connected to. How can this be done? By monitoring every port of the switch? Can you tell me in details?

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