首页 > > 程序设计 > Java技术 >

C#操作MySQL数据库-----HelloWorld

2018-06-18 05:07:30来源：未知阅读 ()

这里采用在visual studio 2010中通过MySql.Data.dll、MySql.Web.dll来连接mysql数据库，

之后便进行数据的插入和查询。

Program.cs文件内容如下：

C#代码

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using MySql.Data.MySqlClient;
using System.Data;
namespace DatabaseProgram
{
class Program
{
static string mysqlConnectionString = "Server=localhost;Database=csharp;Uid=root;Pwd=admin";
static void Main(string[] args)
{
InsertData();
SelectData();
}
//向数据库插入数据
public static void InsertData()
{
MySqlConnection conn = new MySqlConnection(mysqlConnectionString);
MySqlCommand command;
conn.Open();
try
{
command = conn.CreateCommand();
command.CommandText = "INSERT INTO phoneBook(id,name,mobile) VALUES(@id,@name,@mobile)";
command.Parameters.AddWithValue("@id", 2);
command.Parameters.AddWithValue("@name", "yangjianzhou");
command.Parameters.AddWithValue("@mobile", "1234567890");
command.ExecuteNonQuery();
}
catch (Exception)
{
}
finally
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
}
}
//从数据库中读取数据
public static void SelectData()
{
MySqlConnection conn = new MySqlConnection(mysqlConnectionString);
conn.Open();
MySqlDataReader dataReader = null;
MySqlCommand command = null;
try
{
command = conn.CreateCommand();
command.CommandText = "SELECT * FROM phoneBook";
dataReader =command.ExecuteReader();
Console.WriteLine();
while (dataReader.Read())
{
Console.WriteLine("id={0}, name={1}, mobile={2}", dataReader.GetInt16(0), dataReader.GetString(1), dataReader.GetString(2));
Console.WriteLine();
}
}
catch (Exception)
{
}
finally
{
if (!dataReader.IsClosed)
{
dataReader.Close();
}
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
}
}
}
}