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; } } }
C#从数据库mysql读取数据
免责声明:文章转载自《C#从数据库mysql读取数据》仅用于学习参考。如对内容有疑问,请及时联系本站处理。
上篇Java Array数组 遍历 四种方式(包含 Lambda 表达式遍历)SpringBoot2.0--- 多数据源配置下篇
宿迁高防,2C2G15M,22元/月;香港BGP,2C5G5M,25元/月 雨云优惠码:MjYwNzM=