c# im combination with mysql

EDN Admin · Dec 29, 2012

Hello im totally new to c# just started of yesterday and i have this question 
I already suceeded to put data in a database using c# what i now want do do is
get information out of the database and put it in a var!

I want to do something like this: This is how i did it in php!
(php) ------ 
<span style="white-space

re $commando2="SELECT * FROM `leden`"; 
<span style="white-space

re $resultaat2=mysql_query($commando2); 
<span style="white-space

re while($array=mysql_fetch_array($resultaat2)){ 
<span style="white-space

re $email2=$array;<span style="white-space

re
}
----
and this : (php) 
 

$commando3="SELECT * FROM `leden` WHERE id=$memberid "; 
<span style="white-space

re $resultaat3=mysql_query($commando3); 
<span style="white-space

re $array=mysql_fetch_array($resultaat3); 
<span style="white-space

re $home=$array[home]; 
<span style="white-space

re $sex=$array[sex]; 
$active=$array[active];

-----
I used this line to put information in the sql database
private void Form1_Load(object sender, EventArgs e) 
{ sqlClient.Insert("namen", "id,age,naam", "NULL,44,wayne"); }

I dont know how to do this with c#
I have downloaden my c# mysql settup class from a website and it goes as follows:
using System; 
using System.Collections.Generic; 
using System.Linq; 
using System.Text; 
using MySql.Data.MySqlClient; 
 
namespace MySQLClass 
{ 
 
//Dont forget to add the MySQL.Data dll to your projects references 
//It can be downloaded for free from MySQLs official website. 
//Link to the .NET Connector (.dll file) http://dev.mysql.com/downloads/connector/net/ 
 
 
class MySQLClient 
{ 
MySqlConnection conn = null; 
 
 
#region Constructors 
public MySQLClient(string hostname, string database, string username, string password) 
{ 
conn = new MySqlConnection("host=" + hostname + ";database=" + database +";username=" + username +";password=" + password +";"); 
} 
 
public MySQLClient(string hostname, string database, string username, string password, int portNumber) 
{ 
conn = new MySqlConnection("host=" + hostname + ";database=" + database + ";username=" + username + ";password=" + password + ";port=" + portNumber.ToString() +";"); 
} 
 
public MySQLClient(string hostname, string database, string username, string password, int portNumber, int connectionTimeout) 
{ 
conn = new MySqlConnection("host=" + hostname + ";database=" + database + ";username=" + username + ";password=" + password + ";port=" + portNumber.ToString() + ";Connection Timeout=" + connectionTimeout.ToString()
+";"); 
} 
#endregion 
 
#region Open/Close Connection 
private bool Open() 
{ 
//This opens temporary connection 
try 
{ 
conn.Open(); 
return true; 
} 
catch 
{ 
//Here you could add a message box or something like that so you know if there were an error. 
return false; 
} 
} 
 
private bool Close() 
{ 
//This method closes the open connection 
try 
{ 
conn.Close(); 
return true; 
} 
catch 
{ 
return false; 
} 
} 
#endregion 
 
public void Insert(string table, string column, string value) 
{ 
//Insert values into the database. 
 
//Example: INSERT INTO names (name, age) VALUES(John Smith, 33) 
//Code: MySQLClient.Insert("names", "name, age", "John Smith, 33"); 
string query = "INSERT INTO " + table + " (" + column + ") VALUES (" + value + ")"; 
 
try 
{ 
if (this.Open()) 
{ 
//Opens a connection, if succefull; run the query and then close the connection. 
 
MySqlCommand cmd = new MySqlCommand(query, conn); 
 
cmd.ExecuteNonQuery(); 
this.Close(); 
} 
} 
catch { } 
return; 
} 
 
public void Update(string table, string SET, string WHERE) 
{ 
//Update existing values in the database. 
 
//Example: UPDATE names SET name=Joe, age=22 WHERE name=John Smith 
//Code: MySQLClient.Update("names", "name=Joe, age=22", "name=John Smith"); 
string query = "UPDATE " + table + " SET " + SET + " WHERE " + WHERE + ""; 
 
if (this.Open()) 
{ 
try 
{ 
//Opens a connection, if succefull; run the query and then close the connection. 
 
MySqlCommand cmd = new MySqlCommand(query, conn); 
cmd.ExecuteNonQuery(); 
this.Close(); 
} 
catch { this.Close(); } 
} 
return; 
} 
 
public void Delete(string table, string WHERE) 
{ 
//Removes an entry from the database. 
 
//Example: DELETE FROM names WHERE name=John Smith 
//Code: MySQLClient.Delete("names", "name=John Smith"); 
string query = "DELETE FROM " + table + " WHERE " + WHERE + ""; 
 
if (this.Open()) 
{ 
try 
{ 
//Opens a connection, if succefull; run the query and then close the connection. 
 
MySqlCommand cmd = new MySqlCommand(query, conn); 
cmd.ExecuteNonQuery(); 
this.Close(); 
} 
catch { this.Close(); } 
} 
return; 
} 
 
public Dictionary<string, string> Select(string table, string WHERE) 
{ 
//This methods selects from the database, it retrieves data from it. 
//You must make a dictionary to use this since it both saves the column 
//and the value. i.e. "age" and "33" so you can easily search for values. 
 
//Example: SELECT * FROM names WHERE name=John Smith 
// This example would retrieve all data about the entry with the name "John Smith" 
 
//Code = Dictionary<string, string> myDictionary = Select("names", "name=John Smith"); 
//This code creates a dictionary and fills it with info from the database. 
 
string query = "SELECT * FROM " + table + " WHERE " + WHERE + ""; 
 
Dictionary<string, string> selectResult = new Dictionary<string, string>(); 
 
if (this.Open()) 
{ 
MySqlCommand cmd = new MySqlCommand(query, conn); 
MySqlDataReader dataReader = cmd.ExecuteReader(); 
 
try 
{ 
while (dataReader.Read()) 
{ 
 
for (int i = 0; i < dataReader.FieldCount; i++) 
{ 
selectResult.Add(dataReader.GetName(i).ToString(), dataReader.GetValue(i).ToString()); 
} 
 
} 
dataReader.Close(); 
} 
catch { } 
this.Close(); 
 
return selectResult; 
} 
else 
{ 
return selectResult; 
} 
} 
 
public int Count(string table) 
{ 
//This counts the numbers of entries in a table and returns it as an integear 
 
//Example: SELECT Count(*) FROM names 
//Code: int myInt = MySQLClient.Count("names"); 
 
string query = "SELECT Count(*) FROM " + table + ""; 
int Count = -1; 
if (this.Open() == true) 
{ 
try 
{ 
MySqlCommand cmd = new MySqlCommand(query, conn); 
Count = int.Parse(cmd.ExecuteScalar() + ""); 
this.Close(); 
} 
catch { this.Close(); } 
return Count; 
} 
else 
{ 
return Count; 
} 
} 
} 
} 

 

 

[url=http://social.msdn.microsoft.com/Forums/en-US/csharpgeneral/thread/ef37eb19-3c77-4dc5-aa6c-917a6da7fdf2]View the full article[/url]

c# im combination with mysql

EDN Admin

Well-known member

Similar threads