DotNet With MySQL

You can connect to MySQL like any other database .

The primary requirement is you need a data connection provider

A data provider in the .NET Framework serves as a bridge between an application and a data source. A data provider is used to retrieve data from a data source and to reconcile changes to that data back to the data source.

See For Details : http://msdn.microsoft.com/en-us/library/s7ee2dwt(VS.71).aspx

MySql.Data.MySqlClient Namespace contains the class for connecting to MySQL

Assembly: MySql.Data (in MySql.Data.dll)

This dll file is contained in the mysql connector zip file That we can down load from the net

MySQL Connector Net 5.0.3 or any Other .NET connectors

http://dev.mysql.com/downloads/connector/net/5.0.html
http://www.devart.com/dotconnect/mysql/download.html

Install the connector it will register MySql.Data.dll in your global assembly cache.

or you can mannually do it by using the command gacutil /i MySql.Data.dll From your dotnet command prompt

mysql.data.mysql namespace contains the classes you required to connect to mysql database.

http://dev.mysql.com/doc/refman/5.1/en/connector-net-ref-mysqlclient.html

Now you can start coding see the link for more details

http://dev.mysql.com/doc/refman/5.1/en/connector-net-tutorials-intro.html

========================================================

Requirements:

MySQL Server
Mysql Server 5.0 or any other versions.
.Net Connector
MySQL Connector Net 5.0.3 or any Other .NET connectors

http://dev.mysql.com/downloads/connector/net/5.0.html
http://www.devart.com/dotconnect/mysql/download.html

UI For MySQL Server

SQLyog Or any Other User Interface for MYSQL for a better user experience.
if you are very comfortable with command prompt and mysql you can use that one.

For .NET

Visusl Studio 2005 or later.

=======================================================

How To Create A Banner for Windows Form

Its Nice to See banners on the top of winforms, its simple just add one picture box to your form, then inside load of the form

write the code.

PictureBox1.Image = GetBanner(pbBanner.Width, pbBanner.Height, " Welcome")

Public Function GetBanner(ByVal Width As Integer, ByVal Height As Integer, ByVal bannerText As String) As Image

Dim bmp As New Bitmap(Width, Height)
Dim gImage As Graphics
gImage = Graphics.FromImage(bmp)

Dim rect As New Rectangle(0, 0, Width, Height)

Dim mybrush As New LinearGradientBrush(rect, Color.DodgerBlue, Color.White, LinearGradientMode.Vertical)

'mybrush.SetSigmaBellShape(0.5, 1)

Dim drawString As String = bannerText
Dim drawFont As New Font("Microsoft Sans Serif", 11, FontStyle.Bold)
Dim drawBrush As New SolidBrush(Color.DarkBlue)
Dim drawPoint As New PointF(Width / 2.8, Height / 3)

gImage.FillRectangle(mybrush, 0, 0, Width, Height)

gImage.DrawString(drawString, drawFont, drawBrush, drawPoint)

Return bmp

End Function