c#链接MySQL数据库

最新推荐文章于 2025-07-09 09:54:27 发布

转载最新推荐文章于 2025-07-09 09:54:27 发布 · 484 阅读

文章标签：

#mysql #c# #dataset #textbox #数据库 #string

dotNET 同时被 2 个专栏收录

35 篇文章

订阅专栏

数据库

10 篇文章

订阅专栏

C#链接MySQL数据库

//创建连接字段

private static string connstr = "Data Source = 127.0.0.1;Initial Catalog = wsn;User ID = root; Password = root";

//建立连接
public static MySqlConnection conn = new MySqlConnection(connstr);

public static MySqlCommand com = new MySqlCommand();// 或者new MySqlCommand(sqlCom, conn);//sqlCom为查询语句，也可以后在创建。

//label显示查询的数据库内容

        private static string sqlCom = @"SELECT senserName,LastLinktime FROM senserinfo where lastLinkTime>'2011-09-23' ";
        try
            {
                conn.Open();
                MySqlDataReader dr = null;
                dr = com.ExecuteReader(); //need connect to the database
                label1.Text = "";
                while (dr.Read())//read data
                {
                   label1.Text += String.Format(dr["senserName"] + " " + dr["LastLinktime"]+"\r\n");
                }
                dr.Close();
            }

            finally
            {
                conn.Close();
            }

//利用控件dataGridView显示查询数据库的内容

com.CommandText = sqlCom;
com.Connection = conn;

                MySqlDataAdapter da = new MySqlDataAdapter(com);
                DataSet ds = new DataSet();        //create DataSet object
                DataTable dt = new DataTable(); //create DataTable object
                da.Fill(ds, "senserinfo");
                dt = ds.Tables["senserinfo"];
                dataGridView1.DataSource = dt; //band the Datatable to the dataGridView1

//操作数据库

           try
            {
                conn.Open();
                if (textBox1.Text != "")
                {
                    string insertSQL = string.Format("INSERT into senserinfo(senserName,lastLinkTime) values('{0}','{1}')", textBox1.Text.ToString(), System.DateTime.Now.ToString());
                    com.CommandText = insertSQL;
                    com.Connection = conn;
                    int i = com.ExecuteNonQuery();
                    if (i > 0)
                        MessageBox.Show("记录插入成功。");
                }
            }
            finally
           {
               conn.Close();
               update();//更新控件函数
           }