Re: Connecting to MySQL with ODBC - C# Discussion Boards

How to draw on nonclient area of a form ?

Andres Coder3-Mar-04 5:11

3-Mar-04 5:11

How can I draw on a nonclient area of a form ? I mean the border and the caption. Before I started using C#, I just used WM_NCPAINT message to do the job, but I have no ideas how to do it in C# now ? Can anyone help me ?

Also, how can I get the size of the nonclient area ?

Regards, Desmond

Re: How to draw on nonclient area of a form ?

Andres Coder3-Mar-04 5:30

Andres Coder

3-Mar-04 5:30

Maybe I somehow have to import a some procedure form Win32 API, using DLLImport attribute ?

Re: How to draw on nonclient area of a form ?

Heath Stewart3-Mar-04 6:09

Heath Stewart

3-Mar-04 6:09

Override WndProc and continue to use WM_NCPAINT. In your handler, you can get a Graphics from several means, such as Graphics.FromHwnd, passing the HWND (an IntPtr) that you get along with the Message that you're handling in WndProc.

Microsoft MVP, Visual C#
My Articles

Re: How to draw on nonclient area of a form ?

Andres Coder3-Mar-04 7:01

Andres Coder

3-Mar-04 7:01

Thanks, but it's a bit hard for me to understand this. Could you please support me with a basic code example ?

Re: How to draw on nonclient area of a form ?

Heath Stewart3-Mar-04 8:40

Heath Stewart

3-Mar-04 8:40

You do just like you did in C++, only using managed code. If you need examples, try http://www.google.com[^]. There's many examples out there I've seen in the past.

Microsoft MVP, Visual C#
My Articles

Re: How to draw on nonclient area of a form ?

Andres Coder3-Mar-04 8:44

Andres Coder

3-Mar-04 8:44

Did so -> problem solved. Thanks. Note that I actually didn't came from C++, but from Borland Delphi (it's not that bad, really).

Connecting to MySQL with ODBC

sps-itsec463-Mar-04 3:12

sps-itsec46

3-Mar-04 3:12

Hi guys,

I think it's a simple question: I connect to a MySQL database with OdbcDataAdapter and besides the data I want to get the schema of the database directly from the database, so I use something like this:

public DataSet GetData()
{
    // Create DataSet
    DataSet ds = new DataSet(datasetName);
    OdbcDataAdapter adapter = new OdbcDataAdapter();
    adapter.SelectCommand = GetSelectAllCmd();  // Generates Query: "SELECT * FROM " + tableName
 
    // Get schema from database
    adapter.MissingSchemaAction = MissingSchemaAction.AddWithKey;
 
    // Rename table
    adapter.TableMappings.Add("Table", tableName);
 
    // Get data
    adapter.Fill(ds);
 
    // Do we have errors?
    if(ds.HasErrors)
        ds.RejectChanges();
    else
        ds.AcceptChanges();
 
    // Free resources
    adapter.Dispose();
 
    return ds;
}

Everything seems working fine, but the schema isn't transfered correctly. The MaxLength property of the DataColumn member has the value of the longest entry in the database. For example if there is a column called 'name' and the database has an entry like 'John' the MaxLength property is 4. But I specified the 'name' column to allow 100 chars while creating the table (... name VARCHAR(100) NOT NULL, ...).

Furthermore I'm not able to change the MaxLength property. The following has no effect:

ds.Tables[tableName].Columns["name"].MaxLength = 100;

So I'm not able to insert a name to the 'name' column that is longer than 4. I get the error "The value violates the MaxLength limit of this column". Many thanks in advance!!!

Regards, mYkel

P.S.: Sorry I also posted this in SQL/ADO/ADO.NET forum but perhaps it fits better here...

Re: Connecting to MySQL with ODBC

Heath Stewart3-Mar-04 6:07

Heath Stewart

3-Mar-04 6:07

The schema that you get is relative to the result set. If you want to have a specific schema that matches your tables, I suggest you create a typed DataSet by using either the xsd.exe utility that ships with the .NET Framework SDK to create a typed DataSet class from an XML Schema, or add a new DataSet class in Visual Studio .NET and either re-create your tables (and optionally your keys and relationships), or drag and drop your tables from the Server Explorer after adding a connection object to your database.

Use that typed DataSet in your OdbcDataAdapter calls (like Fill) and in your queries. If you're using the designer in VS.NET for a DataGrid or some other data-bound control, it gives you nice design-time support for specific table names and columns. If also provides faster access to data when using the typed table and column names because they reference the DataTable and DataColumn objects directly, instead of using a string name that requires several looks ups.

If you don't want to use a typed DataSet, you can also add a columns to your TableMapping property. See the DataTableMapping class and its ColumnMappings property documentation in the .NET Framework SDK for more information.

Microsoft MVP, Visual C#
My Articles

Re: Connecting to MySQL with ODBC

sps-itsec463-Mar-04 8:41

sps-itsec46

3-Mar-04 8:41

I got it working with a typed DataSet... thanks very much for your help Heath!!! You're the best! Rose | [Rose]

Regards, mYkel

Mail samples

jimaya3-Mar-04 2:25

jimaya

3-Mar-04 2:25

Hello guys!

I've seen the samples here and I have a few questions:

1 - Is it possible to download the messages with a component and onde they are downloaded I
can't download with outlook?

2 - Can I save the messages in a archive like a pst?

Greetings,
Agus

Re: Mail samples

joan_fl3-Mar-04 5:24

joan_fl

3-Mar-04 5:24

The below article should help you with downloading attachments...
http://www.codeproject.com/csharp/despop3client.asp[^]

-------------------------------
Joan
MomComputerGeek.com

GUI Unit Testing in C#?

Chris Gruber3-Mar-04 1:59

Chris Gruber

3-Mar-04 1:59

Hello,

I would like to use the NUnit Framework on GUIs.

Currently I´m using an instance of my form to get all controls. I am then filling some textboxes and push some buttons and 'assert' for errors. But this isn´t working anymore as soon as a modal dialog pops up.

Are there any tools for .NET to do this (like Abbot for JUnit)?

API question

neilxp2-Mar-04 22:43

neilxp

2-Mar-04 22:43

Simple: How can i use windows API in C#

Re: API question

Corinna John2-Mar-04 23:04

Corinna John

2-Mar-04 23:04

Simple: Declare the functions using System.Runtime.InteropServices.DllImportAttribute.

[DllImport("user32.dll")]
private static extern IntPtr GetDC(IntPtr hWnd);

How can I type cast an string as an htmlTable ?

MasudM2-Mar-04 20:34

MasudM

2-Mar-04 20:34

Hi I have a problem with type casting . I have the string which is the name of one control(HtmlTable) . I know the control I want to type cast the name as the control.
I tried the following and I get "Invalid Casting ! "

string TableName = "Table1";
(HtmlTable)(TableName)

and

(HtmlTable)((object)(TableName))

Thanks

Re: How can I type cast an string as an htmlTable ?

Corinna John2-Mar-04 22:11

Corinna John

2-Mar-04 22:11

Do you know the container of the control? Then you can find the name in the Controls colleciton:

HtmlTable myTable = null;
foreach(Control ctl in container.Controls){
if(ctl.Name == tableName){
myTable = (HtmlTable)ctl;
break;
}
}

If you don't know, where the control is, you can find it "by name":

String tableName = "Table1";
Object ctl = null;
System.Reflection.FieldInfo info = this.GetType().GetField(tableName);
if(info != null){
ctl = info.GetValue(this);
}
HtmlTable myTable = (HtmlTable)ctl;

Re: How can I type cast an string as an htmlTable ?

Heath Stewart3-Mar-04 6:00

Heath Stewart

3-Mar-04 6:00

Or by referencing the container control, you can use FindControl, passing the name. Cast the return (after checking for null) to an HtmlTable then.

Microsoft MVP, Visual C#
My Articles

Re: How can I type cast an string as an htmlTable ?

MasudM5-Mar-04 1:31

MasudM

5-Mar-04 1:31

thanks that really helped

How To convert Xml to Html

Inam2-Mar-04 18:01

Inam

2-Mar-04 18:01

How can i convert an xml file to html file. Actually i want to provide the xml file and xsl file to the function and it will give me a file with .htm or .html extension.
Thanx in advance
Regards
minamkhan

Inam

Re: How To convert Xml to Html

Hojtha Karlsson2-Mar-04 22:15

Hojtha Karlsson

2-Mar-04 22:15

Take a look at this example:

http://www.csharpfriends.com/Articles/getArticle.aspx?articleID=64

M Mad | :mad:

tti

Clickety

Mazdak3-Mar-04 5:30

Mazdak

3-Mar-04 5:30

http://www.csharpfriends.com/Articles/getArticle.aspx?articleID=64[^]

Mazy

"A bank is a place that will lend you money if you can prove that you don't need it." - Bob Hope

Re: How To convert Xml to Html

Heath Stewart3-Mar-04 3:59

Heath Stewart

3-Mar-04 3:59

See the System.Xml.Xsl.XslTransform class documentation in the .NET Framework SDK. It includes examples, including a sample method that does just that. You still need to construct your XSLT. A good, comprehensive resource for that is on MSDN at http://msdn.microsoft.com/library/en-us/xmlsdk30/htm/xmrefxsltreference.asp[^].

Microsoft MVP, Visual C#
My Articles

About Dispose method

Andres Coder2-Mar-04 17:29

Andres Coder

2-Mar-04 17:29

I don't quite understand what dispose method exacly does. From manual I read that it "frees up ny ressources being used". But what happens to the object after calling dispose method ? Is it destroyer ? Also - is there any link between an object's destructor and dispose method ?

Regards, Desmond

Re: About Dispose method

Meysam Mahfouzi2-Mar-04 18:13

Meysam Mahfouzi

2-Mar-04 18:13

Lately, Heath[^] provided me a very cool link about this subject:

http://www.albahari.com/value%20vs%20reference%20types.html[^]

I hope it helps!

Don't forget, that's

Persian Gulf

not Arabian gulf!

Murphy:
Click Here![^]

I'm thirsty like sun, more landless than wind...

Re: About Dispose method

Heath Stewart3-Mar-04 3:45

Heath Stewart

3-Mar-04 3:45

IDisposable.Dispose (you must implement IDisposable for this to be used correctly) is best used to free native resources (since many classes in .NET use native HANDLEs). You can also use it to dispose child objects and set references to null.

This is not a destructor, though. In fact, many times when the Dispose method cleans-up the resources, it will tell the GC to not call the destructor since there's nothing left to do (be sure you clean-up all resources before doing so, though):

public void Dispose()
{
  // Clean up native resources and any managed resource you might have.
  GC.SuppressFinalize(this);
}

For a more thorough example, see the documentation for the GC.SuppressFinalize method in the .NET Framework SDK.

Microsoft MVP, Visual C#
My Articles

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