c#的sql查询demo

二、代码如下：

    private void dbService( string sql )
    {
            MySqlConnection sqlCon = new MySqlConnection( "Database=caretop;Data Source=127.0.0.1;User Id=root;Password=asd123" );
            MySqlCommand cmd = new MySqlCommand( sql, sqlCon );
            MySqlDataReader reader = null;
            try
            {
                /* 打开连接 */
                sqlCon.Open();
                /* 执行查询，并将结果返回给读取器 */
                reader = cmd.ExecuteReader();
                if ( reader.HasRows )
                {
                    while ( reader.Read() )
                    {
                        string rlt = "工号：" + reader[0].ToString() + "	姓名：" + reader[1].ToString() + " ";
                        this.rlt.Items.Add( rlt );
                    }
                }else{
                    MessageBox.Show( "Error =" + "查无此人，请确认查询参数！" );
                }
            }
            catch ( Exception ex ) {
                MessageBox.Show( "Error =" + ex.Message.ToString() );
            }
            finally
        {
            reader.Close();
            sqlCon.Close();
        }
    }