Click here to Skip to main content
13,092,310 members (65,871 online)
Rate this:
Please Sign up or sign in to vote.
See more:
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 19:08pm
Rate this: bad
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; 
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(); 
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"]); 

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

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web03 | 2.8.170813.1 | Last Updated 26 Mar 2013
Copyright © CodeProject, 1999-2017
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