Sunday, April 29, 2012
.Net DB connection
try
{
MySqlConnection con = new MySqlConnection("Server=localhost; User=root; Password=''; Database=test");
con.Open();
MySqlCommand cmd = con.CreateCommand();
cmd.CommandText = "select * from test";
MySqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
MessageBox.Show("" + rdr["name"]);
}
//rdr.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
Subscribe to:
Posts (Atom)