c#+mysql+读取+数据库文件大小_C#从数据库mysql读取数据

usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Threading.Tasks;usingSystem.Windows.Forms;usingMySql.Data.MySqlClient;namespace电子商务

{public partial classForm1 : Form

{publicForm1()

{

InitializeComponent();

}private void Form1_Load(objectsender, EventArgs e)

{

}private void button1_Click(objectsender, EventArgs e)

{string str = "Host=localhost;User ID=root;Password=;Port = 3306;DataBase=animals;Charset=utf8;";

MySqlConnection conn= newMySqlConnection(str);

conn.Open();// 拿到数据库并打开连接

//string sql = "select *from student";//MySqlCommand cmd = new MySqlCommand(sql, conn);//MySqlDataAdapter mda = new MySqlDataAdapter(cmd);//DataSet ds = new DataSet();//mda.Fill(ds);//dataGridView1.DataSource = ds.Tables[0];

MySqlDataReader dr = cmd.ExecuteReader();

//conn.Close();

/*1.访问数据库的五大步骤

2.拿到要发送的sql语句

3.执行 sql 语句

4.拿到执行后的聚过

5.关闭连接 切记关闭连接*/

1 拿到数据库的连接 并打开连接

//string url = "User ID=root;Password=;Host=localhost;Port=3306;Database=xx;charset=xx;";//MySqlConnection con = new MySqlConnection(url);//con.Open();

2.要拿到要发送的sql语句

//string sql = "select id from student where name=‘kobe‘";//MySqlCommand com = new MySqlCommand(sql, con);

3 执行 sql 语句

//MySqlDataReader reader = com.ExecuteReader();//reader.Read();//Read() 每次调用 都会从结果集中返回一行数据//reader.GetInt32(0);

/*1.访问数据库的五大步骤

2.拿到要发送的sql语句

3.执行 sql 语句

4.拿到执行后的聚过

5.关闭连接 切记关闭连接*/

//1 拿到数据库的连接 并打开连接

string url = "User ID=root;Password=;Host=localhost;Port=3306;Database=students;";

MySqlConnection con= newMySqlConnection(url);

con.Open();//2.要拿到要发送的sql语句

string sql = "select *from student where name=‘kobe‘";

MySqlCommand com= newMySqlCommand(sql, con);//3 执行 sql 语句

MySqlDataReader reader =com.ExecuteReader();

reader.Read();//Read() 每次调用 都会从结果集中返回一行数据//reader.GetInt32(0);

Console.WriteLine(reader.GetInt32(0));

con.Close();对数据库进行 增 删 改 查1 拿到数据库的连接 并打开连接

//string url = "User ID=root;Password=root;Host=localhost;Port=3306;Database=students;";//MySqlConnection con = new MySqlConnection(url);//con.Open();//string sql = "insert into student values(11,‘hahahaha‘,‘man‘,6)";//添加信息//MySqlCommand cmd = new MySqlCommand(sql, con);//int result = cmd.ExecuteNonQuery();//Console.WriteLine("数据库打开结果："+result);//con.Close();//FindStudent("kobe");

}public static bool FindStudent(stringname)

{bool b = false;string url = "User ID=root;Password=root;Host=localhost;Port=3306;Database=students;";

MySqlConnection con= newMySqlConnection(url);

con.Open();string sql = "select *from studnet where name=‘{0}‘";

sql= string.Format(sql, name);//Console.WriteLine(sql);

MySqlCommand cmd = newMySqlCommand(sql, con);

MySqlDataReader reader=cmd.ExecuteReader();

b=reader.Read();returnb;

}

}

}