MysqlConnection is not defined

[Chris]

Hi,

I need to access data from Mysql database with asp.net 2.0.
I installed the Mysql/Connector Net 1.1.
I did this:
<%@ Page Language="VB" debug="true" %>
<%@ Import Namespace = "System.Data" %>
<%@ Import Namespace = "MySql.Data.MySqlClient" %>
<script language="VB" runat="server">
Sub Page_Load(sender As Object, e As EventArgs)

Dim myConnection As MySqlConnection
....

This gives an error: "MysqlConnection is not defined"

Any idea how to solve this?
Thanks
Chris

 

[Mark Rae]

Any idea how to solve this?

Add a reference to MySql in your project.

 

[Cowboy \(Gregory A. Beamer\)]

First, you need a project reference, which will solve this issue. Second,
you really should code in a Code Behind (Code Beside for 2.0) file instead
of embedded in the page, as it fosters separation of code and UI>

--
Gregory A. Beamer

*************************************************
Think Outside the Box!
*************************************************

 

[Chris]

Thanks both for replying.
I already use code-behind, but for keeping it simple here, i put it in one
file.

But, sorry if it"s stupid, what do you mean with "you need a project
reference"?

 

[Chris]

I'm working with VWD, and there, in my project, i did: Add reference.
In the window, i can see a lot of things, but nothing about Mysql ....