Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C# ADO.NET MySQL
i want to connect mysql database hosted on remote server from my computer. what code should i do for it? plz reply anyone.
Posted 25-Mar-13 20:08pm
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

try this code
 

#region Using directives 
 

using System; 
using System.Data; 
using System.Data.SqlClient; 
 
#endregion 
 
namespace testConnect1 
{ 
class SqlTest1 
{ 
static void Main() 
{ 
string connectionString = "server=localhost;database=test;uid=denis;pwd=dhoctor"; 
 
SqlConnection mySqlConnection = new SqlConnection(connectionString); 
 
string selectString = "SELECT field01, field02, field03 " + "FROM test "; 
 
SqlCommand mySqlCommand = mySqlConnection.CreateCommand(); 
 
mySqlCommand.CommandText = selectString; 
 
SqlDataAdapter mySqlDataAdapter = new SqlDataAdapter(); 
 
mySqlDataAdapter.SelectCommand = mySqlCommand; 
 
DataSet myDataSet = new DataSet(); 
 
mySqlConnection.Open(); 
 
Console.WriteLine("Retrieving rows from the Test table"); 
string dataTableName = "Test"; 
mySqlDataAdapter.Fill(myDataSet, dataTableName); 
 
DataTable myDataTable = myDataSet.Tables[dataTableName]; 
 
foreach (DataRow myDataRow in myDataTable.Rows) 
{ 
Console.WriteLine("Field01 = " + myDataRow["field01"]); 
Console.WriteLine("Field02 = " + myDataRow["field02"]); 
Console.WriteLine("Field03 = " + myDataRow["field03"]); 
} 
 
mySqlConnection.Close(); 
} 
} 
}
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 350
1 Jochen Arndt 190
2 Richard MacCutchan 135
3 Sergey Alexandrovich Kryukov 130
4 DamithSL 105
0 OriginalGriff 6,045
1 DamithSL 4,601
2 Maciej Los 4,087
3 Kornfeld Eliyahu Peter 3,480
4 Sergey Alexandrovich Kryukov 3,310


Advertise | Privacy | Mobile
Web03 | 2.8.141220.1 | Last Updated 26 Mar 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100