next »

[TechnicalTalk]

 TechnicalTalk » Programming and Web Development » .NET
 Connecting Vb.net with Mysql database ?

[Mayee]

Mayee  

 Connecting Vb.net with Mysql database ?

Hi Everybody,
I have a doubt here that whether how to connect mysql database, which is from Vb.net 2005. What are the other operating systems which supports ms.net ?
Thanks.

[singam]

singam  

 Re: Connecting Vb.net with Mysql database ?

Step# 1:
Create MySQL Databse with cPanel and phpMyAdmin
go here & you'll find the easy way to do this ( hxxp: teamtutorials. com/web-development-tutorials/create-mysql-databse-with-cpanel-and-phpmyadmin )

Step# 2:
How to Access a MySQL Database Using PHP
go here & you'll find the easy way to do this ( hxxp: teamtutorials. com/web-development-tutorials/how-to-access-a-mysql-database-using-php )

Step# 3:
Inserting Data Into a Mysore Database using PHP
go here & you'll find the easy way to do this ( hxxp: teamtutorials. com/web-development-tutorials/php-tutorials/inserting-data-into-a-mysql-database-using-php )
===================

Teeth Whitening Glasgow |  Tooth Whitening Glasgow 

[Shan]

Shan  

 Re: Connecting Vb.net with Mysql database ?

[MYSQL with C#]

MYSQL with C#
string connectionString = "server=servername;database=databasename;uid=databaseusername;pwd=databasepassword";
SqlConnection mySqlConnection = new SqlConnection(connectionString);

string selectString = "SELECT field1,field2,field3 " + "FROM tablename ";

SqlCommand mySqlCommand = mySqlConnection. CreateCommand();

mySqlCommand. CommandText = selectString;

SqlDataAdapter mySqlDataAdapter = new SqlDataAdapter();

mySqlDataAdapter. SelectCommand = mySqlCommand;

DataSet myDataSet = new DataSet();

mySqlConnection. Open();

//retriving rows from the table
string dataTableName = "Tablename";
mySqlDataAdapter. Fill(myDataSet, dataTableName);

DataTable myDataTable = myDataSet. Tables[dataTableName];

foreach (DataRow myDataRow in myDataTable. Rows)
{
Console. WriteLine("Field1 = " + myDataRow["field01"]);
Console. WriteLine("Field2 = " + myDataRow["field02"]);
Console. WriteLine("Field3 = " + myDataRow["field03"]);
}

mySqlConnection. Close();

[Admin]

Admin  

 Re: Connecting Vb.net with Mysql database ?

@anuproy: Good code anup. Thnaks for posting it on the thread.

[msdnguide]

msdnguide  

 Re: Connecting Vb.net with Mysql database ?

Please see this link to know how to do it VB.NET-MySQL-Connection